Microsoft KB Archive/301472

= FIX: Assertion Occurs When You Use VT_UI4 Integer for SERVICE_TYPE_ID with the OpenSchema Method =

Article ID: 301472

Article Last Modified on 11/21/2006

-

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.



RESOLUTION
To 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

NOTE: 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.



STATUS
Microsoft 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.

Additional query words: OLAP

Keywords: kbbug kbfix kbssas800sp1fix KB301472

-

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

© Microsoft Corporation. All rights reserved.