Reporting (project publish) error

M

MAS

I am getting an error when 1 particular project is being published. The
detail from the queue is listed below. I have seen this error posted but
there haven't been any real soutions posted. We are running Project Server
2007 with SP1 and the infrastructure update applied. Any help will be greatly
appreciated.

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="6bc811c9-4386-46b8-8328-d7e4c7e5dd81" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="61b1a180-145c-4e1b-a3ac-0b9b5282aa05" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="9dba6b78-121e-48ea-b290-20455a2f1e6d" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="fb197961-f7bb-4f7b-b778-5080de5df81e" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ed4a2913-6652-4f40-8db7-64e10ab30e65" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="04afb544-0c60-4239-90be-b2dd3e63e974" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmTaskBaseline_ProjectUID_TaskUID". The conflict occurred in
database "NS_ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="713ad092-05de-476e-a8af-0f713fbe63d3"
JobUID="550dafce-5e13-4e20-a8ba-ba11def15edf" ComputerName="NHOA1MWEP007"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
 
M

MIRO

Hi MAS,

We are having the same error when we try to publish the project - have you
already resolved that issue?
Thanks in advance
MIRO
 

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

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

Top