I am trying to upgrade an installation that is 4.9.4 to 5.5.0.  There were two errors noted.

1.  Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log.resources for more information)

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



/* Fix OobjectQualifier for PK_EventLogTypes */
/**********************************************/

ALTER TABLE dbo.AIWeb_EventLog
    DROP CONSTRAINT FK_AIWeb_EventLog_AIWeb_EventLogTypes
ALTER TABLE dbo.AIWeb_EventLogConfig
    DROP CONSTRAINT FK_AIWeb_EventLogConfig_AIWeb_EventLogTypes
ALTER TABLE dbo.AIWeb_EventLogTypes
    DROP CONSTRAINT PK_EventLogTypes
ALTER TABLE dbo.AIWeb_EventLogTypes
    ADD CONSTRAINT PK_AIWeb_EventLogTypes PRIMARY KEY CLUSTERED ( LogTypeKey )
ALTER TABLE dbo.AIWeb_EventLogConfig
    ADD CONSTRAINT FK_AIWeb_EventLogConfig_AIWeb_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.AIWeb_EventLogTypes ( LogTypeKey ) ON UPDATE  NO ACTION ON DELETE  NO ACTION
ALTER TABLE dbo.AIWeb_EventLog
    ADD CONSTRAINT FK_AIWeb_EventLog_AIWeb_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.AIWeb_EventLogTypes ( LogTypeKey ) ON UPDATE  NO ACTION  ON DELETE  NO ACTION

2.  A more general error:  00:02:23.140 -   Executing Application Upgrades: 05.03.00 Error!

Where should I look for details of that error?

The site is running, but there are some errors that I'm trying to track down ...

---

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)

I check the database and the mentioned constraint wasn't there.  I manually executed the other 5 lines of SQL.

As for the others, I'm not sure, but it appears that upgrading several 3rd party modules has solved the visible problems.

Thanks.

---

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)