Project Fails in the "Reporting(Project Publish) Step

[BruceFFIC]

We are running MS Project Server 2007 SP2 with AUG09 MS CU.

One of our projects is always failing on the "Reporting(Project
Publish) step with the following error. I am not an SQL expert, and
the person who does our SRS reports is not able to figure it out.

Does anyone have any idea what is happening?


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="b74b102f-37ca-4848-8c99-49b6a0c94f38" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f33f9dad-29f0-46a0-81a3-5ee3f0745e5f" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="d8bf9a30-25e2-432d-b87a-3454ac5911dd" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="fc353334-7ea7-446c-b906-438e9d3e0d64" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="bf52b3a8-ee78-4937-8223-c54c487f966c" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="8f54f92e-b83f-4e84-8955-9821244458d2" QueueMessageBody="Project
UID='dccf924a-e8f6-4894-8997-82ea41cc6e46'.
PublishType='ProjectPublish'" Error="The INSERT statement conflicted
with the FOREIGN KEY constraint
&quot;FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID&quot;. The conflict
occurred in database &quot;ProjectServer_C352_Reporting&quot;, table
&quot;dbo.MSP_EpmTask&quot;.
The statement has been
terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="5ecdb417-6c78-473a-b0ce-41bae141fd41"
JobUID="f35eb12b-0743-4970-8254-12d4fe8dd54a" ComputerName="C352"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>



Thankis,

 

[Gary L. Chefetz]

Bruce:

Try this therapy and see if it helps, most often it does the trick:


http://www.projectserverexperts.com...erebuildofprojectserverreportingdatabase.aspx

 

[BruceFFIC]

Bruce:

Try this therapy and see if it helps, most often it does the trick:

http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/for...

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business:http://www.msprojectexperts.com
FAQs:http://www.projectserverexperts.com
BLOG:http://www.projectserverhelp.com











- Show quoted text -

Gary,

As usual thank you.

I tried a few things hoping they would work

1. Exported to XML and then re-imported - didn't work
2. Restored a backup copy - believe it or not, but this worked.

Again Thanks,