Hi Mitchel,
it took a little bit longer than i expected to get a complete english development environment. During the tests i've obtained the same results / errors as you below. I've tried to solve the problem myself but i didn't find the last 'pieces' to finish this quest. I strongly suspect the table dnn_PortalAlias and the related procedures during the update. Since this is a multilanguge and multiportal solution it has happened that the PortalAlias / PortalAliasID was deleted and new created - so there is no PortalAliasID = 0. I've deleted as a test the other portals and the aliases and only one PortalAliasID remained and then the update did correctly finish. Below do find the failed update from the original multilanguge and multiportal solution.
Installation Status Report
00:00:00.062 - Installing Version: 4.4.0
00:00:00.078 - Executing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.359 - Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:08.970 - Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log for more information)
00:00:10.158 - Installing MemberRole Provider:
00:00:10.158 - Executing Script: InstallCommon.sql
00:00:11.252 - Executing Script: InstallMembership.sql
00:00:12.065 - Executing Script: InstallProfile.sql
00:00:12.299 - Executing Script: InstallRoles.sql
00:00:12.643 - Upgrading to Version: 4.5.1
00:00:12.690 - Executing Script: 04.04.01.SqlDataProvider Success
00:00:12.815 - Executing Script: 04.05.00.SqlDataProvider Success
00:00:14.737 - Executing Script: 04.05.01.SqlDataProvider Success
00:00:18.207 - Performing General Upgrades
00:00:20.488 - Loading Host Settings:
00:00:20.613 - Configuring SuperUser:
00:00:20.785 - Installing Modules:
00:00:20.801 - Installing Module File HTML_04.05.00_Install: Success
00:00:21.723 - Installing Module File Links_03.03.07_Install: Success
00:00:26.083 - Executing Additional Scripts:
00:00:26.083 - Creating Portal: My Website
00:00:28.350 - Error: Error creating Profile Definitions
00:00:28.350 - Portal failed to install:Error!
00:00:28.350 - Installing Optional Resources:
Installation Complete
Click Here To Access Your Portal
Exception when Portal starts
Object reference not set to an instance of an object.Server Error in '/DMS'
Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current
web request. Please review the stack trace for more information about the error
and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an
instance of an object.
Source Error:
Line 582: Dim objSkin As UI.Skins.SkinInfo
Line 583:
Line 584: PortalId = objPortalAliasInfo.PortalID
Line 585:
Line 586: ' get portal settings
Source File: C:\DotNetNuke_DMS541\Library\Components\Portal\PortalSettings.vb
Line: 584
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) in C:\DotNetNuke_DMS541\Library\Components\Portal\PortalSettings.vb:584
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) in C:\DotNetNuke_DMS541\Library\Components\Portal\PortalSettings.vb:530
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) in C:\DotNetNuke_DMS541\Library\HttpModules\UrlRewrite\UrlRewriteModule.vb:319
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.210
Schema Log
System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogMaster' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 143
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 286
ALTER TABLE dbo.[EventLog] ADD CONSTRAINT [PK_EventLogMaster] PRIMARY KEY CLUSTERED ([LogGUID])
System.Data.SqlClient.SqlException: There is already an object named 'PK_EventLogTypes' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 143
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 286
ALTER TABLE dbo.[EventLogTypes] ADD CONSTRAINT [PK_EventLogTypes] PRIMARY KEY CLUSTERED ([LogTypeKey])
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.EventLogTypes' that match the referencing column list in the foreign key 'FK_EventLog_EventLogTypes'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 143
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 286
ALTER TABLE dbo.[EventLog] ADD
CONSTRAINT [FK_EventLog_EventLogTypes] FOREIGN KEY ([LogTypeKey]) REFERENCES dbo.[EventLogTypes] ([LogTypeKey]),
CONSTRAINT [FK_EventLog_EventLogConfig] FOREIGN KEY ([LogConfigID]) REFERENCES dbo.[EventLogConfig] ([ID])
System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.EventLogTypes' that match the referencing column list in the foreign key 'FK_EventLogConfig_EventLogTypes'.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 143
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 286
ALTER TABLE dbo.[EventLogConfig] ADD
CONSTRAINT [FK_EventLogConfig_EventLogTypes] FOREIGN KEY ([LogTypeKey]) REFERENCES dbo.[EventLogTypes] ([LogTypeKey])
Data Log
System.Data.SqlClient.SqlException: 'FK_EventLogConfig_EventLogTypes' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 143
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in C:\DotNetNuke_DMS541\Library\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 286
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)
BEGIN TRANSACTION
-- Drop constraints from dbo.[Tabs]
ALTER TABLE dbo.[Tabs] DROP CONSTRAINT [FK_Tabs_Portals]
ALTER TABLE dbo.[Tabs] DROP CONSTRAINT [FK_Tabs_Tabs]
-- Drop constraints from dbo.[TabPermission]
ALTER TABLE dbo.[TabPermission] DROP CONSTRAINT [FK_TabPermission_Permission]
ALTER TABLE dbo.[TabPermission] DROP CONSTRAINT [FK_TabPermission_Tabs]
-- Drop constraints from dbo.[TabModules]
ALTER TABLE dbo.[TabModules] DROP CONSTRAINT [FK_TabModules_Modules]
ALTER TABLE dbo.[TabModules] DROP CONSTRAINT [FK_TabModules_Tabs]
-- Drop constraints from dbo.[Modules]
ALTER TABLE dbo.[Modules] DROP CONSTRAINT [FK_Modules_ModuleDefinitions]
ALTER TABLE dbo.[Modules] DROP CONSTRAINT [FK_Modules_Portals]
-- Drop constraints from dbo.[ModuleDefinitions]
ALTER TABLE dbo.[ModuleDefinitions] DROP CONSTRAINT [FK_ModuleDefinitions_DesktopModules]
-- Drop constraints from dbo.[ModuleControls]
ALTER TABLE dbo.[ModuleControls] DROP CONSTRAINT [FK_ModuleControls_ModuleDefinitions]
-- Drop constraints from dbo.[EventLogConfig]
ALTER TABLE dbo.[EventLogConfig] DROP CONSTRAINT [FK_EventLogConfig_EventLogTypes]
-- Drop constraint FK_EventLog_EventLogConfig from dbo.[EventLog]
ALTER TABLE dbo.[EventLog] DROP CONSTRAINT [FK_EventLog_EventLogConfig]
-- Drop constraint FK_ScheduleHistory_Schedule from dbo.[ScheduleHistory]
ALTER TABLE dbo.[ScheduleHistory] DROP CONSTRAINT [FK_ScheduleHistory_Schedule]
-- Drop constraint FK_ScheduleItemSettings_Schedule from dbo.[ScheduleItemSettings]
ALTER TABLE dbo.[ScheduleItemSettings] DROP CONSTRAINT [FK_ScheduleItemSettings_Schedule]
-- Drop constraint FK_FolderPermission_Permission from dbo.[FolderPermission]
ALTER TABLE dbo.[FolderPermission] DROP CONSTRAINT [FK_FolderPermission_Permission]
-- Drop constraint FK_ModulePermission_Permission from dbo.[ModulePermission]
ALTER TABLE dbo.[ModulePermission] DROP CONSTRAINT [FK_ModulePermission_Permission]
-- Drop constraint FK_EventLog_EventLogTypes from dbo.[EventLog]
ALTER TABLE dbo.[EventLog] DROP CONSTRAINT [FK_EventLog_EventLogTypes]
-- Drop constraints from dbo.[ProfilePropertyDefinition]
ALTER TABLE dbo.[ProfilePropertyDefinition] DROP CONSTRAINT [FK_ProfilePropertyDefinition_Portals]
-- Drop constraints from dbo.[ModuleSettings]
ALTER TABLE dbo.[ModuleSettings] DROP CONSTRAINT [FK_ModuleSettings_Modules]
-- Add rows to dbo.[EventLogTypes]
INSERT INTO dbo.[EventLogTypes] ([LogTypeKey], [LogTypeFriendlyName], [LogTypeDescription], [LogTypeOwner], [LogTypeCSSClass]) VALUES (N'ADMIN_ )
INSERT INTO dbo.[EventLogTypes] ([LogTypeKey], [LogTypeFriendlyName],
...
greetings and many thanks for your efforts in advance
guy