project not publishing (2003)

[Scott Morrissey]

Every project in our 2003 server goes to the publishing queue correctly
except for one. I've checked the publishing options and all boxes are
checked. I've tried to re-publish the project plan, all information,
assignments, etc - but it never puts the HTML file in the views notifcation
queue for updating in project center.

After is saves, it shows a message in the lower left hand corner that it was
sent for processing, but as I watch the queue, it never gets in there and it
never refreshes the information in Web Access.

We are receiving an error upon opening the project such as "Check row 111
column RES_PEAK". We've had this before and I was able to correct it through
a procedure. On this one, however, I cannont find a negative or invalid
res_peak value so I can't get rid of the error message.

Any ideas of getting this fixed so it goes to the queue for processing.
Could the res_peak error be causing this???

 

[Dale Howard [MVP]]

Scott --

I would strongly suspect this project is corrupted, given the error message
and the fact that it simply will not publish. One way to resolve the
corruption is to do the following:

1. Save the project on your hard drive as an .xml file and close the file.
2. Delete the project from the Project Server database using the steps in
the following FAQ:

http://www.projectserverexperts.com/Shared Documents/DeleteProjectWithoutSubweb.htm

3. Open the .xml file and import it as a new .mpp file.
4. Save the .mpp file on your hard drive and then close it.
5. Reopen the .mpp file to confirm you no longer see the error message in
question.
6. Import the project back into the Project Server database using the
Import Projects wizard.
7. Reattach the project to its original WSS subweb using the steps detailed
in the FAQ above.

Hope this helps.