SYMPTOMS
In Microsoft SQL Server 2000 Analysis Services, when you perform an incremental update of a changing dimension, you may receive
an error message that is similar to the following:
Analysis Server Error: Connection to the server is lost
Rolling back transaction in Database 'Database Name'
Connection to the server is lost
An error message that is similar to the following may appear in the Event Viewer Application log on the Analysis Services server:
Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: Server
Event ID: 117
Date: Date of Event
Time: Time of Event
User: N/A
Computer: Analysis Server Computer Name
Description:
Unexpected fatal error occurred. Attempting to restart server.
RESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix information
Prerequisites
This hotfix requires Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3).
Restart information
You do not have to restart your computer after you apply this hotfix.
Registry information
None.
The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.
SQL Server 2000 Analysis Services 32-bit version
Date Time Version Size File name
----------------------------------------------------------
07-Oct-2004 22:25 8.0.981.0 221,760 Msmdcb80.dll
07-Oct-2004 22:25 8.0.0.981 4,063,808 Msmddo80.dll
07-Oct-2004 22:25 8.0.981.0 1,036,864 Msmdgd80.dll
07-Oct-2004 22:25 8.0.981.0 172,608 Msmdpump.dll
07-Oct-2004 22:25 8.0.0.981 9,642,564 Msmdsgn80.dll
07-Oct-2004 22:25 8.0.981.0 2,089,552 Msolap80.dll
07-Oct-2004 20:58 8.0.981.0 446,524 Msmdsgn.rll
07-Oct-2004 20:19 8.0.981.0 213,068 Msolap80.rll
SQL Server 2000 Analysis Services 64-bit version
Date Time Version Size File name
----------------------------------------------------------
07-Oct-2004 23:52 8.0.981.0 5,529,088 Msmdcb80.dll
07-Oct-2004 23:52 8.0.981.0 5,837,824 Msmdgd80.dll
07-Oct-2004 23:53 8.0.981.0 5,168,128 Msmdpump.dll
07-Oct-2004 23:52 8.0.981.0 6,032,896 Msmdsrv.exe
07-Oct-2004 23:53 8.0.981.0 6,707,200 Msolap80.dll
07-Oct-2004 22:34 8.0.981.0 201,728 Msolap80.rll
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.