dbTalk Databases Forums  

Cube times out

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Cube times out in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Fazal Sorathia
 
Posts: n/a

Default Cube times out - 05-23-2006 , 09:50 AM






I am processing a cube with partitions based on Quarters (Date Dimension). My
fact table has around 60 millions records. Cube processes fine if I dont have
nay index on the fact table. But when I create any index, the processing
times out and I need to restart my OLAP service to do further work. Any idea
what is the reason behind this timing out. I am using AS 2000.
Any help is appreciated.
Thanks,
Fazal

Reply With Quote
  #2  
Old   
Designing-Systems.com
 
Posts: n/a

Default RE: Cube times out - 05-23-2006 , 01:50 PM






hi,

This may be specific to your system configuration (hardware and RAM).
Investigate the load and review the server log to identify the part that
failed during processing.

Regards,
-----------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
------------------------------------------------

"Fazal Sorathia" wrote:

Quote:
I am processing a cube with partitions based on Quarters (Date Dimension). My
fact table has around 60 millions records. Cube processes fine if I dont have
nay index on the fact table. But when I create any index, the processing
times out and I need to restart my OLAP service to do further work. Any idea
what is the reason behind this timing out. I am using AS 2000.
Any help is appreciated.
Thanks,
Fazal

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.