I am trying to upgrade an old DNN site from 4.9.5 to 5.4.4, with the aim of ultimately getting to the current DNN version.
The upgrade produces two errors:
Executing Application Upgrades: 05.01.00 Error! Executing Application Upgrades: 05.03.00 Error! I have seen quite a few status reports having those two fail without finding an explanation or solution for it. Am I right in my assumption that during that phase, changes to web.config are being made? I checked the DNN events after upgrading and there were no entries relating to those errors. After some testing the site works, but I am afraid that this may cause problems later with another upgrade or during normal website usage.
Another strange thing is, that after upgrading to 5.4.4 the control bar is visible for "normal" site visitors and they can even add empty modules to pages (they cannot edit the module content though). Thanks for any hints on where to look!
Michael TobischDNN★MVP
Posted By Michael Tobisch on 02 Oct 2019 07:41 AM Andreas, please check the folder permissions before you do an upgrade. It could be a reason... Happy DNNing! Michael
Posted By Joe Craig on 02 Oct 2019 07:50 AM You may also find more details regarding the errors in /Portals/_default/logs. Look for a file with "upgrade" in its name, and also the yyyy.mm.dd.log.resources files.
Hello Michael and Joe, Thanks a lot for the quick replies! I have repeated the upgrade and made sure that permissions were inherited correctly as recommended with the same two scripts failing. I checked /Portals/_default/logs and could not find more details.
I have been digging a bit and found the source code for UpgradeToVersion_510() and UpgradeToVersion_530() and will now try to find out at which step it fails inside of each of the two functions.
Am glad I have the test system setup as a virtual system, so I can easily go back in time and repeat the upgrade.
Andreas
Another update.....I now have a stack trace for the first one (5.1.0). Maybe that is already helpful. Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object. at DotNetNuke.Entities.Tabs.TabController.GetTabsByNameAndPortal(String TabName, Int32 PortalId) at DotNetNuke.Entities.Tabs.TabController.GetTabByNameAndParent(String TabName, Int32 PortalId, Int32 ParentId) at DotNetNuke.Services.Install.Install.HostTabExists(String TabName) at DotNetNuke.Services.Install.Install.UpgradeToVersion_510() at DotNetNuke.Services.Install.Install.UpgradeApplication() at DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Maybe it is related to this one: https://www.dnnsoftware.c...object-after-upgrade
Running a "select * from sys.databases" query revealed the compatibility_level of the DNN database is at level 90. That's bad, right?
Is there supposed to be a "Dashboard" tab in the tabs table for portal 0? I have one for portal NULL in the database. There is, a "Dash Board" in the tabs table for portal 0 though. Strange.
Ahhh, I did a mistake while testing, I tested without running the DB scripts first :( Also the exception and the previous stack is most likely something else and caused by not running the DB scripts before executing the 5.1.0 method.
OK. Now this stack trace is most likely better: Event code: 3005 Event message: An unhandled exception has occurred. Event time: 10/3/2019 2:54:50 AM Event time (UTC): 10/3/2019 12:54:50 AM Event ID: cdc9eca5f4d24486b66f91d465697741 Event sequence: 58 Event occurrence: 4 Event detail code: 0 Application information: Application domain: /LM/W3SVC/2/ROOT-3-132145370610780278 Trust level: Full Application Virtual Path: / Application Path: D:\Inetpub\wwwroot\ Machine name: XXXXXXXXXXX Process information: Process ID: 4492 Process name: w3wp.exe Account name: NT AUTHORITY\NETWORK SERVICE Exception information: Exception type: SqlException Exception message: Violation of UNIQUE KEY constraint 'IX_ModuleDefinitions'. Cannot insert duplicate key in object 'dbo.ModuleDefinitions'. The duplicate key value is (Languages). The statement has been terminated. 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Install.Install.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, String BusinessControllerClass, Boolean IsPortable, Boolean Premium, Boolean Admin) at DotNetNuke.Services.Install.Install.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, Boolean Premium, Boolean Admin) at DotNetNuke.Services.Install.Install.UpgradeToVersion_510() at DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Request information: Request URL: https://www.sys-manage.co...ll.aspx?mode=upgrade Request path: /Install/install.aspx User host address: 192.168.2.111 User: Is authenticated: False Authentication Type: Thread account name: NT AUTHORITY\NETWORK SERVICE Thread information: Thread ID: 51 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Install.Install.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, String BusinessControllerClass, Boolean IsPortable, Boolean Premium, Boolean Admin) at DotNetNuke.Services.Install.Install.AddModuleDefinition(String DesktopModuleName, String Description, String ModuleDefinitionName, Boolean Premium, Boolean Admin) at DotNetNuke.Services.Install.Install.UpgradeToVersion_510() at DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details:
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.