Microsoft KB Archive/907323

= Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 =

Article ID: 907323

Article Last Modified on 11/29/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services SP4

-



SUMMARY
This article lists the hotfixes that were originally released for Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), but that were not included in Service Pack 4 (SP4). These hotfixes are now available in a downloadable post-SP4 hotfix rollup package for SQL Server 2000 Analysis Services.

Here are some important notes regarding this hotfix rollup package:  To apply this hotfix rollup package, you must have SQL Server 2000 Analysis Services SP4 installed. 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

 This hotfix rollup package is Microsoft SQL Server 2000 Analysis Services Build 8.0.2174.



How to obtain the hotfix rollup package
To obtain this hotfix rollup package, visit the appropriate Microsoft Download Center Web site for the Microsoft Windows operating system that you have:
 * For x86-based systems and for x64-based systems

http://www.microsoft.com/downloads/details.aspx?FamilyId=A643980A-26A4-44C1-9B50-53E20E7210B5
 * For Itanium-based systems

http://www.microsoft.com/downloads/details.aspx?FamilyId=243A8A89-74D6-48FD-933F-32FF9D8459C2
 * For client installations (PTSLite.exe)

http://www.microsoft.com/downloads/details.aspx?FamilyId=2BB62F35-D041-42AC-98DA-6EC97168BE21

Note Clients that connect to a server that has received this hotfix rollup package should be running the updated OLE DB for OLAP components. To install the updated OLE DB for OLAP components, run the PTSLite.exe client installation.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.



Hotfixes that are included in SQL Server 2000 Analysis Services post-SP4 build 8.00.2174
885426 FIX: You receive an &quot;Analysis Server Error: Connection to the server is lost&quot; error message when you suspend and then resume operations on a cube in SQL Server 2000 Analysis Services

885435 FIX: The DSO Process(ProcessSuspendLazyProcessing) method does not suspend the lazy processing of aggregations on a remote partition in SQL Server 2000 Analysis Services

886761 FIX: You may receive an “Analysis Server Error: Connection to the server is lost” error message during an incremental update of a changing dimension in SQL Server 2000 Analysis Services

889524 FIX: You receive an &quot;Unexpected error encountered while updating repository Overflow&quot; error message when you try to restore an OLAP database in SQL Server 2000 Analysis Services

890020 FIX: Real-time updates to a cube that contains ROLAP partitions may not reflect updates that are made to the relational data in the underlying source tables for the ROLAP partitions in Analysis Services 64 bit

890664 FIX: Event ID 128 may be logged if the lazy aggregation process is suspended multiple times in SQL Server 2000 Analysis Services

890665 FIX: The Analysis Services service may unexpectedly stop and then restart on a server that is hosting a remote partition of a cube and that is running SQL Server 2000

892139 FIX: An out-of-memory condition occurs when you run a query against a cube that contains calculated cells in SQL Server 2000 Analysis Services

891575 FIX: The MDX query is unsuccessful and you receive an error message if you query a ROLAP-based dimension in SQL Server 2000 Analysis Services

891580 FIX: Analysis Manager or another third-party DSO application crashes when you try to use a cell action in SQL Server 2000 Analysis Services

892517 FIX: A drillthrough operation fails, and you may receive an &quot;Unable to drill through&quot; error message after you configure drillthrough permissions on a virtual cube in SQL Server 2000 Analysis Services

892589 FIX: System performance is decreased for user-mode applications on the server in the 64-bit version of Analysis Services

893091 FIX: You receive a &quot;Connection timed out or lost&quot; error message or a &quot;COMException&quot; error message when you use ADOMD.NET to connect to a remote OLAP server in SQL Server 2000 Analysis Services

894687 FIX: The Spanish versions of SQL Server 2000 Analysis Services hotfix packages do not install correctly

896174 FIX: Error message when you modify the security of a custom dimension in SQL Server 2000 Analysis Services: &quot;Dimension Security Syntax Error: Set name 48818.79 is not valid&quot;

898109 FIX: SQL Server 2000 Analysis Services may unexpectedly close when you process a cube by using a custom Decision Support Object application and you query the cube in parallel by using one or more threads

899024 FIX: You may not be able to capture user dump files in SQL Server 2000 Analysis Services

899025 FIX: The SQL Server 2000 Analysis Services process may stop accepting connections and may appear to stop responding when you stop a SQL Server transaction after that transaction requests a lock

900716 FIX: Physical memory usage increases for multithreaded applications in SQL Server 2000 Analysis Services

903030 FIX: A Decision Support Objects (DSO) connection attempt fails after you install SQL Server 2000 Analysis Services Service Pack 4

905223 FIX: An access violation may occur, and Event ID 117 may be logged in the Application event log when a dimension that is used as the basis for multiple virtual dimensions is dropped and then re-created in SQL Server 2000 Analysis Services

909393 FIX: An access violation occurs and the Analysis Services service unexpectedly quits during the Startup process in Microsoft SQL Server 2000 Analysis Services

899806 FIX: The MSSQLServerOLAPService service restarts unexpectedly when you use the ALTER CUBE statement in SQL Server 2000 Analysis Services

907813 FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 S907813

910480 FIX: Real-time updates that are made on Relational Online Analytical Process partitions may not be reflected in the query results when you use SQL Server 2000 Analysis Services

911023 FIX: In SQL Server 2000 Analysis Services, a memory leak may occur in the handle thread when you run an MDX query that uses formulas or recursions

Additional query words: rollup hotfix cumulative 911023 build 2174

Keywords: atdownload kbfix kbinfo kbqfe kbhotfixserver KB907323

-

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

© Microsoft Corporation. All rights reserved.