Microsoft KB Archive/256178

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

Article ID: 256178

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q256178



BUG #: 3823 (plato7x)



SYMPTOMS
When you use the Data Transformation Services (DTS) Addin to process a cube or dimension, and the processing fails, the error message is returned by DTS as a HRESULT return code with no associated error message.

The error message that occurs is similar to this:

~CubeName_Update

HResult of 0x800400ce (-2147221298) returned

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

The last 4 digits of the HRESULT contain the actual error number in hexadecimal format. In the sample error message given above, 00ce in hex is 206 in decimal. You can use the error code to determine the actual error message and further troubleshoot the cause of the problem.



WORKAROUND
Refer to the table in the "More Information" section to find out the actual error message and troubleshoot the problem accordingly. You may also run the process from the OLAP Manager, which displays more detailed error information.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The table that follows lists some of the possible error messages from the Data Transformation Services (DTS) Addin, the correct error number and a description for the error.

This may help you to identify the correct error when your processing fails.

Keywords: kbbug kbpending KB256178

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.