Microsoft KB Archive/294664

= FIX: Timeout Error While Browsing Data from Analysis Manager =

Article ID: 294664

Article Last Modified on 11/21/2006

-

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.

Additional query words: TimeOut OLAP The operation requested failed due to

Keywords: kbbug kbfix kbsqlserv2000sp1fix kbssas800sp1fix KB294664

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.