OBIEE 11g: A Report with the Usage Tracking QUERY_BLOB Column Throws "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P" and "ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute"
Last updated on DECEMBER 13, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
- Using OBIEE 11g with the Usage Tracking (UT) tables in an Oracle Database 11gR2
- The S_NQ_ACCT.QUERY_BLOB column is defined as a CLOB type within the Oracle Database and contains the entire logical SQL statement without any truncation.
- When this column is exposed in the BMM and Presentation Layers, and an Analysis with this column is executed, the following error is thrown:
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms