Error in Queue, Reporting (Project Publish) ??

[Psk]

Hi,
I am using Project server 2007, if i try to publish the project through
Project proffesitional, the 'status' bar showing "publish job completed
successfully". Then i open "Report Database" in sql server for verifying
"Project Assignment Task" informations, but not updated the informations on
the table "MSP_EpmAssignment_UserView" for the particular project.

Finally i have checked the "Queue Status", found some issues for
publishing projects given below..
1. JOB TYPE: WSS Workspace Create
JOB STATUS: Failed But Not Blocking Correlation
2. JOB TYPE: Reporting (Project Publish)
JOB STATUS: Waiting to be Processed (Sleeping)

Note: Not updaing the Task informations on the RDB for the project.

If any one can help me, helpful.

Regards,
Psk

 

[Stephen Sanderlin]

Can you provide the complete error message detail from the Queue?

--
Stephen Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

EPM Solutions Architect / Principal Consultant - BT Professional
Services
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.

 

[Psk]

Hi,

Detailed error message given below..

1. Job Type: WSS Workspace Create
........................................................
Error summary/areas:
Given project already has a web associated with it
WSSProjectAlreadyHasSpWeb
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="Given project already has a web associated with it">
<error id="16404" name="WSSProjectAlreadyHasSpWeb"
uid="40dd2ffd-100b-4e9e-96d3-06561dcc2eda"
projectUID="76721cf1-52d1-40c5-b627-dd0331624c9b" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="93d2b997-477c-40f8-a593-5f2eb1646de6"
JobUID="89da21e0-3636-4ffe-b4da-04afdae9d216" ComputerName="PC104"
GroupType="CreateWssSite" MessageType="CreateWssSiteMessage" MessageId="1"
Stage="" />
</class>
</general>
</errinfo>

2. Job Type : Reporting (Project Publish)
........................................................
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="355d7636-3bc4-4867-a011-6a09887fe8ed" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. 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="0dcfd091-2969-45af-abd1-49ec576a9fb9" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '76721cf1-52d1-40c5-b627-dd0331624c9b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="6cab88b2-5907-4a12-9f4a-406bb76f5c74" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '76721cf1-52d1-40c5-b627-dd0331624c9b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="a6bcba81-a34d-461f-8298-f5e6afeb1d07" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '76721cf1-52d1-40c5-b627-dd0331624c9b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="dd8663d7-8ce6-43f0-8271-4637be4be28a" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '76721cf1-52d1-40c5-b627-dd0331624c9b'. A FK
constraint was thrown." />
<error id="24006" name="ReportingProjectChangeMessageFailed"
uid="1e4947c7-5686-4af4-a796-6314d9d8f479" QueueMessageBody="Project
UID='76721cf1-52d1-40c5-b627-dd0331624c9b'. PublishType='ProjectPublish'"
Error="Cannot transfer project : '76721cf1-52d1-40c5-b627-dd0331624c9b'. A FK
constraint was thrown." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="4d71419d-4c88-4406-8ebe-13d241dc41e6"
JobUID="d3962c56-e183-4615-b350-f553420a49d4" ComputerName="PC104"
GroupType="ReportingProjectPublish"
MessageType="ReportProjectPublishMessageEx" MessageId="1" Stage="" />
</class>
</general>
</errinfo>


Please Suggest Me....

Regards,
Psk

 

[Stephen Sanderlin]

Psk,

Regarding the first error:
Did you happen to create a custom workspace template?

Regarding the second:
Do you have one or more empty tasks in the project that you are trying
to update? In the project plan, this would appear as a line in the plan
with a number in the gray left column but no other data on the line.

Steve

--
Stephen Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

EPM Solutions Architect / Principal Consultant - BT Professional
Services
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.

 

[Psk]

Hi,
Thanks for your inputs.

1. I didn't create any custom workspace template.( usually i used to save &
publish the project)
2. Why i am looking on the Reporting(project publish) issue, if i added some
tasks for the project in the plan then save & publish, I will be not able to
getting the recently added task informations for the project on the Report
DB. Not only this project, if i add any of the project it's happening the
same.

Note: I am not able to publish the new project it's showing
Err:
WORKSPACE YOUR ARE TRYING TO PROVISION ALREADY EXISTS.
PLEASE PROVIDE DIFF NAME AND TRY AGAIN.

I have specified the exact Path, virtual server: http://PC104; Server URL:
PWA1; forward by <project name>

Please provide me a solutions..

Regards,
Psk

 

[Stephen Sanderlin]

How many projects are you seeing this issue with?

Please provide a detailed list of all the settings in Server Settings -
Project Workspace Provisioning Settings.

As for my initial reply:
1) If you do not already have an existing workspace with the same name,
I have seen this error occur when the Administrator has created a
custom workspace template based off of a workspace that was already
provisioned for a project.

2) There was a known issue in RTM (fixed in SP1) that would cause the
errors you described if there were blank tasks in the project plan.

--
Stephen Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

EPM Solutions Architect / Principal Consultant - BT Professional
Services
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.