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