Publish Project Failed to complete

D

Dots

I am using Project Server 2007 and Project Pro 2007 SP1. When I try to save
a project plan I get the following error. I have already saved the project
locally, deleted original from the server, resaved to server and still get
the error. When I check my queue I see no blocking entry. HELP!!!!!!!!!


<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="">
<error id="23000" name="ProjectPublishFailure"
uid="c55f4cd0-a142-450f-934e-0a5ffcf38043"
projectuid="3d44978e-1073-454c-8957-fe95ee56b92f"
messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage" messageID="177" stage="" blocking="Block"/>
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="961f8e1b-6ca6-450c-a974-796c9f438f94"
JobUID="a3274a1f-1509-4c85-95ce-b1e02baf37c8" ComputerName="D700GV103"
GroupType="ProjectPublish" MessageType="UpdateSRAMessage" MessageId="177"
Stage=""/>
</class>
</general>
</errinfo>
 
G

Gary L. Chefetz [MVP]

Dots:

This is very likely due to task corruption in the project and the project is
failing to publish. Try this:

Open the project, insert the Publish field into a task view
Set publish to no for all tasks
Publish the project
If this goes through with no errors, then set the publish field back to yes
and publish again

If this doesn't work, you may need to do some database manipulation as
sometimes the write locks on the db do not release when this type of failure
occurs. I'll give you those instructions if the above doesn't work

More importantly, you need to update your system as this problem was fixed
in the April 3 hot fix release and is included in other updates since then.


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
D

Dots

Hi Gary,
I tried the pulish-Yes/No with no fix. I researched the newsgroups and
found others with same problem. Did a line by lilne delete then reinsert to
find the corrupted task item. That fixed it. But if you have a database
query that will allow me to do this easier, I would appreciate it if you
could pass that along to me. I am also planning on installing the
infrastructureupdateformicrosoftofficeproject2007-kb951547-fullfile-x86.exe
fix this weekend.

Thanks!
 
G

Gary L. Chefetz [MVP]

Dots:

This should work for you:

USE [ProjectServer_Published]
SELECT MSP_PROJECTS.PROJ_NAME,
MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME,
MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID,
MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID)))


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
 
D

Dots

Hi Gary,

Yes, I have that query which identifies what task items cause corruption on
the My Tasks view. But it doesn't fix the problem with saving or publishing
a plan. As a matter of fact, I had a PM do the No/Yes to the plan and he
received the failure to publish error message where he had not previously
received the error.

Gary L. Chefetz said:
Dots:

This should work for you:

USE [ProjectServer_Published]
SELECT MSP_PROJECTS.PROJ_NAME,
MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME,
MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID,
MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID)))


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Dots said:
Hi Gary,
I tried the pulish-Yes/No with no fix. I researched the newsgroups and
found others with same problem. Did a line by lilne delete then reinsert
to
find the corrupted task item. That fixed it. But if you have a database
query that will allow me to do this easier, I would appreciate it if you
could pass that along to me. I am also planning on installing the
infrastructureupdateformicrosoftofficeproject2007-kb951547-fullfile-x86.exe
fix this weekend.

Thanks!
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

I don't think there is a way to fix this using a query; rather, you can only
use a query to identify the problem children. Most important is to get your
system updated.

For any project that is completely stuck, you should make an administrative
backup of the project and then delete it from Published database only. Try
republishing after deleting it. I suggest that you try this in a dev
environment first, and make sure you have a database backup as well.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Dots said:
Hi Gary,

Yes, I have that query which identifies what task items cause corruption
on
the My Tasks view. But it doesn't fix the problem with saving or
publishing
a plan. As a matter of fact, I had a PM do the No/Yes to the plan and he
received the failure to publish error message where he had not previously
received the error.

Gary L. Chefetz said:
Dots:

This should work for you:

USE [ProjectServer_Published]
SELECT MSP_PROJECTS.PROJ_NAME,
MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME,
MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID,
MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID)))


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


Dots said:
Hi Gary,
I tried the pulish-Yes/No with no fix. I researched the newsgroups and
found others with same problem. Did a line by lilne delete then
reinsert
to
find the corrupted task item. That fixed it. But if you have a
database
query that will allow me to do this easier, I would appreciate it if
you
could pass that along to me. I am also planning on installing the
infrastructureupdateformicrosoftofficeproject2007-kb951547-fullfile-x86.exe
fix this weekend.

Thanks!

:

Dots:

This is very likely due to task corruption in the project and the
project
is
failing to publish. Try this:

Open the project, insert the Publish field into a task view
Set publish to no for all tasks
Publish the project
If this goes through with no errors, then set the publish field back
to
yes
and publish again

If this doesn't work, you may need to do some database manipulation as
sometimes the write locks on the db do not release when this type of
failure
occurs. I'll give you those instructions if the above doesn't work

More importantly, you need to update your system as this problem was
fixed
in the April 3 hot fix release and is included in other updates since
then.


--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


I am using Project Server 2007 and Project Pro 2007 SP1. When I try
to
save
a project plan I get the following error. I have already saved the
project
locally, deleted original from the server, resaved to server and
still
get
the error. When I check my queue I see no blocking entry.
HELP!!!!!!!!!


<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="">
<error id="23000" name="ProjectPublishFailure"
uid="c55f4cd0-a142-450f-934e-0a5ffcf38043"
projectuid="3d44978e-1073-454c-8957-fe95ee56b92f"
messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.UpdateSRAMessage"
messageID="177" stage="" blocking="Block"/>
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="961f8e1b-6ca6-450c-a974-796c9f438f94"
JobUID="a3274a1f-1509-4c85-95ce-b1e02baf37c8"
ComputerName="D700GV103"
GroupType="ProjectPublish" MessageType="UpdateSRAMessage"
MessageId="177"
Stage=""/>
</class>
</general>
</errinfo>
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stops publishing at 95%. Any idea on resolving error id="26000" 2
Publish Notification Failed 0
UpdateWSSCountersMessage- Project Publish failure(23000,26000)erro 0
after restoring from wss 3.0 error is generated in publishing proj 1
Project publish failure - workaround ? 0
how to resovle MS project 2007 - CICONotCheckedOut - Failed But No 1
Errors in queue jobs 0
PWA 2007 Publish project error 4

Top