The tip in this blog relates to when there is a job in the queue (PWA Settings >> Manage Queue Jobs) and it stays in the “processing” state indefinitely.
Normally, the resolution would be to:
- Cancel the job by selecting the job in the queue (PWA Settings >> Manage Queue Jobs) and clicking the Cancel Job button located above the queue grid
- Restart the Microsoft Project Server Queue Service on the server
If those steps do not work, then the following steps are necessary (and very rarely needed):
- Add the Correlation ID field to the Project Server queue grid. E.g. below
- Take note of the Correlation ID value for the queue item that is stuck
- Open a new query window against the Project Server database via SSMS
- Execute the following SQL code (but update the @CorrelationID variable as appropriate:
DECLARE @CorrelationID as UniqueIdentifier = ‘1ab98e2e-3bcf-e311-942b-00155d10040a’
DELETE A FROM draft.msp_queue_project_message AS a inner join draft.msp_queue_project_group AS b on a.GRP_UID = b.grp_uid WHERE b.CORRELATION_UID = @CorrelationID
DELETE from draft.msp_queue_project_group where correlation_UID = @CorrelationID
Find this helpful? Keep an eye for more future tips in our blog and LinkedIn.