none
Cube process stuck - finished building aggregations and indexes for the partition RRS feed

  • Question

  • Hi friends

    My cube processing stuck up at "Finished building aggregations and indexes for the partition". How can I troubleshoot this.

    Appreciate your help. 


    Royal Thomas

    Tuesday, March 18, 2014 10:10 PM

Answers

  • Hi Thomas ,

    Do you have enough space on the hard disk ? around 10 times than the final cube space .

    Have you tried to process the dimension first and then the partitions one by one ?


    Regards, David .

    Wednesday, March 19, 2014 10:44 AM
  • Hi Royal,

    In addition to the previous reply by David, limit number of rows in fact tables using clauses such as SELECT TOP N or WHERE in DSV. Try process cube again. Will the trouble appear again ?

    Best regards.

    Wednesday, March 19, 2014 11:00 AM
  • Royal,

    Your question is discussed here and here also. May be it will help you out.

    Best regards.



    Wednesday, March 19, 2014 11:54 AM

All replies

  • Hi Thomas ,

    Do you have enough space on the hard disk ? around 10 times than the final cube space .

    Have you tried to process the dimension first and then the partitions one by one ?


    Regards, David .

    Wednesday, March 19, 2014 10:44 AM
  • Hi Royal,

    In addition to the previous reply by David, limit number of rows in fact tables using clauses such as SELECT TOP N or WHERE in DSV. Try process cube again. Will the trouble appear again ?

    Best regards.

    Wednesday, March 19, 2014 11:00 AM
  • Royal,

    Your question is discussed here and here also. May be it will help you out.

    Best regards.



    Wednesday, March 19, 2014 11:54 AM