Corruption in the db?

  • Thread starter Debbie in San Diego
  • Start date
D

Debbie in San Diego

We have MS Project Server 2003 and MS Project Pro. We have serveral large
schedules (approx 6k lines). As the administrator, I performed a delete on
one of the schedules from Web Access by:
1. From Admin select Clean up the Project Server database
2. From the Clean up page, select the radio button for Projects and To-do
lists
3. Select the desired item
4. Hit the delete button.
The response was a dialog box that sais "an error occured" (I didn't note
the exact wording). But, when I looked at the list of projects, the desired
item was no longer listed.

Now, when we try to import a new schedule into the database using the import
function of MS Project Pro, an error message saying "you don't have
sufficient permissions to perform an import"....however...if the schedule
name is changed so it is different than the previously deleted item, the
person IS able to perform the import (without making any permission changes).
This is great except, we have naming conventions and we need for the filename
to be consistent.

The question is, was there some kind of corruption that took place during
the delete? Is there perhaps some residue somewhere in the db that is
preventing us from using that same file name? If so, how can the db be
cleaned up if the item isn't listed on the admin page?

thank you!
 
G

Gary L. Chefetz \(MVP\)

Debbie:

I seem to recall some similar problems with large plans. Is your system
current with service packs? Do you have a backup of the database?

--

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

-
 
D

Debbie in San Diego

Hi Gary,
Yes, we are current with the service packs. Yes we do have a backup of the
db.
 
D

Debbie in San Diego

Hi Gary,
It's not clear to me why you say to revert to the back up and then do the
cleaner tool. Could you expound on that please? I did download the cleaner
tool and did a trial on a small not-needed file. But, I'm not sure this tool
will actually help to clear out the residue. It builds off a list for the
user to select which item is to be deleted, and the file does not show in the
list, so I can't specify that it is to be deleted. But, I'm sure that there
is residue is some SQL row or column somewhere from having done the original
delete (the one that resulted in the error message during the delete but the
item no longer shows in the list but we can't import a new item now with the
same name). Any other thoughts?
thanks,
Debbie
 
G

Gary L. Chefetz \(MVP\)

Debbie:

That's why I said revert to a backup. There's no magic wand for cleaning up
database corruption. You revert to your last known good state and work
forward from there.

--

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

-
 
G

Gary L. Chefetz \(MVP\)

Debbie:

You can tell them to restore the database to an empty database and create a
DSN to open the plan. There's also a project recovery tool available for
download from Microsoft.

--

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