Microsoft KB Archive/298485

= FIX: Incremental Update of Cube with Distinct Measure Causes Analysis Server to Shut Down =

Article ID: 298485

Article Last Modified on 11/21/2006

-

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 &quot;connection to the server has been lost&quot;.



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
Create a measure in the cube before the Distinct Count measure.



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.

Additional query words: OLAP 117 Unexpected fatal error occurred

Keywords: kbbug kbfix kbssas800sp1fix KB298485

-

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

© Microsoft Corporation. All rights reserved.