Microsoft KB Archive/275919

= FIX: OLAP Manager Stops Responding When You Edit Partitions =

Article ID: 275919

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q275919



BUG #: 11214 (PLATO7x)



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 &quot;Workaround&quot; section.

For more information on the aggregation prefix, see the &quot;AggregationPrefix Property&quot; 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.

Additional query words: crash hang dissapear lock go away

Keywords: kbbug kbfix KB275919

-

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

© Microsoft Corporation. All rights reserved.