G
gFavinger
We're experiencing the situation where all of our "publish" jobs for project
plans fail with errors similar to the below. The projects seem to be updated
fine. The main area where we see problems is in the Resource Center ->
Resource Availability graphs. In these charts, though the hours are updated.
Projects never seem to complete and disappear from a resources usage. I'm
not sure if these two issues are related or not.
Any help would be appreciated.
Here are the error details...
Your ReportingProjectPublish job failed. Its current state is
FailedNotBlocking. It was 0% complete. It entered the queue at 08/27/2007
12:30:52.
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="aa5670bb-f1d6-4c35-bb2e-91fd78d14578" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Violation of PRIMARY KEY constraint 'PK_MSP_EpmTask'. Cannot insert
duplicate key in object 'dbo.MSP_EpmTask'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="04b75917-1f5b-46aa-b89a-8634d82c1f74" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="081561ca-4d9c-46e9-bd6c-7fb014e7054c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="df15164b-0dbc-4531-8ee4-e5790c69962c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ad44aef5-9701-4933-ab1d-6eac4d5895f3" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="5a4f67d5-9415-48bf-9f0b-382d2a8b64a6" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="de124a74-b2a9-49f6-9984-5a73f457e789" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="3309c624-11d6-4737-a4ac-97b09d8cab8a" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e4bb02d3-5d59-43b6-a5b2-77fedd99bcef" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="37fc1fe7-d937-4f95-8ef5-5cda21c6954c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="736db3bc-8329-4e8f-becc-bd58b0513d13" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="4f32ccc7-b852-40b9-a2c6-a9a20f3da247"
JobUID="00aa4d9e-ef1a-4566-9f83-80510a6f4da3" ComputerName="FCSPROJECT1"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
plans fail with errors similar to the below. The projects seem to be updated
fine. The main area where we see problems is in the Resource Center ->
Resource Availability graphs. In these charts, though the hours are updated.
Projects never seem to complete and disappear from a resources usage. I'm
not sure if these two issues are related or not.
Any help would be appreciated.
Here are the error details...
Your ReportingProjectPublish job failed. Its current state is
FailedNotBlocking. It was 0% complete. It entered the queue at 08/27/2007
12:30:52.
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="aa5670bb-f1d6-4c35-bb2e-91fd78d14578" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Violation of PRIMARY KEY constraint 'PK_MSP_EpmTask'. Cannot insert
duplicate key in object 'dbo.MSP_EpmTask'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="04b75917-1f5b-46aa-b89a-8634d82c1f74" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="081561ca-4d9c-46e9-bd6c-7fb014e7054c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="df15164b-0dbc-4531-8ee4-e5790c69962c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ad44aef5-9701-4933-ab1d-6eac4d5895f3" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="5a4f67d5-9415-48bf-9f0b-382d2a8b64a6" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="de124a74-b2a9-49f6-9984-5a73f457e789" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="3309c624-11d6-4737-a4ac-97b09d8cab8a" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e4bb02d3-5d59-43b6-a5b2-77fedd99bcef" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="37fc1fe7-d937-4f95-8ef5-5cda21c6954c" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="736db3bc-8329-4e8f-becc-bd58b0513d13" QueueMessageBody="Project
UID='1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f7309c3-4f09-4c3a-b96d-3eac5c07f31b'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="4f32ccc7-b852-40b9-a2c6-a9a20f3da247"
JobUID="00aa4d9e-ef1a-4566-9f83-80510a6f4da3" ComputerName="FCSPROJECT1"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>