Project 2007 Publishing Fails: Report Job, Failed But Not Blocking

[Chad M. Eguchi]

Project Server 2007 SP1 fails constantly with Failed But Not Blocking
correlation. New to PS2007, so any help will be greatly appreciated. Error
is 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="1c48b59d-897e-48d2-ba2e-c68faf4ed7df" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="Violation of PRIMARY KEY constraint 'PK_MSP_EpmTask'. Cannot insert
duplicate key in object 'dbo.MSP_EpmTask'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="94ff47c2-e94d-476a-b7ff-a5be29f13ac2" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'd2c1236b-a09d-421d-aed1-c1919a05b016'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="fcb58829-ae48-4768-8fd2-30617e8d282c" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'd2c1236b-a09d-421d-aed1-c1919a05b016'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="43deef32-bb4c-4dbe-94c7-a3b0cf2ea1c2" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'd2c1236b-a09d-421d-aed1-c1919a05b016'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="161a5c80-a32c-4c22-aef8-7a179a1886e2" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'd2c1236b-a09d-421d-aed1-c1919a05b016'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="542c4e9c-8b38-41c3-9c38-d92b6240dec4" QueueMessageBody="Project
UID='d2c1236b-a09d-421d-aed1-c1919a05b016'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'd2c1236b-a09d-421d-aed1-c1919a05b016'" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="113fec11-d9f2-4feb-8584-0411ba2bd85c"
JobUID="04426463-3cbd-42f4-844a-4e12a6bccff5" ComputerName="P2-HNL-MOSS001"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

 

[winzigm]

Hi this is mostlikely project plan corruption,

Download followin utility and check you project plan for errors.
http://projectserver.cz/cms/index.php?itemid=9&catid=4

Most likely there should be same project plan corruption which isn't
detected by this utility. In that case save your project plan as XML
using the projtool (from SDK), and try to find relationship between
your log and informations in XML file.