Microsoft KB Archive/250632

From BetaArchive Wiki
Knowledge Base


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:

For more information, contact your primary support provider.


Keywords: kbbug kbfix KB250632