Reporting (Project Publish) -- Error

[anum_10]

We have project Server 2007, received the following error when one of our PMs
was trying to publish her project on the Server:

Project Name: COSA ITSM-BCAC-ADDM Implementation <--- (Is this name valid
with hyphens?)
Job State: Failed but not blocking Correlation
Job Type: Reporting (Project Publish)

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="b21114d5-30bb-464f-b250-0bd6fbb222b1" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f2cdfdbe-2dd7-4fdc-a44c-79ade9b76837" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f1a6bad9-a60f-4346-a575-fc3b8551472c" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="273a891c-75f1-416e-a0e7-451aad499a6d" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="00f42a60-70c7-409c-bda6-9ac23c6659cf" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="c42127e7-aef0-4ba2-828a-1d75b963efaf" QueueMessageBody="Project
UID='d5bf3993-8df7-4030-b9e1-c58bca2a3a37'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"Column_PS_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="6e584205-35d0-4c13-b927-cb1aa3a41a16"
JobUID="3b55c267-d474-4ab1-8dfa-420651a610d9" ComputerName="PROJECTS"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

 

[Gary Chefetz]

Anum:

Try forcing a rebuild of your reporting database by doing an administrative
backup of your custom fields, and then restore your custom fields. This will
force the rebuild. See if that solves the problem. If it comes back with
this specific project, it may indicate corruption in the project binaries,
which requires different therapy.