Deletion of project deletes other projects workspaces as well

R

rarmknecht

I created a test project the other day. An extremely basic test
project (one task with one enterprise resource).

It's workspace was appended with the number 137 (I assume that's it's
unique project #?).

Anyways, I then deleted that project by going to Admin -> Clean up
database -> delete project, and checked the remove associated
workspaces.

This did indeed delete the project. However, it also deleted the
workspace for project 120. It didn't get rid of the listing in the
Project Center but it did get rid of it's workspace.

Anyone have any clue why this would happen?

Note: A simple restore of the database restored the other project's
workspace without incident.

Thanks in advance,

-randy
 
R

rarmknecht

Yes. We restored the database and retrieved all lost data. Then just
to prove that was it, we deleted the same project and immeadiately
tried to access the site after the deletetion success message. It was
gone. Restored it once again and have at the moment restriced
deletetion of projects across the board.
 
G

Gary L. Chefetz \(MVP\)

Ok, the next step is to restore this onto a sandbox and keep trying
different deletion scenarios to roughly determine where to look. This could
be a data integrity problem, which is a whole lot more likely than a bug,
because we surely would have heard about this before if it were a bug.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
 
R

rarmknecht

Alright, I'll have to setup another sandbox environment then and test
it out.

How would you suggest verifying if it's a data integrity problem? Are
there any stored procs to watch? Specific tables?
I apprecaite your help!
 
G

Gary L. Chefetz \(MVP\)

Like I said, this is a matter of trial and error. Unless you can come up
with a repeatable sequence of events that always leads to this problem, it's
safe to assume it's a data integrity issue of some sort. How do you find a
repeatable sequence like that, trial, error, and hopefully some luck. Ask
whether it's worth it, if you can't make it happen on any other project in
your sandbox.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top