Solved

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

Posted on 2011-02-25
18
779 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
  • 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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:thausla
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now