• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 833
  • Last Modified:

how to force a project to check in, in the project center on project server 2007

I have a project in the project center on my project 2007 server. someone has it checked out and no one knows who. Is there a way to force the project to be checked in?
0
knfitz
Asked:
knfitz
  • 8
  • 6
1 Solution
 
GeorgeGerguesCommented:
On the Project Server

Manage Enterprise objects and you can force check in



0
 
knfitzAuthor Commented:
where do I find that? I'm looking in server settings> force checkin enterprise objects>  but there's nothing in that list? am I in the right place?
0
 
GeorgeGerguesCommented:
that should be under a your system settings that will vary depending on your version and customization of you sharepoint integration.

Can you post a screen shot of your Server Settings page.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
knfitzAuthor Commented:
I"m running project server 2007
project-screenshot.doc
0
 
GeorgeGerguesCommented:
That is 2007 Ent.

you will find it under
Database Administration :
-Force Check in  Enterprise objects under


Best of luck
0
 
knfitzAuthor Commented:
when i go there, its blank. I've tried all the drop downs.
0
 
GeorgeGerguesCommented:
It could be Blank because you do not have administration rights on the Project Server .

are you certain you have the project file Check in to this Server ?
0
 
knfitzAuthor Commented:
I'm the sharepoint farm administrator and I'm the login that installed everything. when someone tries to edit the file it says that it needs to be checked in to be able to edit. I'm trying to force it to check in because no one knows who had it checked out. is there another way to check it in to the server?
0
 
GeorgeGerguesCommented:
You have be an administrator on the Project Server not only Farm admin.

You can see your setting under User Management ( that is totally separate from SharePoint users )

Security > manage user and Manage Groups ....

Make sure you also have rights to that project object.

0
 
knfitzAuthor Commented:
I have full rights to everything.
0
 
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Projectserver 2007 every now and then "forgets" about checked-out projects. In this case you can force a checkin in the DRAFT database:

- Open the MSP_PROJECTS table
- look for the PROJ_CHECKOUTBY column
- double check you have the correct row by looking at the PROJ_NAME
- set the PROJ_CHECKOUTBY column to NULL

Now you can access the project again.

Regards

Thomas
0
 
knfitzAuthor Commented:
Wow, I can't believe this. The column shows the value to already be null? In fact all of the projects show the PROJ_CHECOUTBY as null. I only have about a dozen projects in there. This is getting really weird. What else could be causing this thing to appear as being checked out?
0
 
GeorgeGerguesCommented:
No solution posted
0
 
knfitzAuthor Commented:
I cleared the local project cache and it worked. Tools>Local Project Cache>Cleanup Cache>Remove from Cache
0
 
knfitzAuthor Commented:
I figured it out.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now