deleting resources 2003

[DanceofFaith]

For over a year, I've tried to delete user accounts from MS Project
Server 2003 using both my own administrator account or a generic
account. It worked 2 or 3 times, deleting one name at a time, but has
failed ever since, giving the Request Status error 9600. I find other
cries for help all over the web, but no one has ever given an answer.
Is there NO ONE who understands why this happens?

Along with this, I have tried PSCleaner. I can pull the lists of
resources, but when I click the delete button, after a 60-90 second
pause, I get the following message:
Deleting the selected Resources...
Checking out Resource Global....

Failed to delete Resource (name removed). PDS Error Description : PDS
General Exception

Checking in Resource Global...

Summary Details :
*********************
Total number of selected Resources :1
Number of Resources sucessfully deleted :0
Number of Resources failed to delete :1
Done

I have tried doing it with both active and inactive users, both
through PWA and through PSCleaner. Neither works. Can anyone provide
some suggestions for resolving?
Thanks

 

[Gary Chefetz]

Danceof:

Smells like bad data in the resource table in the database. You can look for
this manually or use your T-SQL skills to locate the bad record(s) if this
is the case. Sorry that I don't have an easy fix for you.

 

[JennPenn07]

This article has some queries that checks for invalide resource data. It
purpose is to help you verify data before 2007 migration, but it should help
you get started. http://technet.microsoft.com/en-us/library/cc197599.aspx


Hope that helps.