Project Server, Project Server 2013

Project Server Queue Stuck “Waiting To Be Processed”

| | Leave a comment

After a fresh deployment of Project Server 2013 we hit a strange issue with jobs not being processed by the queue with the unhelpful status message “waiting to be processed”. After waiting for 15/20 minutes to see if the jobs cleared – which they didn’t – we then went through the following basic troubleshooting steps:

  • Restarted Project Queue Service and SharePoint Timer Service across the farm.
  • Checked the time was synchronised between the servers.
  • Cleared the queue and re-submitted some of the jobs.
  • Restarted the entire farm, including DB server.

Unfortunately, after doing all of the above we still found all jobs stuck in the queue with the same status message as before. Digging into the Event Viewer and ULS logs did not provide any obvious clues to the problem, so we went back through the configuration to see if we could spot the issue. After some investigation we checked the PWA instance by using the command:

Get-SPProjectWebInstance http://serverurl/pwa 

(replace serverurl with the relevant PWA URL that you are using, might be a DNS name or might be a server name). 

After doing this we received an output that showed ProvisioningResult as “successful”, but ProvisioningStatus as “failed”, which we knew wasn’t right. After checking in Central Admin (which showed everything as “Provisioned”), we ran the following command to re-provision and fix this error:

Upgrade-SPProjectWebInstance http://serverurl/pwa

This command took 5 minutes to run, and once finished we re-ran the original Get-SPProjectWebInstance command which now showed everything as Provisioned and Successful. Services were restarted and jobs started to be processed correctly by the queue.

Further investigation was completed to find out why this issue occurred and our conclusion is that the root cause was a minor transient problem during the initial PWA provisioning. We were unable to re-create the same error in a mirror environment, so we suspect it’s quite an unusual problem that, once diagnosed, is quite easy to resolve.

If you have any further SharePoint, Office 365 or Project Server problems, or this solution doesn’t work for you, please get in touch with us and we’ll get it sorted ASAP.

 

One thought on “Project Server Queue Stuck “Waiting To Be Processed”

  1. Just confirming that these 2 shell commands did the trick for my stuck queue after trying similar troubleshooting mentioned above. All projects remained intact and were accessible after the Upgrade-SPProjectWebInstance ran. The database logs were full when I tried to provision a new Project Site, so maybe that could explain why the queue got out of shape. Perhaps this update command rebuilt the queue allowing processing to continue? ;p

Comments are closed.