A
Arman
I have read through most of the posts but could not find a fix for this
issue. I have a project wich is currently checked out and I am unable to
check it back in. I have tried restarting the queue service and that did not
help. When I check my queue, I have a job stuck in a "Project Save from
Project Professional" state with QueuePosition 1 and I can't cancel it. Here
are some 3 errors that I see related to this project (first one shows
%complete is 12) :
6/5/2007 12:21 PM 6/5/2007 12:21 PM user2 Project-1 Reporting (Project
Publish) Failed But Not Blocking Correlation 0% N/A Project Click to view the
error details f1a7af4a-fc88-4c88-93ee-8317d5a98af1
6/4/2007 6:20 PM 6/4/2007 6:21 PM user2 Project-1 Reporting (Project
Publish) Failed But Not Blocking Correlation 0% N/A Project Click to view the
error details f1a7af4a-fc88-4c88-93ee-8317d5a98af1
6/1/2007 2:03 PM 6/1/2007 2:03 PM user1 Project-1 Project Checkin Failed
But Not Blocking Correlation 12% N/A Project Click to view the error details
f1a7af4a-fc88-4c88-93ee-8317d5a98af1
Here are the errors in the same order as above:
1)
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="67f37d6f-d302-4d0d-8156-8bc7aacf2e08" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. 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="550dd0cd-a8e2-48b5-968e-8e785ba41808" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="9a993dff-ce6b-4dfb-aa07-49f989846868" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="de3f4f46-b367-4398-9da0-1a3c27837003" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="d1cdc630-ec06-46b1-9f13-ac95a1acc76e" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="54cd8a18-43fa-43bb-8a0a-aaca5e87b60f" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="8d5b5e41-a599-43ea-8601-c54e0100eabb"
JobUID="b0ce84d2-c85a-421d-b12f-5b07fea7fd51" ComputerName="SHAREPOINT"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
2)
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="79571059-d95a-40c0-ade1-db028e22b170" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f82f6955-ea68-4599-ac5e-2a12396ecf8c" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f8d3967f-0c8f-404c-9ebd-7f24334d4be8" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="03ad09e7-0d3e-41f7-b538-387ea0d0ec0a" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="573d8792-f604-4ab1-af9e-8cb47345c141" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="143ad4fe-1721-4833-bd10-aec38195361c" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="ca39db9a-eb9d-45d6-9555-a3fe394cd7c2"
JobUID="fde3f355-acfd-4990-a35f-d50301969e02" ComputerName="SHAREPOINT"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
3)
Error summary/areas:
CICONotCheckedOut
CICONotCheckedOut
Queue
GeneralQueueJobFailed
Error details:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CICONotCheckedOut">
<error id="10102" name="CICONotCheckedOut"
uid="b3c0480f-3f11-453e-8f77-81bcea3dbc57" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="2339c40f-66f3-4854-b704-f492c27e4937"
JobUID="7daaf4b9-25b6-4b19-86e5-5d9155672b5a" ComputerName="SHAREPOINT"
GroupType="ProjectCheckIn" MessageType="FailIfNotCheckedOutMessage"
MessageId="2" Stage="" />
</class>
</general>
</errinfo>
Any help would be greatly appreciated.
issue. I have a project wich is currently checked out and I am unable to
check it back in. I have tried restarting the queue service and that did not
help. When I check my queue, I have a job stuck in a "Project Save from
Project Professional" state with QueuePosition 1 and I can't cancel it. Here
are some 3 errors that I see related to this project (first one shows
%complete is 12) :
6/5/2007 12:21 PM 6/5/2007 12:21 PM user2 Project-1 Reporting (Project
Publish) Failed But Not Blocking Correlation 0% N/A Project Click to view the
error details f1a7af4a-fc88-4c88-93ee-8317d5a98af1
6/4/2007 6:20 PM 6/4/2007 6:21 PM user2 Project-1 Reporting (Project
Publish) Failed But Not Blocking Correlation 0% N/A Project Click to view the
error details f1a7af4a-fc88-4c88-93ee-8317d5a98af1
6/1/2007 2:03 PM 6/1/2007 2:03 PM user1 Project-1 Project Checkin Failed
But Not Blocking Correlation 12% N/A Project Click to view the error details
f1a7af4a-fc88-4c88-93ee-8317d5a98af1
Here are the errors in the same order as above:
1)
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="67f37d6f-d302-4d0d-8156-8bc7aacf2e08" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. 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="550dd0cd-a8e2-48b5-968e-8e785ba41808" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="9a993dff-ce6b-4dfb-aa07-49f989846868" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="de3f4f46-b367-4398-9da0-1a3c27837003" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="d1cdc630-ec06-46b1-9f13-ac95a1acc76e" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="54cd8a18-43fa-43bb-8a0a-aaca5e87b60f" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="8d5b5e41-a599-43ea-8601-c54e0100eabb"
JobUID="b0ce84d2-c85a-421d-b12f-5b07fea7fd51" ComputerName="SHAREPOINT"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
2)
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="79571059-d95a-40c0-ade1-db028e22b170" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f82f6955-ea68-4599-ac5e-2a12396ecf8c" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="f8d3967f-0c8f-404c-9ebd-7f24334d4be8" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="03ad09e7-0d3e-41f7-b538-387ea0d0ec0a" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="573d8792-f604-4ab1-af9e-8cb47345c141" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="143ad4fe-1721-4833-bd10-aec38195361c" QueueMessageBody="Project
UID='f1a7af4a-fc88-4c88-93ee-8317d5a98af1'. PublishType='ProjectPublish'"
Error="The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_MSP_EpmAssignment_ProjectUID_TaskUID". The conflict occurred in database
"PWA_Reporting_863FBE89_4C83_47B2_B981_CB7BAEAD06FE", table "dbo.MSP_EpmTask".
The statement has been terminated." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="ca39db9a-eb9d-45d6-9555-a3fe394cd7c2"
JobUID="fde3f355-acfd-4990-a35f-d50301969e02" ComputerName="SHAREPOINT"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>
3)
Error summary/areas:
CICONotCheckedOut
CICONotCheckedOut
Queue
GeneralQueueJobFailed
Error details:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CICONotCheckedOut">
<error id="10102" name="CICONotCheckedOut"
uid="b3c0480f-3f11-453e-8f77-81bcea3dbc57" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="2339c40f-66f3-4854-b704-f492c27e4937"
JobUID="7daaf4b9-25b6-4b19-86e5-5d9155672b5a" ComputerName="SHAREPOINT"
GroupType="ProjectCheckIn" MessageType="FailIfNotCheckedOutMessage"
MessageId="2" Stage="" />
</class>
</general>
</errinfo>
Any help would be greatly appreciated.