Deleting a Project?

[spatton]

We have a project that is permenantly checked out. No matter what we
try, we cannot get it to checkin. We cannot delete it, as when we try
the option is grayed out (since it appears checked out).

We have since saved this with a new name and moved on, but it
continues to send out reminders each day and the list grows
everyday.

I am looking for any suggestions on how to ether shut the reminders
down on this project, or some means by which we can delete the
project.

We are using MS Project 2007 SR1.

Thanks

Steve

 

[Dale Howard [MVP]]

spatton --

Ask a DBA to do the following steps:

1. Launch the SQL Server Management Studio application and connect to the
server containing the Project Server 2007 databases.
2. Expand the Databases folder and then expand the Draft database folder
for your production Project Server 2007 instance.
3. Expand the Tables folder for the Draft database.
4. Right-click on the dbo.MSP_PROJECTS table and select the Open Table
item.
5. In the database table on the right, select the name of the "stuck"
project in the PROJ_NAME column.
6. Tab to the right until you locate the PROJ_CHECKOUTBY field.
7. In the PROJ_CHECKOUTBY field, select the Unique ID currently in the
field and enter NULL in the field instead.
8. Press the Enter key or Tab key to complete the data change.

The above steps will manually check in the stuck checked out project, so now
you should be able to delete it. Hope this helps.

 

[Andrew Jacks]

G'Day Steve

I have seen this issue a number of times and has so far been due to one of
two issues:-

1) The Project cash on the client PC has go corrupted. To clear this open
Project Pro, select 'tools', 'Local project cache' and 'Clean up Cache'

2) The information in the Project Database has got corrupted. This one is a
little more technical:-

a) Open SQL Server Management Studio
b) Select a New Query
c) execute the following Query

SELECT PROJ_UID, PROJ_NAME, PROJ_CHECKOUTBY FROM
ProjectServer2007_PWA_Published.dbo.MSP_PROJECTS

the Column PROJ_CHECKOUTBY should contain NULL for all projects currently
checked in or a valid GUID. If any of the GUID's is all zeros then this
project will appear checked out. Any GUID in this format will need changing
to NULL

You might also need to check the Draft Database as well.

Hope this helps