Queue Error in Project Server 2007 RRS feed

  • Question

  • Hi,

    When i submit the timesheet I see the status " Waiting to be processed(sleeping)" in the queue for long time and it gets failed. 

    What does it mean? i have restarted the queue service but still it doesn't work. 

    How to overcome this issue?


    Friday, January 31, 2014 2:32 PM

All replies

  • Hello,

    Does the job ever process? Sleeping jobs are quite often caused by the Application servers time being out of sync with the time on the SQL Server.


    Paul Mather | Twitter | | CPS

    Friday, January 31, 2014 3:18 PM
  • Hi,

    It does not process, after sometime i can see with the status "Failed and blocking correlation".


    Friday, January 31, 2014 5:19 PM
  • One of the tasks is causing the issue.   I usually see this when user submits more time than remaining work.  To find the task, I would recall the timesheet and clear out half the times with zero and resubmit.   Continuing doing until you find the one task causing issue.  


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Sunday, February 2, 2014 9:08 PM