PWA - INSERT statement conflicted with the FOREIGN KEY constraint

[Ty]

We have 1 plan that fails to write to the reporting database (as far as I can
tell) when publishing.

Failure report from Queue as follows;
+++++++++++++++++++++++++++


Error summary/areas:
Reporting message processor failed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
ReportingProjectChangeMessageFailed
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="de8c2eaf-07a8-4d2b-b479-80f4a90ff452" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="94f24464-13bf-469e-a226-61b06c068416" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="9a490716-3b8e-4b7a-a87f-7cb38dcca040" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="df1f78e2-2432-4727-b5eb-0185a28a0154" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="abd457ac-4f64-43f2-876d-7de23566817d" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="bbcb6592-33e9-4feb-8184-a314cace82dc" QueueMessageBody="Project
UID='6a5d56b5-f260-4eb5-8619-53c539f38d1a'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "PWA_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="e39b31de-6baf-4936-8bdc-646d30c668ba"
JobUID="421fb4de-bfba-4b3b-8fa4-3a081e818d44" ComputerName="PROJECT1"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

++++++++++
End of report


Does anyone have any ideas what might be the problem or where I could look
next ?

Thanks Ty

 

[Gary L. Chefetz [MVP]]

Ty:

I suggest that you save the plan as an mpp file, delete it from the server
and reimport it to the server and publish.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com