FIX: Processing All Dimensions May Fail From OLAP Manager or DTS Package

Article translations Article translations
Article ID: 263155 - View products that this article applies to.
This article was previously published under Q263155
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 9010(plato7x)
Expand all | Collapse all

SYMPTOMS

Processing all shared dimensions, either from Microsoft OLAP Manager or from a Microsoft SQL Server Data Transformation Services (DTS) package, may fail on some databases. If each dimension is individually processed, the process succeeds.

In OLAP Manager, an error message similar to the following might occur in the processing window:
Processing Dimension "Education Level" failed. No changes have been made to the database.
When processing from DTS, the following error message occurs:
Package Error
Error Source: DSO
Description: Invalid Rectangle
Cannot save object inside a DSO transaction.

WORKAROUND

Process each shared dimension one by one instead of trying to process all dimensions from OLAP Manager. When you set up a DTS package with a task that processes all dimensions, split the task into several tasks with each task set to process one dimension.

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

Properties

Article ID: 263155 - Last Review: February 28, 2014 - Revision: 4.1
APPLIES TO
  • Microsoft SQL Server OLAP Services
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB263155

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com