OBIEE 11.1.1.9.x Error "OPR4ONWY:U9IM8TAC:OI2DL65P" When Using a Long Varchar Column (Doc ID 2241406.1)

Last updated on APRIL 25, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.160119 and later
Information in this document applies to any platform.

Symptoms

While opening an analysis the following error is displayed:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] 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 CHAR got LONG at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation failed. (HY000)

 

Changes

You have upgraded to 11.1.1.9.x

Cause

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