Reporting (Project Publish)

[derrick]

Hello,
We are using MS 2007 w/ SP2 installed in a MOSS environment:
We have DEV and PROD environments---configured the same---and we keep
getting the below error in our PROD environment. We just recently migrated
to the PROD environment from our old non-MOSS environment. Our Cube is
building successful, but without any data due to this reporting error.

Can anyone help?




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="52381ed4-8c87-4709-9f43-d5162ee95902" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. 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="96d2fcbb-df70-4974-8402-bd3adb52a685" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database
"SSP2_PWA_RPT", table "dbo.MSP_EpmResource", column 'ResourceUID'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="2488a9b5-800e-4444-845b-782c8d6d8419" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database
"SSP2_PWA_RPT", table "dbo.MSP_EpmResource", column 'ResourceUID'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e3321643-0c93-4a28-a4b5-6ac89f66e5cd" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database
"SSP2_PWA_RPT", table "dbo.MSP_EpmResource", column 'ResourceUID'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="4fdbfca0-dbf2-4e9a-9b55-8efbcdabf419" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database
"SSP2_PWA_RPT", table "dbo.MSP_EpmResource", column 'ResourceUID'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="fcdd945e-2494-4e1a-8b03-bac05fafc275" QueueMessageBody="Project
UID='523b0954-7173-4a61-84dc-03be7dbc486f'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ResourceOwnerUID". The conflict occurred in database
"SSP2_PWA_RPT", table "dbo.MSP_EpmResource", column 'ResourceUID'.
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="bbf51dd5-df0a-4c15-817e-656456b1339e"
JobUID="6e6577f6-e451-426d-abc1-b973f1912eeb" ComputerName="JEAMOSS1P1"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

 

[derrick]

we solved this issue...
check your projects plans for corruption. use this link
http://projectserver.cz/cms/index.php?itemid=9&catid=4
CheckServerConsistency

for us, this was caused because projects had empty resources with
assignments. after we cleaned up the projects, the reporting (project
publish) is working fine.