Force check-in sticks on "waiting to be processed"

[SFDave]

I am using MS Project 2007 and Server 2007.

I have a project that was created, saved, and published.

I now cannot open a read/write version, just the read only version. I also
cannot delete the project.

When I try to use the force check-in tool from Project Web Access, it tells
me that the status is "waiting to be processed" eternally. Then, after a
couple of days, it tells me, "Cancelled" in the My Queued Jobs window.

Any suggestions on how I can delete or force check-in this project?

 

[dj_mac]

I have a similar situation, have you been able to resolve this issue?

 

[Jonathan Sofer]

All,

There are several reasons why the queue can get stuck. The easiest way to
know whether the queue is stuck is to look in the Manage Queue page in PWA.
If there are several jobs sitting in the "Waiting to be processes" state,
then the queue is most likely stuck.

The thing to do first is to find the one job that is in queue position 1
which is holding up all the other jobs from processing. Follow these steps
to help find the culprit job:

1) In the "Manage Queue" page in PWA>Server Settings expand the "Job
History" and set the "From Date" back to as early as you think the stuck
job might be found. A week back would probably be sufficient if this is a
recent occurrence.
2) In the "Job Completion Status" remove all jobs statuses and only add back
in the following: Getting Queued, Processing. Failed And Blocking
Correlation, Blocked Due To Failed Job
3) Hit the "Refresh Status" button in the Jobs Grid

Clearing a job is stuck in the "Getting Queued" state:
If a job state is 'Getting Queued' it can be force cancelled directly from
the manage queue page.
1) Under Advanced Options, check the box next to 'Cancel jobs getting
enqueued'
2) Uncheck the option 'Cancel subsequent jobs in the correlation' if you
want the subsequent (i.e. jobs in queue position 2 - n) jobs to still
process
3) In the Job Grid, select the checkbox next to the job stuck in the state
of 'Getting Queued'
4) Click 'Cancel Jobs'
5) Refresh the screen to validate that the job was cancelled.
6) If it does not cancel, attempt this process again

Clearing a job is stuck in the "Processing" state:
If a job state is stuck in 'Processing' it can only be cleared by restarting
the queue services

Restarting the queue services: (requires admin access to the project server
front end machine)
1. From your computer, select Start and Run
2. In dialog box, type MSTSC, enter
a. Type in the name of the server and hit enter
b. Enter User Name & Password
3. Once on the server go to Start and Run again and type SERVICES.MSC
4. In the services window find the job "Microsoft Office Project Server
Queue Service"
5. Right click on this job and click restart
6. If the job restarts successfully then go back to the "Manage Queue" page
in PWA and verify that the jobs begin processing again.