Job Queue hangs – Project Server 2007
If you are working on a project using Office Project 2007 to list out all the tasks and when you publish the project after completion, there might be a indefinite pause for publishing the project. The Resources allocated might not be notified of the changes. If you notice the office project status bar.
What happens is, the job stays in the queue on the project server. The purpose of the Office Project Server 2007 Queuing System is to handle these abrupt changes in demand gracefully and reliably. The Queuing System takes all the users’ input, records entries for the requests in Microsoft SQL Server, and then processes the data asynchronously on a first-come, first-served basis. Having a queue ensures that the Office Project Server 2007 EPM solution does not stop working when a spike in demand occurs.
Solution: Check the jobs in the queue by logging into Project Web access as an administrator.
PWA->Server Settings->Manage Queue
If there are lot of jobs "Waiting To Be Processed", Canceling and Retrying may make no difference. Open the Services MMC and find "Microsoft Office Project Server Queue Service". Restart the service and Refresh status of the jobs in PWA. The jobs will be processed now. If your database is on a different server from the application server, make sure that both the servers have the same time.