Project Publish Failed (Cannot insert duplicate key in object)

[Joao Cortez]

Hello,

We have one project that can not be published. In the event log of the
Project Server machine we find the following error in the event log:

Standard InformationSI Entry Point:
Project User: myorg\ferrante
Correlation Id: a0d5fcfa-a662-4ef9-930e-eabb5ae8f0f9
PWA Site URL: http://projsrv.qimonda.com/pwa
SSP Name: SharedServices1
PSError: ReportingProjectChangeMessageFailed (24006)
RDS: The request to synchronize change(s) to project Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'
failed.
Message: 'ReportingProjectChangeMessageFailed'
Error:Violation of PRIMARY KEY constraint 'PK__#TBL_CFDeleteEnt__5E02BA2F'.
Cannot insert duplicate key in object 'dbo.#TBL_CFDeleteEntityUidArray'.
The statement has been terminated.

In the Job Queue we can see the "Project Save" job, but not the associated
"Project Publish" or "Project Publish Notifications".

Any help?
Thanks a lot!

 

[Joao Cortez]

Hi,

Some additional information. We are running Project Server 2007 SP1. The
last publish email regarding the problematic project is copied here below.

Your ReportingProjectPublish job failed. Its current state is
FailedNotBlocking. It was 0% complete. It entered the queue at 08/18/2008
20:00:14.

To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.

The errors returned from the queue are as follows:
Error ID: 24006
Error ID: 26000

Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Reporting message processor failed">
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="1bc677d9-d389-408f-82b6-29c029436dfe" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="e25681de-12ab-43cb-87e0-f72fd200bbd0" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="639d1c09-9e9e-48e2-8b9a-f1915f973394" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="33ad9362-7fd1-4a76-b0c3-3528e1bb5831" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="970f7269-e893-4d50-8cf6-87bb20bdc226" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="446de271-9515-4294-b320-5d35d29c78c7" QueueMessageBody="Project
UID='3cc29703-306a-48b6-a846-af74606c0f7a'. PublishType='ProjectPublish'"
Error="Exception of type 'System.OutOfMemoryException' was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="7b83aa93-aa68-4f69-b406-9149c7da754c"
JobUID="88375194-b37d-4175-bfb5-553539e345c5" ComputerName="DRSSM750"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>

You can do the following:
1. Try troubleshooting using the error IDs, error XML.
2. Contact administrator with your jobID
(88375194-b37d-4175-bfb5-553539e345c5) and error XML.

To turn off these notifications, go to Project Web Access, click Personal
Settings on the left menu, and then click Manage My Alerts and Reminders.

From this page, you can clear the check box for those notifications you no
longer want to receive.

Microsoft Office Project Server,
http://projsrv.qimonda.com/pwa

Thanks!

 

[Joao Cortez]

Some more information.

The current situation is that for a particular project, it can be saved but
not published. The publish is not even started and there's no error
whatsoever presented to the user or in the log files or in the event log.

Any ideas? Please help!

 

[Mike Glen]

Hi Joao,

Try posting on the microsoft.public.project.server newsgroup. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP