Microsoft KB Archive/308956

= FIX: A Full Process Fails When a Very Large Dimension Slices a Partition =

Article ID: 308956

Article Last Modified on 2/21/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q308956



BUG #: 10991 (PLATO7x)



SYMPTOMS
When Analysis Services attempts a full process, if a Very Large Dimension (VLD) slices a partition, the processing fails.

A VLD is a dimension that typically has more than 4 million members. A VLD is managed in a separate process called Very Large Dimension Manager (VLDM) and the VLDM runs under Msmdvldm.exe.

The processing of a partition, which uses a member of a VLD in the partition slicing options, fails with the following error message in Analysis Manager:

Analysis Server Error: Processing error [Object does not exist]'All Customers USA';

&quot;All Customers USA&quot; is the member on which the partition slice is defined.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000 Analysis Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was first corrected in Microsoft SQL Server 2000 Analysis Services Service Pack 2.



Steps to Reproduce Behavior
NOTE: These steps may make Analysis Services load very slowly depending on how many VLDs you define in the server. Only use these steps if necessary.

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.


 * 1) Run Regedit.
 * 2) Navigate to this registry key and lower the threshold for VLDM (if you use 150000 decimal, the Product and Customer dimensions in FoodMart 2000 become VLD):HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\VLDMThreshold


 * 1) Edit the Sales cube partition in the Cube Editor and slice the partition by the customer dimension and the USA member of the customer dimension.
 * 2) Process the Sales partition.

Make sure to change the registry key VLDMThreshold back to the default of 4000000 hexadecimal.

Additional query words: OLAP FIX SP2 VDLM

Keywords: kbbug kbfix KB308956

-

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

© Microsoft Corporation. All rights reserved.