Hello:

I am getting the following error querying an OLAP cube from SQL Server using
OpenQuery and a linked server:
(Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider
returned message: The operation requested failed due to timeout])

This was not happening before, the error started to happen this week after
SQL Server SP4 was applied. There is no timeout (0) on the OLAP server, so
this should not be an issue.

I appreciate any help regarding this issue.

Hello:

The hotfix for SP4 was applied (for SS2K and AS2K), but the issue still. The
same machine hosts both SS2K and AS2K. I tried first with the hotfix for AS,
it did not work, so I applied the hotfix for SS2K, and it did not work either.

I will appreciate any help.

"gborda" wrote:

Hello:

I opened a ticket with Microsoft, and Microsoft identified a bug for the
OLAP provider that comes with SP4. Microsoft suggests, as a workaround for
now, to register msolap80.dll that comes with SP3:

regsvr32 "C:\Program Files\Common Files\System\Ole DB\msolap80.dll"

I have to wait for a later hotfix for SP4.

"gborda" wrote:

After research, Microsoft found out that OLAP driver part of AS 2K SP4 sets
10 minute query timeout. To get around the problem, you need to set Query
Timeout under the Properties of the linked server as a big number such as
3600 (the unit is seconds).

Specifically, please take the following step:
1. Open SQL Enterprise Manager, highlight the linked server, right click
your mouse button and select Properties. Then click the third tab “Server
Options” and change the “Query Timeout” from default value 0 into 3600.

If using OPENROWSET, when the connection is established, it would be
advisable to define a Query Timeout also.

Microsoft treats this as an "undocumented feature", so there will be no
hotfix. As it is, SP4 is final.

"gborda" wrote: