Wednesday, October 17, 2012

Project Server 2010 - Orphan baseline tasks

PROBLEM:
In the past year or so, I have been seeing the following errors in the job queue


ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated..

GeneralQueueJobFailed (26000) - ReportingProjectPublish.ReportProjectPublishMessageEx



SOLUTION:

The temp workaround is to run the following SQL scripts:


select PROJ_NAME, MTB.PROJ_UID,TASK_UID,TB_BASE_NUM from MSP_TASK_BASELINES MTB
inner join MSP_PROJECTS MP on MTB.proj_uid=MP.proj_uid
where TASK_UID not in (select TASK_UID from MSP_TASKS)
order by PROJ_Name

delete from MSP_TASK_BASELINES where TASK_UID not in (select TASK_UID from MSP_TASKS) 


The permanent solution is to apply the hotfix from Microsoft... http://support.microsoft.com/kb/2598351


No comments:

Post a Comment