none
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?


    K.Gokulraj

    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


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

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

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


    K.Gokulraj

    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.  

    cheers


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Sunday, February 2, 2014 9:08 PM
    Moderator