locked
OLAP Build Stuck RRS feed

  • Question

  • Experts, we have project server 2007 sp2. the olap cube builds fine except when I add any project level fields to the Assignment cube under Server Settings-->Configuration. The cube starts and gets to the "Analysis Services session started" step and it just sits there. I have to go to the Queue and cancel it. if i remove the Project Level codes back the cube builds fine again. what's going on?
    Tuesday, June 22, 2010 4:37 PM

Answers

  • I would isolate the issue as below.

         a. Specify working analysis server name in the Test server PWA

         b. In the other environment PWA specify the Test server AS server

    So that you can narrow down, whether it is PSVR or AS issue.

             If it is PSVR issue, you can try after RDB refresh.

             If it is AS issue, compare the working and non-working.


    Thanks Sriram E - MSFT Enterprise Project Management
    Thursday, June 24, 2010 1:04 AM

All replies

  • Hello hadie,

    Be sure that the Project Level EPM code is a not a multi-select table code.

    Also, if that is not the issue, how is the "Project Level" EPM defined.

    Michael Wharton, MBA, PMP, MCT 


    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Tuesday, June 22, 2010 5:02 PM
  • Hi Michael,

    The Project text fields are using lookup tables but no "multi-select" is allowed. One of the Project fields is a Flag. Even when I add that the Cube gets stuck

    Thanks

    Hadi

    Tuesday, June 22, 2010 5:27 PM
  • Hello Hadi,

    How about installing SQL server Sp3 with CU 3 on your SQL server 2005?

    -Can you check the size of the tempdb in your sql server?

    -Please go through the following article.

    http://blogs.msdn.com/b/brismith/archive/2008/03/24/slow-olap-cube-builds-and-large-tempdb-revisited.aspx

     


    Thanks Sriram E - MSFT Enterprise Project Management
    Wednesday, June 23, 2010 8:57 AM
  • Hi Sriram, I'm sorry I faild to note that we are using SQL 2008. This is our Test enviornment. We have two other enviornments that function with no issues.

    Wednesday, June 23, 2010 11:36 PM
  • I would isolate the issue as below.

         a. Specify working analysis server name in the Test server PWA

         b. In the other environment PWA specify the Test server AS server

    So that you can narrow down, whether it is PSVR or AS issue.

             If it is PSVR issue, you can try after RDB refresh.

             If it is AS issue, compare the working and non-working.


    Thanks Sriram E - MSFT Enterprise Project Management
    Thursday, June 24, 2010 1:04 AM