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


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
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.

Last 4 Digits of HRESULTError NumberDescription
00CA202Could not establish connection to the OLAP server.
00CB203Initialization failed.
00CC204Server object not found.
00CD205Could not open server object.
00CE206Process operation failed.
00CF207Internal error.
00D0208SQL error.
00D1209Could not initiate dimension update.
00D2210The object structure is invalid.
00D3211Unknown dimension member.
00D4212More than the allowed maximum of 64,000 dimension member children for a single parent.
00D5213Invalid measure data type found in returned SQL rowset.
00D6214ODBC error:
00D7215OLAP Server Error:
00D8216Object structure changed.
00DA218Could not lock object.
00E0224Could not unlock object.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbBug kbpending KB256178
©2003 Microsoft Corporation. All rights reserved.