I am working with a cube with 10 million rows. A drill
through on the Cube fails due to a Timeout. I have set the
timeout on the AS properties to 240 seconds, i.e. 5 mins,
the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server\CurrentVersion\MaxOLEDBTimeout value is also seen
to be 240 seconds. I am using MSAS SP3. Please suggest a
way to fix this problem?

The storage type of the Cube is MOLAP, and the fact table
is on the same windows server, on SQL Server 2000.

Thanks,
Geeta

Geeta:

Is the error being initiated by AS or SQL Server?

If SQL Server: As the DRILLTHROUGH actually executes a SQL query on the
underlying data structures (in this case SQL Server, if I read correctly),
then the remote query timeout property (set either through sp_configure or
in the EM through Server Properties, Connections, Remote Server Connections)
is probably not set to 0 (unlimited).

If this is not the issue (i.e., the SQL Server timeout is not 0), then you
might want to look at KB 304213. This article also gives some detail on how
to change the DSO timeout in AS.

MTI


"Geeta" <geeta_pajjuri (AT) hotmail (DOT) com> wrote

Thanks Mike.

I checked the SQL Server Remote Query timeout settings, I
changed it to 0 from 600, I do not see any difference even
now. I have a test cube with about 3million rows and it
allows me to drillthrough. I got the Drill through failed
due to a Timeout message in 20 seconds since I try to
drillthrough.

I have made sure that the settings as per atricle KB
304213 are enforced on MSAS. I have set the maximum
timeout to 240 (4 minutes). I have checked the registery
values. There is still no difference, I am still getting a
timeout in 20 seconds.

Any pointers?

Thanks,
Geeta