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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Failing in the Reporting(Project Publish) Step 0
Project Fails in the "Reporting(Project Publish) Step 2
Error=Cannot transfer project, A FK constraint was thrown 3
Project - Failed but not blocking correlation 3
need to track an error to a task Proejct Server 2007 SP1 1
Reporting (Project Publish) -- Error 1
Master Project Publishing Error + Alerts†1
Project Plan Publishing Error 26000 1

Top