Article ID: 971217 - View products that this article applies to.
After you install any cumulative update or service pack for Microsoft Office Project Server 2007 that was released in October 2008 or later, the SharePoint Products and Technologies Configuration Wizard fails. Additionally, the following error message logged in the Upgrade.log file:
Note By default, the Upgrade.log file is in the following folder: %ProgramFiles%\Common Files\Microsoft Shared\Web Server Extensions\Logs\
“Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseUpgrader_12_1_153_0.Upgrade()” The DELETE statement conflicted with the REFERENCE constraint "FK_MSP_TimesheetLine_TaskNameUID". The conflict occurred in database "TaskConsistency_<instance_name>_Reporting", table "dbo.MSP_TimesheetLine", column 'TaskNameUID'. The statement has been terminated. 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.Server.Data.SqlSession.ExecuteScript(TextReader textReader, Int32 commandTimeout) at Microsoft.SharePoint.Upgrade.SPDatabaseAction.ExecuteSql(String sql, Int32 commandTimeout) at Microsoft.SharePoint.Upgrade.SPDatabaseAction.ExecuteSql(String sql)at Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseUpgrader_12_1_153_0.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()
This issue occurs because of a very specific condition in the reporting database. In a very small number of cases, there may be duplicate records in the reporting database. These duplicate records can cause the SharePoint Products and Technologies Configuration Wizard to fail.
Before you install any Project Server 2007 cumulative update or service pack that is released in October 2008 or later, use the following script to check for the condition in the reporting database.
If this script provides a positive result, contact Microsoft Customer Support for help resolve this issue.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
If this is an issue for your deployment, it will only be an issue one time. Therefore, you do not have to run this script if either of the following conditions is true: