FIX: OLAP Manager Stops Responding When You Edit Partitions (275919)
The information in this article applies to:
- Microsoft SQL Server OLAP Services 7.0
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:
- In the OLAP Manager, expand the tree for a cube.
- Locate Partitions in the list, and expand the tree for Partitions.
- Right-click a partition in the list, and then click Edit on the pop-up menu.
- In the Partition Wizard, on the last screen, click Advanced.
- 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.
Modification Type: | Major | Last Reviewed: | 11/5/2003 |
---|
Keywords: | kbbug kbfix KB275919 |
---|
|