FIX: Timeout Error While Browsing Data from Analysis Manager

Article translations Article translations
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)
Expand all | Collapse all

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.

Properties

Article ID: 294664 - Last Review: October 23, 2013 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 Analysis Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix kbssas800sp1fix KB294664

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com