FIX: Timeout Error While Browsing Data from Analysis Manager (294664)

The information in this article applies to:

Microsoft SQL Server 2000 Analysis Services

This article was previously published under Q294664

BUG #: 11472 (plato7x)

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

Work with your network administrator to tune the network and reduce query response time to less than 15 seconds.

STATUS

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.

MORE INFORMATION

The default OLE DB timeout has been increased to 30 seconds in SQL Server 2000 Analysis Services version 8.0, Service Pack 1.

Modification Type:	Minor	Last Reviewed:	4/24/2003
Keywords:	kbBug kbfix kbSQLServ2000sp1fix kbssas800sp1fix KB294664 kbAudDeveloper