Article ID: 294664 - View products that this article applies to.
This article was previously published under Q294664
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11472 (plato7x)
While browsing data from Analysis Manager on slow networks or connections, the query times out and you may receive a message that resembles the following:
Dimension Browser- Marital Status
Unable to browse the dimension 'Marital Status'.
OLAP server error: The operation requested failed due to timeout.
The default OLE DB timeout property is 15 seconds; if it takes longer than 15 seconds for the query to return data, the browser gives the timeout message. Although the default OLE DB timeout value can be configured in the connection string for ADOMD/OLE DB applications, there is no way to configure this value for the Analysis Manager browser.
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Work with your network administrator to tune the network and reduce query response time to less than 15 seconds.
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
The default OLE DB timeout has been increased to 30 seconds in SQL Server 2000 Analysis Services version 8.0, Service Pack 1.
Article ID: 294664 - Last Review: October 23, 2013 - Revision: 1.2