Cube Process Failure

Question

Post reply

Cube Process Failure

smecharrafie

Ten Centuries

Points: 1135
More actions
October 20, 2011 at 1:00 am

#146369

Hi,
Upon trying to process a cube (SQL Server 2005), it fails after a duration of 1hr+ with the following error message "OLEDB or ODBC unspecified error". So I took the query that was being called and executed it in SQL management studio but it failed after running for 1hr 40mins due to "not enough disk space" noting that 36GB of free space was available prior to execution. Subsequently I freed up to 120GB of space and the query this time executed successfully after approx 2hrs. Thus I restarted the cube process just so that it would fail again with the above error! I checked in the default settings applied that query timeouts should not occur in both Database Engine/Analysis Services. I'm left confused here, feedback anyone.
Regards,
Samer

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

how many rows are in your largest Fact tables?

also are you selecting data from a snow/star - flake schema?

smecharrafie Ten Centuries Points: 1135 More actions · Answer 2

this cube reads from 1 fact which has around 31 million records. I was afraid that there was an issue with a query timeout , but it is set to 0 : unlimited. Could it related to the size of the data?

smecharrafie Ten Centuries Points: 1135 More actions · Answer 3

Issue resolved, turns out I needed to modify some SSAS properties such for analysis to utilize more server resources, these include:

OLAP \ Process \ AggregationMemoryLimitMin,

OLAP \ Process \ AggregationMemoryLimitMax

OLAP \ Process \ BufferMemoryLimit

OLAP \ Process \ DatabaseConnectionPoolTimeout

As well as the ServerTimeout property

ProKelly SSCommitted Points: 1867 More actions · Answer 4

smecharrafie (10/21/2011)
Issue resolved, turns out I needed to modify some SSAS properties such for analysis to utilize more server resources, these include:
OLAP \ Process \ AggregationMemoryLimitMin,
OLAP \ Process \ AggregationMemoryLimitMax
OLAP \ Process \ BufferMemoryLimit
OLAP \ Process \ DatabaseConnectionPoolTimeout
As well as the ServerTimeout property

I would be interested to know what you modified these to? and why? and where you found the answer as well!!!

smecharrafie Ten Centuries Points: 1135 More actions · Answer 5

Hey,

a friend provided me this link http://technet.microsoft.com/en-us/library/cc966527.aspx

check out points 7, 8.

I incremented the values of the above properties based on recommendations and logical estimation.

Regards,

Samer