none
OLAP Cube stuck processing in the Queue (Project Server 2013) RRS feed

  • Question

  • Morning All

    I have a bit of a problem.  I've jsut migrated from 2007 to 2013 and am ready to go live, except for one puzzling problem.

    A cube attempted to run overnight, but a log file issue with the Sharepoint_Config database.  I was unable to log into PWA even under the service account.  After setting the recovery level to simple and clearing the log file, rebooting the servers at least enabled me to log in to PWA.

    Since that point the cube job has been in the Queue processing away, preventing anything else from going through the queue.

    It's doing precisely nothing, as I've stopped the Analysis server, restarted it and generally tried to sabotage the cube job in an attempt to get it to stop.  Oh cancelling the job in the queue makes no difference, no matter what I try.

    I've even deleted the PWA site in Sharepoint and recreated it in an attempt to get it to stop, without luck as you can imagine.

    The question is, is there anything more drastic I can do to get rid of that job, so I can finally release my new system?

    Many thanks

    John

    Sunday, October 5, 2014 10:09 AM

Answers

  • Hi Maichael

    I raised a call with MS in the end, and further investigation found that the Site reported offline when looking at the PWA Properties in Powershell.

    Running the SiteUpdate command through powershell kicked it all back into action.

    Thought you might like to know.

    John

    Monday, October 6, 2014 1:39 PM

All replies

  • Hello John

    It sounds like you changed the service account to access PWA. Try this two things

    1) Make sure that they project service accounts have permissions to update the OLAP cube.  You may have to look into the OLAP security.

    2) Delete the OLAP cube from SSAS and then try rebuilding. It sounds like the OLAP permissions are out of sync with current.

    3) Delete the BI intelligence site, deprovision PWA and provision.  This will rebuild the BI center and cube


    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, October 5, 2014 12:51 PM
    Moderator
  • Hi Michael

    Many thanks for the reply, sadly that doesn't seem to be the problem.

    The problem is that the Cube Build job in the queue will not end under any circumstances.  I've rebooted servers, restarted services, stopped SQL Analysis services running, deleted the cube and any number of other things.  The Cube Build job will just not end or cancel.

    The Job State is processing, but new jobs being created by Project are all going in ahead of the build job.  Which is currents at position 248.

    I can connect to the Analysis Services from the sharepoint server, using the appropriate account and all is fine.

    I think the real problem is that the Cube Build Job is doing nothing at all, except holding up the queue.  What I'm trying to find is a way of clearing the Build Job out of the queue to let everything else process.

    What I have at the moment is a pretty perfect system, that wont process anything.  I'm in the position of starting the migration again, or fixing this one so it works.

    Yours Sincerly

    John

    Sunday, October 5, 2014 1:35 PM
  • Hi Maichael

    I raised a call with MS in the end, and further investigation found that the Site reported offline when looking at the PWA Properties in Powershell.

    Running the SiteUpdate command through powershell kicked it all back into action.

    Thought you might like to know.

    John

    Monday, October 6, 2014 1:39 PM
  • Hi John,

    We are experiencing what I think is the same issue here. Do you know what powershell commands I need to run?

    Thanks,

    Andrew.

    Monday, January 18, 2016 2:31 AM
  • I think the PowerShell SiteUpdate command stated above was incorrect and thus looked for PowerShell commands that may be similar to "site update", such as  a "site upgrade"

    I recently had the same issued and executed  following command and it clear all my queue and my run away OLAP processing event

    The powershell command was:  upgrade-spsite http://myprojectsite/PWA

    Not really sure why it worked though, other than it must be clearing out cache and events prior to performing the site upgrade.   It worked and so can move onto something else.


    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

    Monday, March 6, 2017 3:39 AM
    Moderator
  • Thanks for sharing John.

    There is always something above the sky

    Wednesday, July 10, 2019 4:37 PM