Error=Cannot transfer project, A FK constraint was thrown

[Jose X Perez]

Hi everyone,
I have an error in the server queue about a FK in the database of reporting.
Someone can help me please with this error?

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e38d55e6-402f-4aec-a84a-6e8e7ab90789" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="1bda49b9-7610-497e-bc09-f6d8ac6b63a4" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="aa8e74fa-077d-47b1-b330-850ac03e4603" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="5ad2332b-87c1-443c-b200-e41d6276fade" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="b328bae4-76fc-4a93-9207-f4f2ac500f61" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="ec02042e-a7b3-47ed-9d23-9b8f2f223825" QueueMessageBody="Project
UID='1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '1f5e77b4-0d9b-47a7-a735-465a4c0685eb'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="0e66bbd4-0c30-4740-955c-71fffcd965e9"
JobUID="a250584e-e5cc-4272-8892-d8015d8b40ea" ComputerName="CASPI"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

 

[Melissa]

Hello, I too have the same issue and cannot find the resolution. Were you able to figure this out?

 

[Gary Chefetz]

See the following for one therapeutic approach:

http://www.projectserverexperts.com...erebuildofprojectserverreportingdatabase.aspx

 

[dlpm]

Melissa wrote on 12/29/2009 19:04 :

Hello, I too have the same issue and cannot find the resolution. Were yo able
to figure this out?


frmsrcurl:

http://msgroups.net/microsoft.publi...t-transfer-project-A-FK-constraint-was-thrown
Melissa:
We had the same problem when publishing projects that had no resources assgine
to one or multiple tasks. When we either removed tasks with no resources o
assigned resources to them, the publsihing went fine.