Queue Error - Failed but not blocking correlation

[dawoodward]

Hi,

When I look at Manage Queue on PWA, I notice that a good number of the
queue's show the error Failed but not blocking correlation. Can someone tell
me what does that mean and how this can be corrected? Here is the error
report for one of the queue's that have this error:

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="d5a2257d-f6f2-4da8-95d8-5fcce9a874ad" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. 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="5fe09f01-e1fc-4c88-bd64-6dd84af81bf7" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'ee48296a-17a9-4192-a5fd-3d74e31909ca'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ffa43df4-003a-4e25-8bee-2a93dfb24899" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'ee48296a-17a9-4192-a5fd-3d74e31909ca'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ba51864b-f53a-4e0c-bc1f-d9f2f2592d28" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'ee48296a-17a9-4192-a5fd-3d74e31909ca'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="eb35e757-8b80-4142-bb21-615b985ec42b" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'ee48296a-17a9-4192-a5fd-3d74e31909ca'" />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e2574394-4abc-4d4e-9c2b-806299ea63cc" QueueMessageBody="Project
UID='ee48296a-17a9-4192-a5fd-3d74e31909ca'. PublishType='ProjectPublish'"
Error="One or more custom field metadata mismatch were detected while
transfering project 'ee48296a-17a9-4192-a5fd-3d74e31909ca'" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="aaf26e9d-e5d2-4746-bb82-6e0690bb5d7f"
JobUID="b2ba1f71-5c23-4daf-b92a-7ef609afa4b9" ComputerName="FCSPROJECT1"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>


thanks so much,

 

[Ben Howard]

The best place to start for this type of question is Brian Smith's project
support blog at http://blogs.msdn.com/brismith/

 

[Sharry Heberer [MSFT]]

This looks like the same problem going on in another thread. You can read
my suggestions for that person. Just look for my most recent post from
today. The thread's title is "PS2007 reporting: Violation of PRIMARY KEY
constraint 'PK_MSP_EpmT'" (I think it got cut off). After reading my post,
please let me know if you have any problems with the steps.

 

[dawoodward]

I read the suggested blog and other thread. I'm sorry, maybe I'm just not
getting it. I'm still seeing this error and have no idea what to do next.
Any ideas?

 

[Sharry Heberer [MSFT]]

If you read the steps in my other thread, how far did you get in them?
Several of those steps should have yielded some results - what were those
results?

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm