Publishing projects in the reporting database

[Srini]

I have a problem with publishing projects into the reporting database. I am
getting the following error message. Please help me in analysing the
following error message.The reporting( project publish) tasks ending in
Failed but not blocking correlation.

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="5965c3c4-dcd0-4908-b03f-0e8fce96504d" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Violation of PRIMARY KEY constraint 'PK__#TBL_CFDeleteEnt__48840E2D'.
Cannot insert duplicate key in object 'dbo.#TBL_CFDeleteEntityUidArray'.
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="dd4edbaf-ac60-4d0c-a2d9-9b1ffa965f69" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="109c5663-ab5f-42a1-ac7f-f720f92be455" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="a1d2ed65-e056-4ed6-84cf-15db1f5499dc" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f73c2b42-c5bd-4999-bb41-6940519992a3" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="c83bff8b-411c-484e-a80f-d90732bc764c" QueueMessageBody="Project
UID='35c51a66-42a5-4705-96be-0cdc2905ff5b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '35c51a66-42a5-4705-96be-0cdc2905ff5b'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="c6739675-be32-4e63-92e0-abfa7a40ad17"
JobUID="2648674f-0c2d-403d-a41c-813f96d9b029" ComputerName="INVG2158"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

 

[Paul Conroy]

This can occur if you've used cut and paste to move entire rows/tasks. I'm
not sure if this was fixed in SP1.

 

[Srini]

I tried using a copy of this project plan in another instance and I did not
get any issues. If I delete this project plan in Production and re do the
whole process will solve this issue??

 

[WimVDB]

Hello Srini,

I have the same problem. Did you find a solution already?
I tried to eliminate the copy/past factor by just working with new files...
Using verbose mode for event logging didn't help. In fact, there is nothing
like 'ERROR' in the log file.

Wim

 

[Wijgert IJlst]

Hello,

We are experiencing the same kind of problems you state with several or our
projects aswell. We are still waiting for an implementation of SP1 by our IT
department, so can't confirm this would fix it.

Here is a part of the string we get on one of the failing project we intent
to publish to the reporting database:
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="b0f26439-385b-4529-ac3f-e3c5edc1afde" QueueMessageBody="Project
UID='bfd73c23-3d2b-4149-8b92-30d77f8f96bb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : 'bfd73c23-3d2b-4149-8b92-30d77f8f96bb'. A FK
constraint was thrown." />

Have you found out how to fix or resolve these kind of problems? This is a
big problem as our projects have got Actual Work hours within the
project-files, but in the published database these hours keep on growing and
in the reporting database this proces has come to a standstill... so making
reports with Data Analysis seems to be worthless now.

Hope you know how to help us.

Kind Regards,
Wijgert IJlst

 

[Wasonamit]

All I have the same issue.

any suggestions ???

Hello,

We are experiencing the same kind of problems you state with several or our
projects aswell. We are still waiting for an implementation of SP1 by our IT
department, so can't confirm this would fix it.

Here is a part of the string we get on one of the failing project we intent
to publish to the reporting database:
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="b0f26439-385b-4529-ac3f-e3c5edc1afde" QueueMessageBody="Project
UID='bfd73c23-3d2b-4149-8b92-30d77f8f96bb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : 'bfd73c23-3d2b-4149-8b92-30d77f8f96bb'. A FK
constraint was thrown." />

Have you found out how to fix or resolve these kind of problems? This is a
big problem as our projects have got Actual Work hours within the
project-files, but in the published database these hours keep on growing and
in the reporting database this proces has come to a standstill... so making
reports with Data Analysis seems to be worthless now.

Hope you know how to help us.

Kind Regards,
Wijgert IJlst