none
Failed and Blocking Correlation Job RRS feed

  • Question

  • I have generic question regarding Failed and blocking correlation job.

    When ever we have failed and blocking correlation job in Project server 2010 queue, we noticed that some of the other jobs in the queue are not getting processed. These jobs are not in "Blocked due to failed job" state in the queue either. They again start getting processed only after the failed and blocking job is resolved from the queue. 

    Tuesday, September 19, 2017 4:12 PM

All replies

  • Hi, 

    thank you for sharing this information.  Do you have a follow on question?


    Ben Howard [MVP] | web | blog | book

    Tuesday, September 19, 2017 4:30 PM
    Moderator
  • Ben, Sorry I missed that part.

    My question is why some of the jobs in queue are not getting processed when there is a "Failed and Blocking Correlation" error; and why they are getting processed after the error is resolved?

    Tuesday, September 19, 2017 6:40 PM
  • Hi, 

    Some queue jobs rely on others.  If a job fails with Failed and Blocking, then the blocking bit relates to the fact that it is blocking other jobs.  When that job succeeds, the other jobs can then be processed (and hopefully finish.  Worth reviewing Brian's blog on this - https://blogs.msdn.microsoft.com/brismith/2007/02/28/my-queue-is-stuck-how-to-manage-your-queue-service-in-project-server-2007/ 


    Ben Howard [MVP] | web | blog | book

    Tuesday, September 19, 2017 7:03 PM
    Moderator
  • Hi Ben,

    Thanks for the reply. I have already gone through Brian's blog before coming here. I understand that if a job on one particular project is in Failed and blocking error remaining jobs for the same project will be blocked as well as they are dependent on the job that is in error.

    What I am trying to understand is, why jobs related to Project B are also not being processed when the failed and blocking error is on Project A.

    I noticed that this behavior is occurring only when a project plan is in failed and blocking error; but not a timesheet. When a timesheet is in failed and blocking all project, resource and timesheet jobs are getting processed without any issue; but when a project plan is in failed and blocking error, queue jobs are piling up till the blocking job is cleared from the queue.

    Wednesday, September 20, 2017 10:51 AM
  • Hi Srivatsava,

    What I am trying to understand is, why jobs related to Project B are also not being processed when the failed and blocking error is on Project A.

    In truth I don't know why either.  Perhaps someone else will be able to jump in a provide an answer.


    Ben Howard [MVP] | web | blog | book

    Wednesday, September 20, 2017 11:37 AM
    Moderator
  • I don't believe that "Blocked due to failed job" is always accurate.  The project event handler is waiting on something and the status isn't correct.   

    Sometimes I can resolve by canceling a job like you mention earlier and other times restarting the project event service gets things moving as well.


    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

    Thursday, September 21, 2017 3:01 AM
    Moderator
  • Hi Mike,

    Thanks for the response. Yes, we too restart the event service, when we notice queue is not moving or piling up without any blocking job in the queue.

    My intention of the question is to understand what is causing this behavior. I looked for documentation related to this but couldn't find any.

    Thursday, September 21, 2017 7:35 PM
  • Hello Srivatsava

    Me too.  This is one of those project mysteries for me as well.  For some mysteries like this one, I just fix it and live with it.

    I think I may add this item to my list the "10 Top Mysteries of Project Server".     I have several others that I have a personal interest in as well.


    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

    Friday, September 22, 2017 3:17 AM
    Moderator