dbTalk Databases Forums  

Cube processing failure - Urgent

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


Discuss Cube processing failure - Urgent in the microsoft.public.sqlserver.olap forum.



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

Default Cube processing failure - Urgent - 01-13-2004 , 02:26 AM






hi,
we are using analysis Services sp3a installed , Machine configuration is 2 GB RAM and dual processor with 70 GB HD Capacity.

The Fact table contains 2.6 million records
Largest dimension contains : 1.7 m records
with a Distinct Count Measure
No. of. Dimensions :40

The cube processing consuming almost 20 GB of Tempdb space and create segments of the partitions (which is ok with me) and after arround 19 hours another instance of Analysis manager shows processing of cube has completed. but the the other instance will stil be processing the cube.
But when I end the task I am able to see the following error message in the processing window " Invalid procedure call or argument " and processing has failed message
But I am able to browse the cube.

Please suggest me the reason for processing failure and the required hardware for processing such a huge cube.






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.