October 20, 2011 at 1:00 am
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
October 20, 2011 at 3:05 am
how many rows are in your largest Fact tables?
also are you selecting data from a snow/star - flake schema?
October 20, 2011 at 3:29 am
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?
October 21, 2011 at 12:13 am
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
October 22, 2011 at 1:29 am
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!!!
October 23, 2011 at 11:51 pm
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply