Checking Out a File

[JLR]

I'm experiencing problems when publishing files to Project Server. When I
save a file to the Project Server and close MS Project Professional
completed, then re-connect to the Project Server to re-checkout the original
published file it is showing that the file is already checkout by me. Is
there something that I am doing wrong. When I go to re-checkout the files it
is showing that profile already has the file checked out. PLEASE HELP !!!

 

[Dale Howard [MVP]]

JLR --

When you want to close a saved project, we recommend you click File - Close,
rather than clicking the Close button (X button) in the upper right corner
of the Microsoft Project application window. This will minimize the risk of
the project getting "stuck" in a checked out state. To check in your own
project that is "stuck" in checked out state, do the following:

1. Log into PWA
2. Navigate to the Project Center page
3. Click the "Check in my projects" link in the sidepane on the left
4. Select your "stuck" project and click the Check-In button

Hope this helps.

 

[IISJUNKIE]

If what Dale listed still does not fix your problem then Flip the bit in SQL
manually or use a script on the msps main DB:
1) look at your URL of your project plan in PWA and note the number.
2) in SQL Query ANA connect to the main MSPS DB
3) Copy the following:
go
UPDATE MSP_PROJECTS
SET PROJ_CHECKEDOUT = 0
WHERE PROJ_ID = '403';
go
4) Paste it in SQL QA but put your project # where 403 is.
5) if you get a successful message then your done, if not - seek advanced
help to make sure the syntax is correct according to your MSPS tables.

Good Luck

 

[Gérard Ducouret]

Hello IISJUNKIE,
I'm afraid that this SQL query will not work, because the WPROJ_ID that you
can see in the URL is not in the MSP_PROJECTS table, it is in the
MSP_VIEW_PROJ_PROJECTS_STD table. So you need to join the 2 tables:

UPDATE MSP_PROJECTS

SET PROJ_CHECKEDOUT = 0

FROM MSP_PROJECTS P

INNER JOIN V

ON P.PROJ_ID = V.ProjectUniqueID

WHERE V.WPROJ_ID = 109

Hope this helps,

Gérard Ducouret