none
Project 2010 cube build stuck at 50% RRS feed

  • Question

  • Hello everybody,

     

    We've just installed project 2010 and project server, we migrated our system from 2007. I have the following problem. The cube runs, but it only runs on the predefined moment. If you pres build now, it goes to 50% and gets stuck there. Can anybody tell me in which direction I have to look?

     

    Thnx,

    Bert


    Kind regards, Bert
    Wednesday, July 13, 2011 3:50 PM

Answers

  • Hello all,

    unfortunately the server didn't got stuck. It just took a damn long time. It took a little under six hours to build the cube which took only 25 minutes in 2007... And one of the reasons we wanted to upgrade was to shorten this time... So my question is now mute.

    I'm experimenting with custom fields to decrease the time needed to build the cube.

     

    thnx all


    Kind regards, Bert
    • Marked as answer by Bert Wolff Friday, July 15, 2011 2:12 PM
    Friday, July 15, 2011 2:12 PM

All replies

  • Hi Bert,

    Firstly do any jobs process though the queue successfully? How long has this been at 50% for?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Wednesday, July 13, 2011 4:46 PM
    Moderator
  • Hello Paul,

     

    Yes all jobs process through the queue perfectly and fast. It was stuck this time for over 5 hours before i cancelled it. Last time over 3 hours. The strange thing is that the predefined cube build runs perfectly and within 4 minutes.

     

    Thanks,

    Bert


    Kind regards, Bert
    Wednesday, July 13, 2011 4:53 PM
  • did your 2007 cube contain custom fields? If so, what happens if you remove all custom fields and then do your build now? Then add them back one at a time.

     

    just a thought


    --- Brian Kennemer Web: http://www.deltabahn.com Blog: http://www.projectified.com
    Wednesday, July 13, 2011 6:28 PM
    Moderator
  • Hello Bert,

    Restart the Analysis services & again try to build the cube. if again stucks at 50%, check the ULS logs & lets us know.
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    • Marked as answer by Bert Wolff Friday, July 15, 2011 2:09 PM
    • Unmarked as answer by Bert Wolff Friday, July 15, 2011 2:09 PM
    Thursday, July 14, 2011 7:13 AM
  • Hello all,

    unfortunately the server didn't got stuck. It just took a damn long time. It took a little under six hours to build the cube which took only 25 minutes in 2007... And one of the reasons we wanted to upgrade was to shorten this time... So my question is now mute.

    I'm experimenting with custom fields to decrease the time needed to build the cube.

     

    thnx all


    Kind regards, Bert
    • Marked as answer by Bert Wolff Friday, July 15, 2011 2:12 PM
    Friday, July 15, 2011 2:12 PM