KB16652: 'Descriptor received does not match associated data.' error occurs when executing a report in MicroStrategy Developer or MicroStrategy Web against a warehouse residing on an IBM DB2 database

Salesforce Solutions Architect • Strategy

This article notes an error seen with blank SQL statements against DB2

When executing a report in either Strategy Developer or Strategy Web against a warehouse residing on an IBM DB2 database, the following error occurs:


Error: SQL Generation Complete
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data.
Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial (DB2), Job 411, Error Code= -2147212544.

The DSSError logs report the following:


2007-08-29 18:47:53.013-05:00 [HOST:WAS-MSTR][PID:3152][THR:1240][Database Classes][Error] Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data. Connection String: DSN=xxxx;UID=xxxx;IPADDRESS=xxx.xxx.xxx.xxx;TCPPORT=xxxx;DATABASE=xxxx;. SQL Statement: 
.
2007-08-29 18:47:53.060-05:00 [HOST:WAS-MSTR][PID:3152][THR:1240][Query Engine][Error][0x80042300] QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data.

When the report SQL is checked it appears as normal, sometimes an empty SQL pass is seen, and running the SQL in ODBC Test Tool results in correct results.

CAUSE:

This error is caused by a user defined SQL statement containing an empty line.

In this example, the report had an empty Post SQL statement:

Blank entry in 'Report Post Statement 1'

ACTION:

Check all VLDB properties for SQL statements which could contain a blank line. This can occur at the following three levels:

Report level
Template level
Data mart definition level
Database Instance level

KB18419

Comment

0 comments

Details

Knowledge Article

Published:

May 31, 2017

Last Updated:

October 1, 2018

Error: SQL Generation Complete QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data. Error in Process method of Component: QueryEngineServer, Project Strategy Tutorial (DB2), Job 411, Error Code= -2147212544.

2007-08-29 18:47:53.013-05:00 [HOST:WAS-MSTR][PID:3152][THR:1240][Database Classes][Error] Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data. Connection String: DSN=xxxx;UID=xxxx;IPADDRESS=xxx.xxx.xxx.xxx;TCPPORT=xxxx;DATABASE=xxxx;. SQL Statement: . 2007-08-29 18:47:53.060-05:00 [HOST:WAS-MSTR][PID:3152][THR:1240][Query Engine][Error][0x80042300] QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1246: on HSTMT] [DataDirect][ODBC DB2 Wire Protocol driver]Descriptor received does not match associated data.