Microsoft KB Archive/250632

= FIX: DTS Package May Fail Processing Dimensions when Private Dimensions are Deleted from Cube =

Article ID: 250632

Article Last Modified on 8/7/2006

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q250632



BUG #: 3874 (Plato7x)



SYMPTOMS
A Data Transformation Services (DTS) package may fail to process with the following error message when all dimensions in a database are set to process and when one or more private dimensions are deleted from the cubes in this database:

Package Error

Error Source: cubeName^dimensionName

Error Description: All pipe instances are busy.

Invalid object name 'store2';42S02



CAUSE
When private dimensions are deleted, the corresponding entries are not removed from the OLAP repository database. When all dimensions are set to process in a DTS package, DTS attempts to process all dimensions listed in the repository. However, if the source column or table is missing for these private dimensions, then the processing fails.



STATUS
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8

For more information, contact your primary support provider.

Keywords: kbbug kbfix KB250632

-

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

© Microsoft Corporation. All rights reserved.