FIX: OLAP Manager Stops Responding When You Edit Partitions

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)
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).
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.
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.
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.
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.
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.
crash hang dissapear lock go away

Article ID: 275919 - Last Review: 02/28/2014 04:22:01 - Revision: 4.1

Microsoft SQL Server OLAP Services

  • kbnosurvey kbarchive kbbug kbfix KB275919