Article ID: 243545 - View products that this article applies to.
This article was previously published under Q243545
BUG #: 3823 (plato7x)
When a cube or dimension is processed using theDTS Addin and the processing fails for some reason, the error message that displays is incorrect.
An operating system error message displays instead of the Decision Support Object (DSO) error message. For example, if the program should fail with the following 206 error:
the following operating system 206 error displays instead:
Process operation failed.
Similarly, the following 207 error:
The filename or extension is too long.
The ring 2 stack is in use.
Refer to the table in the More Information section to find out the actual error message and troubleshoot the problem accordingly.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
The following table lists some of the possible error messages from the Data Transformation Services (DTS) Addin and the corresponding correct error message. This may help you to identify the true error when your processing fails.
Collapse this tableExpand this table
Note that most of the preceding error messages have a second part, which are shown correctly and can help you find the root cause of the problem. For example, when you get error 207, you would see an error like:
The ring 2 stack is in use, Server initializing Dimension 'Product' (final)
And when you see error 231, it will be:
Internal error, Server initializing Dimension 'Product' (final))
All pipe instances are busy
Invalid object name 'Store';42S02