Microsoft KB Archive/263871

= PRB: Processing Partitions From DTS Does Not Process Private Dimensions =

Article ID: 263871

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q263871



BUG #: 9143 (plato7x)



SYMPTOMS
When a cube partition is processed from OLAP Manager, the private dimensions are automatically processed along with the cube partition. However, if a cube partition is processed from the SQL Server Data Transformation Services (DTS) package, the private dimensions are not automatically processed. If new members are added to the dimension table and corresponding fact records are added to the fact table, processing a cube partition from DTS fails. The error message that occurs is similar to this:

HResult of 0x800400ce (-2147221298) returned

Unexpected error occurred. An error result was returned without an error message.

STATUS
Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.



WORKAROUND
Here are three ways to work around this problem:


 * Process the entire cube instead of a single partition when you use DTS.


 * If processing the cube is not feasible, then consider changing the private dimensions to shared dimensions.


 * Process cube partitions from OLAP Manager only instead of DTS.