ProjectServer Cleanup - noone can help me?

[EmilH]

Hi.

It takes me too long to delete a resource from the project server. I
downloaded a cleanup tool for ProjectServer where I can even delete more
than one objects at a time, but it still takes too much time and it may
crash in the end. If it doesn't crash, it deletes for example 2 or 3 objects
from 10 selected. Can anybody help me?

Thanks.
Emil.

 

[Gary L. Chefetz [MVP]]

Emil:

Are you working on the Server console when you run the tool? It works best
from there.

--

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

 

[EmilH]

At last! At elast one person replied my post
What d'you mean under Server console? I didn't noticed one if you mean cmd.

Emil.

 

[Gary L. Chefetz [MVP]]

No, I mean working on the server itself, not on a workstation.

--

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

 

[EmilH]

Yes, Gary, I'm working on the server itself, but this inresponsiveness
remains the same (up to 15 minutes).

Anywway Thanks. At least in the end it ends the task although shuts down
incorrectly.
Emil.

 

[Gary L. Chefetz [MVP]]

The hanging might indicate index corruption. Maybe some key violations from
duplicate assignments. It's very difficult to say. You might try turning on
SQL Profiler and then running the tool to see where it's actually failing.
That would give us a starting point.

--

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