A list of the bugs that are fixed in SQL Server 2000 Analysis Services Service Pack 4

Article translations Article translations
Article ID: 888800
Expand all | Collapse all

INTRODUCTION

This article contains information about the problems that are fixed by Microsoft SQL Server 2000 Analysis Services Service Pack 4 (SP4).

Note Service packs are cumulative. Each new service pack contains all the fixes that are in earlier service packs, together with any new fixes. You do not have to install an earlier service pack before you install the latest one.

For more information about how to obtain SQL Server 2000 service packs, 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

More information

For more information about the problems that are fixed by SQL Server 2000 Analysis Services Service Pack 4, click the following article numbers to view the articles in the Microsoft Knowledge Base:
329479 FIX: Cannot set description for dimensions and measures by using the CREATE GLOBAL CUBE statement
810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a
811628 FIX: Many temporary tables remain after Analysis Services drills down a ROLAP cube in SQL Server
813487 FIX: RealTime cube performance may decrease when update activity occurs on the non-source SQL Server database
814406 FIX: Analysis server does not release memory after an incremental update
814414 FIX: Error messages may occur during parallel processing of partitions after you apply SQL Server 2000 Analysis Services Service Pack 3
814956 FIX: The CREATE CUBE command fails if you use the TYPE TIME dimension
815291 FIX: A delay occurs during a writeback operation if you do not have the correct permissions
815292 FIX: Writeback to cell fails if the cube contains a virtual dimension
816480 FIX: Cannot use user-defined functions in dimension security definitions
816651 FIX: Use of the NON EMPTY keyword on sets with more than 2 billion members might cause analysis server to restart
817285 FIX: You may receive an error message after you run an MDX query that contains a user-defined function
819609 FIX: The XML for Analysis Services provider result set does not contain the hierarchy name
820358 FIX: A lazy aggregation might fail after an incremental update of a changing dimension
821103 FIX: The processing of a cube that contains a virtual dimension fails with error message: "Object does not exist"
821104 FIX: Query results are not correct after you perform an incremental update of a changing dimension and a virtual dimension
821180 FIX: Introduction of the cache Ratio2 parameter
821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3
821463 FIX: Pending writeback may cause results that are not accurate
821479 FIX: Analysis client sends calculated member definitions when a query is sent to a server
821752 FIX: Restricted Client property is not available in the connection properties collection
822277 FIX: Analysis Services service quits during processing and does not restart
822838 FIX: "Unable to expand node" error message when you try to expand a member node
822839 FIX: #ERR is returned for cells that are sourced from remote partitions
823373 FIX: Access violations may occur in Analysis Services if real-time ROLAP cubes are stressed
823474 FIX: An MDX query may fail if it references a dimension that has been loaded by the VLDM
825804 FIX: Hotfix information for build 8.0.872 of SQL Server 2000 Analysis Services 64-bit
826524 FIX: NON EMPTY keyword phrase may not remove all empty members from a virtual cube
827898 FIX: Specify the Analysis Services client locale on the connection string
827899 FIX: Prevent Analysis Services processing requests from blocking queries
827916 FIX: Dimension calculated member caption blank if dimension uses Caption type member property
829050 FIX: Calculated member in WHERE clause may cause empty result
829051 FIX: A memory leak may occur when many connections are made in Analysis Services
829081 FIX: MDX query results may not be correct if dimension security is defined on a dimension
829582 FIX: Execution Location and Default Isolation Mode connection string properties return results that are not correct
829897 FIX: Dimension security on a cube with Distinct Count may return #ERR
829899 FIX: Delete of dimension member in write-enabled dimension may cause service to restart
830393 FIX: Queries return empty result sets if a calculated member is defined by using the NonEmptyCrossjoin function
830722 FIX: Cube processing performance is slower on the 64-bit version of Analysis Services than it is on the 32-bit version
830894 FIX: An embedded quotation mark in the MDX ALTER CUBE command removes the character that comes before the quotation mark
831042 FIX: Analysis Services crashes if you incrementally update a non-changing dimension
831044 FIX: The OpenSchema method returns null for the custom member property of a parent-child dimension level
831045 FIX: A memory leak occurs when you incrementally update dimensions that contain member properties
831046 FIX: Incorrect results are returned if a slice occurs on a virtual dimension in a cube that has multiple partitions
831652 FIX: A query on a real-time cube may block real-time updates for other cubes
831655 FIX: An MDX query on a real-time update enabled cube returns results from the client-side cache
831665 FIX: A drillthrough request may cause a SQL Server 2000 Analysis Services server to shut down
831667 FIX: The writeback operation is not successful when you try to update a cube in SQL Server 2000 Analysis Services
831710 FIX: A memory leak occurs when you process a cube in Analysis Services
833162 FIX: An incorrect set of dimension members may be returned in Analysis Services
833342 FIX: The Analysis Services service may shut down and then restart when you run MDX queries on a remote computer
833980 FIX: The initialization phase of Analysis Services database processing takes several hours to complete
834419 FIX: You cannot exclude members of the computer Administrators group from the OLAP Administrators group
834490 FIX: MDX queries on a cube that contains a virtual dimension may not reflect changes after the incremental update on the virtual dimension
834491 FIX: The UPDATE CUBE MDX statement writes the remainder value of the writeback formula to a NULL cell
834494 FIX: Calculated members may return incorrect results for dynamic formulas
834495 FIX: Cut-and-paste operations fail with an internal error in Analysis Manager in SQL Server 2000 Analysis Services
834777 FIX: Some cubes are not processed by the process database operation
834837 FIX: When using the Microsoft Decision Support Objects (DSO) library to perform a processReaggregate operation on a cube the SQL Server 2000 Analysis Services service may shutdown and then restart
834844 FIX: The UserName function returns NULL or an empty string in an MDX query or in an MDX expression
835975 FIX: Aggregations return Zero values for members of Roles with restricted Measures access
837724 FIX: An MDX query runs slower when it uses a user-defined function in dynamic security in Analysis Services
838004 FIX: MDX queries to cubes where real-time updates are enabled may not reflect updates to the relational table
838840 FIX: A memory leak occurs in Analysis Services when a VBA function is used in a calculation
839854 FIX: An MDX query stops responding if the result for an axis contains more than 64,000 members
840223 FIX: The Analysis server computer stops responding when you process dimensions and virtual dimensions
841178 FIX: The Analysis Services service may shut down if the Cache Policy connection property's value is set to 7
841856 FIX: A memory leak occurs when you run queries in the same connection in Analysis Services
842707 FIX: Changes to the member properties structure in SQL Server 2000 Analysis Services can cause incorrect results or service failures
842708 FIX: No warning dialog box appears when changes are made to the member properties in a dimension
842859 FIX: Drillthrough operations on a cube fail if the dimension table has been assigned an alias
843262 FIX: You may notice that the query performance on an Analysis Services cube degrades temporarily after an incremental update processes the virtual dimensions
872783 FIX: Query performance decreases when you run a query against an Analysis Services server that has dynamic security implemented for many users
872934 FIX: An Analysis Services server appears to stop responding when a complex query that takes a long time to complete is run against a SQL Server 2000 Analysis Services server
873386 FIX: The Analysis Services service may restart unexpectedly when you try to process a cube partition that has one or more virtual dimensions
873440 FIX: You may receive an error message when an invalid user tries to browse an Analysis Services cube that implements dynamic dimension security by defining a custom cube role
883656 The MSSQLServerOLAPService service may stop and then restart when you incrementally update dimensions in Analysis Services
884040 FIX: An MDX query returns unchanged data when you try to perform an incremental update on a virtual dimension that is used in a remote partition for a cube in SQL Server 2000 Analysis Services
884525 Additions to the SQL Server 2000 Service Pack 4 readme files
885421 FIX: You may experience slow performance when you use the VBA CDate function in a calculated member in SQL Server 2000 Analysis Services
885424 FIX: You receive an error message and Analysis Manager stops responding when you use the Datamember function on a parent-child dimension in SQL Server 2000
885426 FIX: You receive an "Analysis Server Error: Connection to the server is lost" 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
885928 FIX: You may receive an "Error 132 – Error during Commit, Server will restart to preserve data consistency" error message when you try to perform an incremental update on a virtual dimension for a cube 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
888096 FIX: You receive a "Cannot open Clipboard" error message in SQL Server 2000 Analysis Services when you run the InitializeDesign method in a DSO object from an ASP page in IIS 6.0
889524 FIX: You receive an "Unexpected error encountered while updating repository Overflow" 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
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

References

For more information about problems that are fixed in SQL Server 2000 Service Pack 4, click the following article number to view the article in the Microsoft Knowledge Base:
888799 A list of bugs that are fixed in SQL Server 2000 Service Pack 4

Properties

Article ID: 888800 - Last Review: June 20, 2014 - Revision: 3.0
Keywords: 
kbtshoot kbfix KB888800
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

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