Cannot Check-in a Project - Project 2007

T

[TkT]

I have a Project in Check-out status...in the PWA>Server Settings>Database
Administration>Force Check-in Enterprise Objects I can see my project, I
select it and then press Check-in button... and nothing happens... the
project still blocked...

Can somebody help me...
 
R

Roberta

I have a Project in Check-out status...in the PWA>Server Settings>Database
Administration>Force Check-in Enterprise Objects I can see my project, I
select it and then press Check-in button... and nothing happens... the
project still blocked...

Can somebody help me...
Click to expand...

Did you cancel and reopen the box before trying to select your project?
 
R

Roberta

I have a Project in Check-out status...in the PWA>Server Settings>Database
Administration>Force Check-in Enterprise Objects I can see my project, I
select it and then press Check-in button... and nothing happens... the
project still blocked...

Can somebody help me...
Click to expand...

I apologize. I did not read your problem completely before responding.
If you selected the project and clicked check-in and it is not working
for you, I have no idea what the problem is.
 
B

Brian Smith \(MSFT\)

There are some issues around check-in which may be related to closing
project before the save has completed through to the server. Best practice
is to save and wait for the message in the status bar (at the bottom of the
Project pro screen) to save the save has completed. Then to close the
project and select check-in when prompted (not exit from Project
Professional) and finally Exit from Project Professional.

If you project doesn't get checked in then a current workaround is to open
read-only, and then close again and this will process the check-in.

Using force check-in will not make any difference as this only adds another
job to the queue which will not get processed while the project is in the
state.
 
L

Laith

That is right, I have faced the same problem and did eveything from the
application layer without seccess, so I've solved it from the Database (not a
very good option) but I had to do it, if you want to do that then open your
ProjectServer_Draft Database and look for a table called dbo.MSP_Projects
open it locate your project (by name) then find a cloumn called
Proj_CECKOUTBY, on the cell click CTRL + 0 that should give you Null and that
is it.

Good luck.

Laith
 
A

agreen

Laith said:
That is right, I have faced the same problem and did eveything from the
application layer without seccess, so I've solved it from the Database (not a
very good option) but I had to do it, if you want to do that then open your
ProjectServer_Draft Database and look for a table called dbo.MSP_Projects
open it locate your project (by name) then find a cloumn called
Proj_CECKOUTBY, on the cell click CTRL + 0 that should give you Null and that
is it.

Good luck.

Laith
Click to expand...


What I should make to remove a job from project queue jobs? I cannot cancel
a job of the publication of the project from PWA.
What can I do?
 
K

Kurt Verhaegen

Hi,

We had the same symptoms of not being able to cancel a checkin job.
Finally by restarting the Project Server Queue service it was cancelled.

Grtz, Kurt
 
A

alistairbridie

We too had this issue, but have generally had success in overcoming it
by selecting the "Cancel jobs getting enqueued" option under the
Advanced Options before cancelling the job that is stuck.
 
Top