FIX: Incremental Update of Cube with Distinct Measure Causes Analysis Server to Shut Down (298485)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q298485
BUG #: 11268 (Plato7.x)
SYMPTOMS
After running an incremental update on an Analysis Services cube with a Distinct Count measure as the first or only measure defined in the cube, the server may shut down when subsequent objects are processed in the Analysis Services database.
The Application event log will contain an error message that resembles the following:
Source: MSSQLServerOLAPServices
Event ID: 117
Description: Unexpected fatal error occurred. Attempting to restart
server.
In addition, an error message may be displayed in the Analysis Manager stating that the "connection to the server has been lost".
RESOLUTIONTo 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
Create a measure in the cube before the Distinct Count measure.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 4/24/2003 |
|---|
| Keywords: | kbBug kbfix kbssas800sp1fix KB298485 kbAudDeveloper |
|---|
|