Cube Processing Timeout

[itsmarkdavies]

I am getting the following error when trying to build a cube. All the Dimensions appear to build OK, but when it comes to do the final big SELECT to join the Dimensions to the Fact Table, it falls over. Does anybody have any ideas that I could try ?. Thanks for your help. :-


Timeout occurred.; Time:19/04/2005 11:30:09
19/04/2005 11:30:09 4095 Processing Partition 'P1' failed. No changes have been made to the database.
19/04/2005 11:30:09 4095 Processing Cube 'P1' failed. No changes have been made to the database.
19/04/2005 11:30:09 4095 Rolling back transaction in Database 'TEST'



mark.davies@npower.com

 

[justins57]

Mark,

Is it timing out or failing to process. I've seen the process just quit running and this is sometimes caused by Backups or Virus Scans. This seems to be a temporary condition and corrects itself the next time you rebuild the Cubes. Other times the OLAP database becomes corrupt and you have to delete all the data files then reprocess the OLAP database to recreate the data files. If this fails, then you should restore your nightly archive of the OLAP database (if you have one) or rebuild your OLAP database.

hth,

Justin