DNN Error: DotNetNuke.Site ExportImport Installation failed while upgrade CMS from versions 9.1 to 9.3

0
I am getting this error message when upgrading site from 9.1 to 9.3.1. Can 
Does someone suggest how to get rid of this error?

    StartJob Starting Installation
    Info Starting Installation - SiteExportImport
    Info Starting Installation - Assembly
    Info Assembly already registered - bin\DotNetNuke.SiteExportImport.dll
    Info Creating backup of previous version - 
    bin\DotNetNuke.SiteExportImport.dll
    Info Created - bin\DotNetNuke.SiteExportImport.dll
    Info Assembly already registered - 
    bin\DotNetNuke.SiteExportImport.Library.dll
    Info Creating backup of previous version - 
    bin\DotNetNuke.SiteExportImport.Library.dll
    Info Created - bin\DotNetNuke.SiteExportImport.Library.dll
    Info Assembly already registered - bin\LiteDB.dll
    Info Creating backup of previous version - bin\LiteDB.dll
    Info Created - bin\LiteDB.dll
    Info Binding redirect added for assembly - bin\LiteDB.dll
    Info Component installed successfully - Assembly
    Info Starting Installation - ResourceFile
    Info Expanding Resource file
    Info Creating backup of previous version - 
    App_LocalResources\ExportImport.resx
    Info Created - App_LocalResources/ExportImport.resx
    Info Resource Files created
    Info Component installed successfully - ResourceFile
    Info Starting Installation - Script
    Info Begin Sql execution
    Info Creating backup of previous version - 
    Providers\DataProviders\SqlDataProvider\09.03.00.SqlDataProvider
    Info Created - 
    Providers\DataProviders\SqlDataProvider\09.03.00.SqlDataProvider
    Info Executing 09.03.00.SqlDataProvider
    Info Start Sql execution: 09.03.00.SqlDataProvider file
    Failure SQL Execution resulted in following Exceptions: 
    System.Data.SqlClient.SqlException (0x80131904): There is already an 
    object named 'Export_GetActiveTabModules' in the database. at 
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, 
    Boolean breakConnection, Action`1 wrapCloseInAction) at 




System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e4c8c100-eec4-4cd9-af76-d81e7432a1d0 Error Number:2714,State:3,Class:16 CREATE FUNCTION dbo.[Export_GetActiveTabModules] ( @TabID int, @IncludeDeleted BIT ) RETURNS @ModuleIds TABLE ( ModuleId INT ) AS BEGIN DECLARE @StateId int; SELECT @StateId=StateID FROM dbo.[ContentItems] WHERE TabID=@TabID AND ModuleID=-1; --IF there is versioninig with the tab IF(@StateId IS NOT NULL) BEGIN -- Get all distinct module ids which belong to any published version of the tab INSERT INTO @ModuleIds (ModuleId) SELECT DISTINCT TM.ModuleId From dbo.[TabModules] TM LEFT JOIN dbo.[TabVersions] TV ON TM.TabID=TV.TabId LEFT JOIN dbo.[TabVersionDetails] TVD ON TV.TabVersionId=TVD.TabVersionId WHERE TM.TabId=@TabID AND (TV.IsPublished=1 OR TV.IsPublished IS NULL) AND (@IncludeDeleted = 1 OR TM.IsDeleted = 0) END ELSE BEGIN INSERT INTO @ModuleIds (ModuleId) SELECT DISTINCT ModuleId FROM dbo.[TabModules] WHERE TabID=@TabID AND (@IncludeDeleted = 1 OR IsDeleted = 0) END RETURN; END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e4c8c100-eec4-4cd9-af76-d81e7432a1d0 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[Export_TabModules] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT tm.*, md.FriendlyName,m.InheritViewPermissions,m.IsShareable,m.IsShareableViewOnly, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.TabModules AS tm INNER JOIN dbo.Tabs AS t ON tm.TabID = t.TabID INNER JOIN dbo.Modules AS m ON tm.ModuleID = m.ModuleID INNER JOIN dbo.ModuleDefinitions AS md ON md.ModuleDefID = m.ModuleDefID LEFT OUTER JOIN dbo.Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE tm.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND (@IncludeDeleted = 1 OR tm.IsDeleted = 0) AND COALESCE(tm.LastModifiedOnDate, tm.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tm.LastModifiedOnDate, tm.CreatedOnDate) >= @FromDate) DROP TABLE #ActiveModuleIds END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e4c8c100-eec4-4cd9-af76-d81e7432a1d0 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[Export_TabModuleSettings] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT tms.*, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.TabModuleSettings AS tms INNER JOIN dbo.TabModules AS tm ON tm.TabModuleID = tms.TabModuleID INNER JOIN dbo.Tabs AS t ON tm.TabID = t.TabID LEFT OUTER JOIN dbo.Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE t.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND COALESCE(tms.LastModifiedOnDate, tms.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tms.LastModifiedOnDate, tms.CreatedOnDate) >= @FromDate) DROP TABLE #ActiveModuleIds END System.Data.SqlClient.SqlException (0x80131904): Procedure or function dbo.Export_GetActiveTabModules has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e4c8c100-eec4-4cd9-af76-d81e7432a1d0 Error Number:8144,State:3,Class:16 CREATE PROCEDURE dbo.[Export_Modules] @TabID int, @IncludeDeleted bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT ModuleId INTO #ActiveModuleIds FROM dbo.[Export_GetActiveTabModules](@TabID, @IncludeDeleted) SELECT DISTINCT m.*, md.FriendlyName, u1.Username AS CreatedByUserName, u2.Username AS LastModifiedByUserName FROM dbo.Modules AS m INNER JOIN dbo.TabModules AS tm ON tm.ModuleID = m.ModuleID INNER JOIN dbo.ModuleDefinitions AS md ON md.ModuleDefID = m.ModuleDefID LEFT OUTER JOIN dbo.Users AS u1 ON tm.CreatedByUserID = u1.UserID LEFT OUTER JOIN dbo.Users AS u2 ON tm.LastModifiedByUserID = u2.UserID WHERE tm.TabID = @TabID AND tm.ModuleID IN (SELECT ModuleId FROM #ActiveModuleIds) AND (@IncludeDeleted = 1 OR m.IsDeleted = 0) AND ( COALESCE(m.LastModifiedOnDate, m.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(m.LastModifiedOnDate, m.CreatedOnDate) >= @FromDate) OR COALESCE(tm.LastModifiedOnDate, tm.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tm.LastModifiedOnDate, tm.CreatedOnDate) >= @FromDate) ) DROP TABLE #ActiveModuleIds END 
Info End Sql execution: 09.03.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Rolling back component install - Assembly
Info Restored backup of previous version - bin\DotNetNuke.SiteExportImport.dll
Info Restored backup of previous version - bin\DotNetNuke.SiteExportImport.Library.dll
Info Restored backup of previous version - bin\LiteDB.dll
Info Component rolled back successfully - Assembly
Info Rolling back component install - ResourceFile
Failure Exception - Could not find file 'C:\inetpub\XXXXX\WebRoot\Install\Temp\sti1srdyResources.zip'.
Info Component rolled back successfully - ResourceFile
Info Installation Failed - SiteExportImport
Info Deleted temporary install folder
EndJob Installation Failed

Trying to install separately through the extension but showing me the same issue.

dotnetnuke
dotnetnuke-9
asked on Stack Overflow Sep 10, 2019 by Biswa • edited Sep 10, 2019 by Mehul Kabaria

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0