Did anything else change on the server? 

---

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions

I have this same problem.  I didn't change anything else about the server.

During the upgrade, I did get an error in the 05.05.00 resources log and one in the 05.05.00 application log.

Resources Log

System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "DotNetNuke", table "dbo.dnn_BizModules_UPG_AlbumModule", column 'ModuleId'.
The statement has been terminated.
   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)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for dbo. and dnn_  *****/
/*****                                                  *****/
/************************************************************/

/* Delete Orphaned Module*/
/*************************/
DELETE
    FROM dbo.dnn_Modules
    WHERE ModuleID IN (SELECT ModuleID FROM dbo.dnn_vw_modules WHERE TabModuleID IS NULL)


System.Data.SqlClient.SqlException: Invalid object name 'portals'.
   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)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)




/*  script to fix issue with errorneous administratorroleid values*/

DECLARE @PortalID int
DECLARE @AdministratorRoleId int

--Iterate through each portal
DECLARE Portals_Cursor CURSOR FOR
SELECT PortalID,AdministratorRoleId
FROM         dbo.dnn_Portals

OPEN Portals_Cursor
--get first
FETCH NEXT FROM Portals_Cursor
into @PortalID,@AdministratorRoleId
WHILE @@FETCH_STATUS = 0
   BEGIN
   if @AdministratorRoleId=-1 or @AdministratorRoleId not in (select roleid from dbo.dnn_userroles as ur inner join dbo.dnn_userportals as up on ur.userid=up.userid where up.portalid=@portalid)
   
   update portals set AdministratorRoleId =
(select roleid from dbo.dnn_Roles as r where
r.PortalID =dbo.dnn_Portals.PortalID and RoleName = 'Administrators' and dbo.dnn_Portals.portalid=@portalid) where portalid=@portalid

       FETCH NEXT FROM Portals_Cursor
       into @PortalID, @AdministratorRoleId

   END
CLOSE Portals_Cursor

Application Log

Error: Object reference not set to an instance of an object.   at DotNetNuke.Services.Upgrade.Upgrade.UpgradeToVersion_550()
   at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication(String strProviderPath, Version version, Boolean writeFeedback)