Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Cube Processing Timeout

Author  Topic 

itsmarkdavies
Starting Member

14 Posts

Posted - 2005-04-19 : 08:02:37
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

   

- Advertisement -