Projects not finishing the publish process.

J

JavaJoe

They end failing at the point they should publish to the Reporting DB.
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="ca320e19-ca27-4b8d-af02-ab09c9cd3f7c" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. 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="1bfde7bd-38bd-45c6-8aa2-f1289c68b318" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. PublishType='ProjectPublish'"
Error="Object reference not set to an instance of an object." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="bb049d98-6509-46cd-8ced-918894c5cb8a" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. PublishType='ProjectPublish'"
Error="Object reference not set to an instance of an object." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="9d5ef8a4-bef9-446c-b678-68b800fa9f88" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. PublishType='ProjectPublish'"
Error="Object reference not set to an instance of an object." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="00e079da-3693-4e67-9750-c64b4e51832a" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. PublishType='ProjectPublish'"
Error="Object reference not set to an instance of an object." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="63350893-67e1-45d6-9cf3-a83b18572260" QueueMessageBody="Project
UID='1b1b7bc8-a067-4aa7-8afa-f20a1c90cdb4'. PublishType='ProjectPublish'"
Error="Object reference not set to an instance of an object." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="86ec312e-b781-4066-a22c-49285838cd99"
JobUID="0a158f96-b370-4d4b-a635-105b3fd67b7a" ComputerName="N7MPMAP01"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
 
G

Gary L. Chefetz

JJ:

This may reflect some corruption in the reporting database. A quick therapy
is to force a rebuild of the reporting database. You can do this by using
the Administrative Backup feature to backup your enterprise custom fields
and then restore them. This will cause the system to rebuild the reporting
database.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
 
Top