Error Id 24006 Name Reportingprojectchangemessagefailed
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeOnline20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Project Server 2013 - ReportingProjectChangeMessageFailed (24006) The INSERT statement conflicted with the FOREIGN KEY constraint Project , Project Server > Project Server General Questions and Answers Question 0 Sign in to vote Hi, (We have Project Server 2013 On Premise with CU April 2014) When publishing one specific project, I get a lot of this error message: ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignmentBaselineByDay_ProjectUID_AssignmentUID". The conflict occurred in database "SharePoint_Project_003", table "dbo.MSP_EpmAssignmentBaseline". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='61e2d71b-dfe0-e311-9423-00505694197f' QueueMessageBody='Project UID='231d4fab-e08b-44fb-8d49-04f7deff207d'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignmentBaselineByDay_ProjectUID_AssignmentUID". The conflict occurred in database "SharePoint_Project_003", table "dbo.MSP_EpmAssignmentBaseline". The statement has been terminated.'. ReportingProjectChangeMessageFailed (24006) - The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignmentBaselineByDay_ProjectUID_AssignmentUID". The conflict occurred in database "SharePoint_Project_003", table "dbo.MSP_EpmAssignmentBaseline". The statement has been terminated.. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='61e2d71b-dfe0-e311-9423-00505694197f' QueueMessageBody='Project UID='231d4fab-e08b-44fb-8d49-04f7deff207d'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmAssignmentBaselineByDay_ProjectUID_AssignmentUID". The conflict occurred in database "SharePoint_Project_003", table "dbo.MSP_EpmAssignmentBaseline". The statement has been terminated.'. When I search for this error on the internet, I get a lot of solutions for Project server 2010. A solution that worked in Project server 2010 is this SQL script: -- Script to run on the draft DB USE ProjectServer_Draft -- specify the appropriate draft database delete from MSP_TASK_BASELINES where TASK_UID not in (select TASK_UID
often recieve this error message at our customers, 9 out of 10 times it is because the Project Server Reporting database is out of sync with publish database. The solution is to rebuild the database. See below. Error message from queue: • Reporting message processor failed: o ReportingProjectChangeMessageFailed (24006) - The INSERT statement https://social.technet.microsoft.com/Forums/projectserver/en-US/d49605f0-90bb-4694-94a0-6bbdb0f5aa2f/project-server-2013-reportingprojectchangemessagefailed-24006-the-insert-statement-conflicted?forum=projectserver2010general 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.. Detaljer: id='24006' name='ReportingProjectChangeMessageFailed' uid='05540895-3c37-41ca-a02b-8572d0d3ab68' QueueMessageBody='Project UID='f12dced7-1d84-47e0-86ee-4049dbd9b1cd'. PublishType='ProjectPublish'' Error='The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred http://technicaltrix.blogspot.com/2014/08/projectpublish-reportingprojectchangeme.html in database "ProjectServer_Reporting", table "dbo.MSP_EpmTask". The statement has been terminated.'. o 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.. Detaljer: id='24006' name='ReportingProjectChangeMessageFailed' uid='5313a512-da56-481d-a9b0-7bf8ebcbf564' QueueMessageBody='Project UID='f12dced7-1d84-47e0-86ee-4049dbd9b1cd'. PublishType='ProjectPublish'' Error='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.'. o 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.. Detaljer: id='24006' name='ReportingProjectChangeMessageFailed' uid='b12c9639-f86c-47e3-af28-9b016b5f576a' QueueMessageBody='Project UID='f12dced7-1d84-47e0-86ee-4049dbd9b1cd'. PublishType='ProjectPublish'' Error='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
on July 10, 2014 by Paul Marinescu — Leave a comment These days I've experienced an error with one of the Project Server 2013 environments. The users were getting the below error every https://pmarinescu.wordpress.com/2014/07/10/error-id-24006-reportingprojectchangemessagefailed/ time when a particular PDP was updated.
As always thank you for your detailed help. This doesn't appear to have fixed the problem. As a matter of fact, after I restored the custom enterprise fields I got the below error. I beleive this error is being thrown from the same problem project plan because when I select "realted tasks" in Manage Queue it shows me the problem project. Any further help or advice is greatly appreciated. Error summary/areas: Reporting message processor failed ReportingProjectChangeMessageFailed ReportingProjectChangeMessageFailed ReportingProjectChangeMessageFailed ReportingProjectChangeMessageFailed ReportingProjectChangeMessageFailed ReportingProjectChangeMessageFailed Queue GeneralQueueJobFailed Error details: