Solved

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

Posted on 2011-02-25
18
809 Views
Last Modified: 2013-11-15
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
Comment
Question by:knfitz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
18 Comments
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 34981128
On the Project Server

Manage Enterprise objects and you can force check in



0
 

Author Comment

by:knfitz
ID: 35027918
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
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35029286
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:knfitz
ID: 35031475
I"m running project server 2007
project-screenshot.doc
0
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35036028
That is 2007 Ent.

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


Best of luck
0
 

Author Comment

by:knfitz
ID: 35036898
when i go there, its blank. I've tried all the drop downs.
0
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35036945
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
 

Author Comment

by:knfitz
ID: 35037019
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
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35037350
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
 

Author Comment

by:knfitz
ID: 35085154
I have full rights to everything.
0
 
LVL 12

Expert Comment

by:Dr. Thomas Henkelmann
ID: 35128874
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
 

Author Comment

by:knfitz
ID: 35132684
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
 
LVL 14

Expert Comment

by:GeorgeGergues
ID: 35210435
No solution posted
0
 

Accepted Solution

by:
knfitz earned 0 total points
ID: 35234266
I cleared the local project cache and it worked. Tools>Local Project Cache>Cleanup Cache>Remove from Cache
0
 

Author Closing Comment

by:knfitz
ID: 35304288
I figured it out.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Successful collaboration among team members is essential for the growth of your business. When employees work together on projects, share ideas and communicate effectively they get better results.
Starting up a Project
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question