none
Project 2010 cube build stuck at 50% RRS feed

  • Question

  • Hello,

    We are seeing issues with our Project Server 2010 deployment:

     - olap build stuck at 50% for 6 days
     - unable to cancel the job
     - restarted olap SQL service
     - restarted PWA app pool
     - still showing as processing


    Is there any way to cancel the olap build other than through viewing the queue? Or, any suggestions to get the queue moving please.

     

    Monday, November 15, 2010 5:52 PM

Answers

  • Hello Stephen

    The 50% doesn't really mean 50%, it means that it is processing the OLAP cube.  The next percent will be 100% if it completes.

    The reason why you can't delete is because the request went to SQL Agent and waiting to hear back.  You could kill the process on SQL server that is running the OLAP processor and then try canceling the project server queue job.

    Cheers


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
    Monday, November 15, 2010 7:22 PM
    Moderator

All replies