A little background information first. I have restored all of our Sharepoint and Project databases into a VM in it's own domain. I have successfully upgrades the Sharepoint piece with 0 errors. I have now brought up another VM and have performed the installation of Sharepoint 2010 and Project 2010, and completed the config wizard with 0 errors.
During the upgrade process the Project Reporting database (SN_Project_Reporting) errors with the following error:
Exception: Invalid object name 'MSP_EpmProject_UserView'
This error halts the upgrade process and cannot be rolled back. We have examined the View in question and in SQL Management Studio everything looks normal. I performed a select * on the database and all columns come back and contain the correct data.
Below is the area in the log surrounding the Exception:
[OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [6/10/2010 11:17:37 AM]: Calling set SchemaVersion on Database SN_ProjectServer_Reporting, Status = Upgrading. [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [6/10/2010 11:17:37 AM]: Executing SQL DDL Script.
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Begin Commit()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: End Commit()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Begin Dispose()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: End Dispose()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: SQL Query Count=5
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: SPRequest Objects=1
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_209_0 (14.0.209.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Execution Time=81.8469945202533
[OWSTIMER] [SPUpgradeSession] [DEBUG] [6/10/2010 11:17:37 AM]: UPGRADE PROGRESS: current object = [ProjectDatabase Name=SN_ProjectServer_Reporting], current sequence = [ReportingDatabaseSequence], action 18 out of total 46
[OWSTIMER] [SPUpgradeSession] [DEBUG] [6/10/2010 11:17:37 AM]: UPGRADE PERCENTAGE: 14.75360723% done, Total Elapsed Time 00:09:55.9038240.
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Begin Initialize()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:37 AM]: End Initialize()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [INFO] [6/10/2010 11:17:37 AM]: Add the OOB Timesheet Project. Add related localized strings.
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Begin Upgrade()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Localizing upgrader for locale 1033
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:37 AM]: Running ReportingDatabaseUpgrader_14_0_210_0.
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: Action 14.0.210.0 of Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence failed.
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: Exception: Invalid object name 'MSP_EpmProject_UserView'.
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: at System.Data.SqlClient.SqlConnection.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 Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Project.Server.Data.TransactionalSqlSession.Microsoft.SharePoint.Utilities.ISqlSession.ExecuteNonQuery(SqlCommand ) at Microsoft.Office.Project.Server.Upgrade.ProjectDatabaseUpgrader.ExecuteUpgraderSqlScript(String sql) at Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseUpgrader_14_0_210_0.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: Begin Rollback()
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: Action 14.0.210.0 of Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence failed to rollback.
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: Exception: This SqlTransaction has completed; it is no longer usable.
[OWSTIMER] [ReportingDatabaseSequence] [ERROR] [6/10/2010 11:17:38 AM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName) at Microsoft.Office.Project.Server.Data.TransactionalSqlSession.Rollback() at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Rollback() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: Begin Dispose()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: End Dispose()
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: SQL Query Count=9
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: SPRequest Objects=1
[OWSTIMER] [ReportingDatabaseUpgrader_14_0_210_0 (14.0.210.0)] [DEBUG] [6/10/2010 11:17:38 AM]: Execution Time=675.315717500409
[OWSTIMER] [SPUpgradeSession] [ERROR] [6/10/2010 11:17:38 AM]: Upgrade [ProjectDatabase Name=SN_ProjectServer_Reporting] failed.
[OWSTIMER] [SPUpgradeSession] [ERROR] [6/10/2010 11:17:38 AM]: Inner Exception: This SqlTransaction has completed; it is no longer usable.
[OWSTIMER] [SPUpgradeSession] [ERROR] [6/10/2010 11:17:38 AM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName) at Microsoft.Office.Project.Server.Data.TransactionalSqlSession.Rollback() at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Rollback() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
[OWSTIMER] [SPUpgradeSession] [ERROR] [6/10/2010 11:17:38 AM]: Exception: Action 14.0.210.0 of Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence failed to rollback.
[OWSTIMER] [SPUpgradeSession] [ERROR] [6/10/2010 11:17:38 AM]: at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)