Cannot Check in a check out project

[May]

An error occured with a project where it appears as checked out when I try to
open it from project and display the message that it is checked out by User
XX (me) and that it can be open only as a read file.

However, I cannot either check it in as an admin as it does not appear in
the list of checked out projects from "manage enterprise features"

I also tried to delete it from "clean project server datanase" as it gives
an error message that it is checked out.

Any tip to delete or correct the situation?

May

 

[Gary L. Chefetz [MVP]]

May:

You can find your solution here:

http://www.projectserverexperts.com/Shared Documents/checkinprojectsandresources.htm

 

[Marc S.]

May,

In your case you probably have to check-in the project on database level. In
Enterprise Manager on your SQL Server navigate to the MSP_PROJECTS table,
find the data record for your project and change the value in MSP_CHECKEDOUT
from 1 to 0.

Hope this helps...

 

[May]

Option three in the link worked for me. Thanks a lot

 

[May]

Hi Marc:

It helped. Changing the status at the database level was the only way out of
this problem as I was unable to view the checked out project in the grid of
the enterprise features