Thanks Paul & Stephen,
The full error message is as below. And yes, I have customised the Issues
and Risks (several months ago, no changes recently) to incorporate a larger
selection of categories.
--------------------------------------------------------------------------------------------
Your ReportingProjectPublish job failed. Its current state is
FailedNotBlocking. It was 0% complete. It entered the queue at 09/12/2008
10:51:01.
To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.
The errors returned from the queue are as follows:
Error ID: 24006
Error ID: 26000
Detailed error below - send it to the administrator for more detailed
troubleshooting.
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="31314453-63bc-4cf7-b738-4f0ea6bc379b" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="1be9916c-824e-49ba-b1b7-acebad75da35" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="6f738025-34ca-4b08-be20-87ea64c24659" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="61401c9d-aa31-423a-a82c-b63eb10f2227" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="407ae10d-c0b0-4a41-9934-b797614b99d9" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="52e28b5d-8e36-443e-88db-2d9c2f7cd609" QueueMessageBody="Project
UID='b8d4a83d-4370-466c-8804-a53273e4d4eb'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"ProjectServer_Reporting", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="17b7b1e5-d480-4162-acab-e00163b04ef3"
JobUID="4355dd66-40fd-4aff-8652-132677804d14" ComputerName="SGAPSYS022"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
--------------------------------------------------------------------------------------------
