Error when Publishing

M

MAS

I am getting an error when 1 particular project is being published. The
publish works but this problem comes up when a sync is being done with the
reporting DB. The details from the queue are 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>
 
G

Gary L. Chefetz

MAS:

You can try forcing a reporting database rebuild by following these steps:

1) Backup the custom fields using the admin backup.

2) Restore them. This will kick off an RDB rebuild.

3) Remove ALL custom fields from the cube.

4) Rebuild the cube to ensure it builds correctly.

5) Re-add the custom fields to the cube.

6) Rebuild the cube to ensure it builds correctly.


--
----------
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
 
M

MAS

Gary,
As always thank you for your detailed help. This doesn't appear to have
fixed the problem. As a matter of fact, after I restored the custom
enterprise fields I got the below error. I beleive this error is being thrown
from the same problem project plan because when I select "realted tasks" in
Manage Queue it shows me the problem project. Any further help or advice is
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="bac3e63b-71b4-4832-b924-5aa320b4386b" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="cce842d7-af6b-44ff-8405-5677bb7917fc" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="880bc1ab-ceb7-4c7f-b4b6-347eceab0142" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="3f8ca487-ec93-4957-a7b0-06bea87fd8df" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="72280263-92c9-4854-8e95-7ce70a123311" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="5213c67f-1aec-41f9-8e0a-b2041b3bdc07" QueueMessageBody="Project
UID='9fbe84d0-6748-48c4-af1b-b0221751bb77'. PublishType='All'" 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="4e7eeda8-19a4-4858-9601-cc1f238084ac"
JobUID="bde9b403-7478-4086-99e7-ce81b5908a4a" ComputerName="NHOA1MWEP007"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
 
G

Gary L. Chefetz

If you know which plan is causing this, then you can save the plan as an XML
file, delete it from the server, and then import it using the import wizard.
This should work but you will disassociate time records in the timesheets
tables if you are use time reporting through timesheets. I can't predict how
important that is to you if you care at all.

--
----------
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
 
M

MAS

Wow Gary, you are amazing. Such a fast response but I have a couple of
questions. What is the reason for saving an xml file and not an MPP? Will
this disassociate the progress logged via task updates? We are not using
timesheets - we are only using task updates. Thank you again for your help.
 
G

Gary L. Chefetz

The reason for saving to XML is essentially to washout the binary record of
the plan.When you bring it back to the server this will be entirely rebuilt
from Scratch. It sounds like you may have binary corruption that is causing
the problem. Your progress record will remain in tact,

--
----------
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
 
M

MAS

Gary,
Sorry it took me so long to respond but the PM kept delaying me. This indeed
worked and everything is fine now for this project. Thank you very much for
your help.
 

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

Reporting (project publish) error 1
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
PWA - INSERT statement conflicted with the FOREIGN KEY constraint 1
Reporting (Project Publish) 1

Top