DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 888800 - Last Review: June 20, 2014 - Revision: 3.0

 

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