Answered by:
Cube process stuck - finished building aggregations and indexes for the partition

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 .
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
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.
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
Wednesday, March 19, 2014 11:00 AM -
- Edited by Aleksandr Severin Wednesday, March 19, 2014 11:55 AM
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
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 .
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
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.
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
Wednesday, March 19, 2014 11:00 AM -
- Edited by Aleksandr Severin Wednesday, March 19, 2014 11:55 AM
- Marked as answer by Charlie Liao Sunday, March 30, 2014 11:59 AM
Wednesday, March 19, 2014 11:54 AM