Microsoft KB Archive/888800

= 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: &quot;Object does not exist&quot;

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: &quot;Unable to expand node&quot; 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 &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

885928 FIX: You may receive an &quot;Error 132 – Error during Commit, Server will restart to preserve data consistency&quot; 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 &quot;Cannot open Clipboard&quot; 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 &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

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

