FIX: Assertion Occurs When You Use VT_UI4 Integer for SERVICE_TYPE_ID with the OpenSchema Method (301472)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q301472
BUG #: 11532 (Plato7.x)
SYMPTOMS
Microsoft Analysis Services Books Online indicates that the restriction for the SERVICE_TYPE_ID should specify a DBTYPE_UI4 integer. According to the OLE DB specification this translates to VT_UI4. However, use of a DBTYPE_UI4 integer for the SERVICE_TYPE_ID with Analysis Services build 8.0.194, may result in an assertion failure or an error message similar to:
Internal program error occurred
CAUSE
The schema rowset marshalling code in Analysis Server does not support marshalling the DBTYPE_UI4 (VT_UI4) type.
RESOLUTIONTo resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
: This fix only works if both the client and server are upgraded to Microsoft SQL Server 2000 Service Pack 1 (SP1).
When you set the restriction for SERVICE_TYPE_ID in MINING_SERVICES_SCHEMA, where either the client or the server is pre-SP1, specify a DBTYPE_I4. DBTYPE_I4 translates to VT_I4.
STATUSMicrosoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.
| Modification Type: | Minor | Last Reviewed: | 4/24/2003 |
|---|
| Keywords: | kbBug kbfix kbssas800sp1fix KB301472 kbAudDeveloper |
|---|
|