Delete Projects from SQL 2005 Server

[Ben]

Hi,

I know this is darring, but I heard that one of the last resort to get rid
of ghostly project that get stuck in the twilight zone is via using some
code or method to remove it in SQL 2005?

I have done Forced Check-in, Clearing Cache, delete via Manage Queue...
the job either just idle or said someone else has check-in...

any thoughts or comments?

Tks,

Ben

 

[Paul Conroy]

What's the message in the Queue/Logs ?

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[Ben]

Hi Paul,

In the Manage Queue: Status is either " Waiting to be Process" or "Failed
and Blocking Correlation" and just idle at 0%.. see below

6/13/2008 3:51 PM 6/13/2008 3:51 PM Administrator N/A Reporting (Resource
Sync) Failed And Blocking Correlation 0% 50 Project Click to view the error
details
6/13/2008 3:50 PM 6/13/2008 3:50 PM Administrator N/A Reporting (Resource
Sync) Failed And Blocking Correlation 0% 49 Project Click to view the error
details
6/12/2008 11:41 AM Administrator Project eMerge Test Project Delete
Waiting To Be Processed 0% 3 Project
6/12/2008 11:40 AM Administrator Project eMerge Test Project Delete
Waiting To Be Processed

I have tried cancel jobs and then do a force check in, but the check in will
just idle.

Ben

 

[Paul Conroy]

Try this,

Cancel all pending jobs in the queue

Delete all rows in the MSP_AdminStatus table (Reporting DB)

Backup/Restore all ent. resources

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com