Queue error

P

Paul

Hi,
I am experiencing this error in the queue for a number of projects, I have
edited error.
Project1 Test Reporting (Project Publish) Failed But Not Blocking
Correlation 0% N/A Project Click to view the error details

Error summary/areas:
Reporting message processor failed
ReportingProjectChangeMessageFailed GeneralQueueJobFailed Error details:
<class name="Reporting message processor failed">
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." />

I haev checked both the project server reporting and project server
published databases and notived that the MSP_EPM Task is only listed in the
Project Server reporting table.

Should this also be present in the published database? any help much
appreciated. Thanks Paul
 
Top