[2007] Persistent projects

[Robert X]

Hello,
I have 2 Enterprise projects, the Queuing process of them is "Wainting To Be
Processed" for several weeks.
What I have tried :
- To Force the Checkin in PWA : no success
- To Clean up the Cache : no success, they are still there the next time
- To stop the Queuing process in Windows Task Manager : no success
- To Delete the projects in PWA : not possible because they are Checked out
- To Delete the projects in Project Pro, in the File/Open dialog : no
success, they are still there

Have I to desintegrate Project Server ?
Thanks for any idea

Rob

 

[Robert X]

Other trial:
I set the PROJ_CHECKOUTBY field in the MS_PROJECTS table (both _draft and
_published databases) to <NULL> instead of
{DAF0EA33-AF22-4521-918A-A8F764D3FD83}.
No success

 

[Marc Schoeni]

Robert,

Try the following... Go to PWA - Server Settings - Manage Queue - Advanced
Options - Cancel jobs getting enqueued = yes.

That solved some of the issue we experienced with the queue.

Let us know...

 

[Robert X]

Thanks for the hint, Marc

I tried, but that didn't work

 

[Robert X]

Finally, I succeeded !!!

I deleted manually *all* the files in all the folders like this:
C:\Documents and Settings\\Application Data\Microsoft\MS
Project\Cache\{complicate GUID}

I forced the Check In in PWA (Server Settings / Force Check-in Enterprise
Objects) : it worked !
I deleted the projects via Delete Enterprise Objects
At last; my Project Server database is clean...

Robert