FIX: OLAP Manager Stops Responding When You Edit Partitions

Article translations Article translations
Article ID: 275919 - View products that this article applies to.
This article was previously published under Q275919
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11214 (PLATO7x)
Expand all | Collapse all

SYMPTOMS

When you edit a partition or attempt to perform any action on a partition through the OLAP Manager such as the Usage-Based Optimization Wizard, the OLAP Manager may run out of stack space and stop responding (hang).

CAUSE

When there are a large number of partitions with a blank aggregation prefix, the OLAP Manager must make calls to create a default prefix. To do this, the OLAP Manager goes through all of the partitions in all of the cubes, and if there are too many partitions, the OLAP Manager runs out of stack space.

WORKAROUND

To work around this problem, make sure that all partitions have an aggregation prefix, which is a name to uniquely identify the partition for the cube. To assign an aggregation prefix to a partition, perform the following steps:
  1. In the OLAP Manager, expand the tree for a cube.
  2. Locate Partitions in the list, and expand the tree for Partitions.
  3. Right-click a partition in the list, and then click Edit on the pop-up menu.
  4. In the Partition Wizard, on the last screen, click Advanced.
  5. In the Advanced Option dialog box, in the aggregation prefix text box, type something (such as Sales-Sales1) to identify this partition. The aggregation prefix cannot exceed 22 characters.

MORE INFORMATION

To preserve backward compatibility, this limitation still appears for cubes with the relational OLAP (ROLAP) storage type. To avoid this problem for ROLAP, see the "Workaround" section.

For more information on the aggregation prefix, see the "AggregationPrefix Property" topic in the product documentation.

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 SQL Server OLAP Services 7.0 Service Pack 3. For more information, contact your primary support provider.

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server OLAP Services 7.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack
This problem does not occur in Analysis Services 8.0.

Properties

Article ID: 275919 - Last Review: February 28, 2014 - Revision: 4.1
APPLIES TO
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB275919

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