Microsoft KB Archive/888800

From BetaArchive Wiki
Knowledge Base


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

Article ID: 888800

Article Last Modified on 11/21/2006



APPLIES TO

  • Microsoft SQL Server 2000 Analysis Services SP4



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



Additional query words: fixlistsp4 olap package

Keywords: kbtshoot kbfix KB888800