Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
OLAP Build Stuck RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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