PRB: Processing Partitions From DTS Does Not Process Private Dimensions (263871)

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.

REFERENCES

For additional information about interpreting HResult error codes that are returned by the OLAP DTS Services Processing task, click the article number below to view the article in the Microsoft Knowledge Base:

256178 BUG: OLAP DTS Task May Display HRESULT Error Codes on Failure