Project Plan Publishing Error 26000

M

MK

We have a project plan that has been published many times yet now is unable
as it get a 26000 error; Failed But Not Blocking Correlation

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="01949c98-580e-469b-b871-b4b9ac077187" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="4f54a4b3-be57-43f1-a075-db84648fc3b7" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="6721de12-19bc-45a9-b006-76643ae2aba0" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="8e4dd7fa-7fa6-4a29-a8cb-943ab13f0065" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="30a1e442-29b2-4483-994b-1fdf56ac90f7" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="512f2413-4cb4-460a-b6ff-ea80f1cbb8cc" QueueMessageBody="Project
UID='367e1729-3e71-4af6-88be-ec7661d15d46'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "ProjectServer_Reporting_EPM", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="956614d8-3d3d-410b-b69a-82e175c5dd42"
JobUID="8441ed1d-8256-41b9-bcbf-dd2b8c196528" ComputerName="EPMPROD"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

We've tried republishing and it still does not work. Any suggestions as we
are at a loss.
 
A

Andre Venter

HI there,

Did you by any means add an Custom Field, this seem to me like a custom
field issue, and on publish when it writes to the reporting DB it fails. But
before you check that have you tried saving the file as an xml file delete
from the server and open and save the xml file in MSP again and try again.
--
Andre Venter
Technical Consultant
UMT South Africa
MCP
MCSE 2000
MCITP Project
MCTS Managing Projects
MCTS Confiuring Project Server
MCTS Charter Member
MCTS MOSS
MCITP Charter member
 

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

Publishing Project Plan Error 2
Project Failing in the Reporting(Project Publish) Step 0
Project Fails in the "Reporting(Project Publish) Step 2
Error when Publishing 7
Reporting (project publish) error 1
Reporting (Project Publish) -- Error 1
Reporting (Project Publish) 1
PWA - INSERT statement conflicted with the FOREIGN KEY constraint 1

Top