BUG: Incorrect Error Messages from DTS Addin While Processing Cube/Dimension

• Microsoft SQL Server OLAP Services version 7.0

SYMPTOMS

When a cube or dimension is processed using the DTS 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:

Process operation failed.

The filename or extension is too long.

Internal error.

The ring 2 stack is in use.

WORKAROUND

Refer to the table in the More Information section to find out the actual error message and troubleshoot the problem accordingly.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.

MORE INFORMATION

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.

Error From DTS Addin	Actual Error	Error number
The operating system cannot run %1	Error(202): Could not establish connection to the OLAP server	202
The system could not find the environment option that was entered.	Error(203): Initialization failed (%s2)	203
" "	Error(204): Server object not found (%s2)	204
No process in the command subtree has a signal handler	Error(205): Could not open server object (%s2)"	205
The filename or extension is too long	Process operation failed	206
The ring 2 stack is in use	Error(207): Internal error (%s2)	207
The global filename characters, * or ?, are entered incorrectly or too many global filename characters are specified.	Error(208): SQL error (%s2)	208
The signal handler cannot be set	Error(210): The object structure is invalid (%s2)	210
" "	Error(211): Unknown dimension member '%s2'	211
The segment is locked and cannot be reallocated	Error(212): More than the allowed maximum of 64,000 dimension member children for a single parent %s2	212
" "	Error(213): Invalid measure data type found in returned SQL rowset '%s2'	213
Too many dynamic link modules are attached to this program or dynamic link module.	ODBC error: %s1	214
Can't nest calls to LoadModule.	OLAP Server Error: %s1	215
The image file %1 is valid, but is for a machine type other than the current machine.	Error(216): Object structure changed '%s2'	216
" "	Could not lock object (%s1)	218
" "	Could not unlock object (%s1)	224
All pipe instances are busy	%s	231

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)

Internal error, Server initializing Dimension 'Product' (final))

All pipe instances are busy
Invalid object name 'Store';42S02

Additional query words:

Keywords : SSOSdso kbOLAP700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug