FIX: DTS Package May Fail Processing Dimensions when Private Dimensions are Deleted from Cube (250632)
The information in this article applies to:
- Microsoft SQL Server OLAP Services 7.0
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.
| Modification Type: | Major | Last Reviewed: | 8/7/2006 |
|---|
| Keywords: | kbBug kbfix KB250632 |
|---|
|