Microsoft KB Archive/897350

= FIX: The naming convention that the Partition Aggregation utility and the Partition Manager utility use could allow duplicate aggregations for partitions =

Article ID: 897350

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



BUG #: 14550 (Plato7x)



SYMPTOMS
When you use either of the following utilities, duplicate aggregations may be created for a partition:
 * The Partition Aggregation. The Partition Aggregation utility is included with Microsoft SQL Server Accelerator for Business Intelligence (SQL Server Accelerator for BI).
 * The Partition Manager. The Partition Manager is included with the SQL Server 2000 Resource Kit.



CAUSE
When an aggregation is added to the collection of aggregations for a partition, the Decision Support Objects (DSO) API examines the Name property of the newly added aggregation. DSO performs this test to determine whether the aggregation is a duplicate of any existing aggregation. This test works for the Analysis Manager utilities such as the Storage Design wizard and the Usage Based Optimization wizard. The test works for those utilities because the utilities use the DatasetName (DSN) that the aggregation covers as the name of the aggregation.

Both the Partition Aggregation and the Partition Manager perform the following steps:


 * 1) Remove all existing aggregations from the partition.
 * 2) Add aggregations based on the list shown in utility.

When you are adding aggregations to a partition, the Partition Aggregation and the Partition Manager use the following format as the name for the aggregations:

CustomAgg

Note  is a numeric value that is unique for each aggregation record.

Because the Partition Aggregation and the Partition Manager do not use the DSN in the name, DSO cannot detect if any one of the aggregations are duplicates. With either utility, duplicate aggregations may exist. Additionally, duplicate aggregations may be created if you use the Usage Based Optimization wizard or the Storage Design wizard.



MORE INFORMATION
The Partition Aggregation utility that is included with SQL Server Accelerator for BI has been updated to use the DSN naming convention when saving aggregations. If any duplicate aggregations are found during the save operation, the duplicates are removed from the list, and you receive the following warning message:

Duplicate Aggregations Found

Duplicate Aggregation definitions were found in the aggregation list. These aggregations have been removed.

If you use the Partition Aggregation or the Partition Manager, we recommend that you use the updated version of the utility. To obtain the updated utility, see the &quot;Download Information&quot; section.

If you have developed your own custom DSO application that adds aggregations, update your utility to use the DSN naming convention for aggregation names. By using the DSN naming convention for aggregation names, you help avoid any possible duplicate aggregations. The source code from the Partition Aggregation utility is included in the previous download. You can use that source code as a sample for determining the DSN name of an aggregation.



Download information
The following file is available for download from the Microsoft Download Center:

http://download.microsoft.com/download/a/2/6/a26f9dcc-1ac3-4048-8c69-455a824f3830/PartitionAggUtility.exe

Release Date: April 6, 2005

For more information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

The PartitionAggUtility.exe file contains the following files:





STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: atdownload kbtshoot kbfix KB897350

-

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

© Microsoft Corporation. All rights reserved.