My Oracle Support Banner

OBIEE 12c: Dashboards Throwing Error "OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P" After Upgrade to 12.2.1.4.0 from 12.2.1.2.0 (In-place) (Doc ID 2603014.1)

Last updated on OCTOBER 29, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition : 12.2.1.4.0 version, Analytics

After upgrading from OBIEE 12.2.1.2.0 to OBIEE 12.2.1.4.0.when ran the report, getting below error.

Error Message at Report level:

   View Display Error
  
   Odbc driver returned an error (SQLExecDirectW).

   Error Details
 
   Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

 Can also see below error in obis1-diagnostics.log:

Query Status: [nQSError: 17011] SQL statement execution failed. [[
[nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected CLOB got CHAR at OCI call OCIStmtExecute.
[nQSError: 43119] Query Failed:

Changes

Upgrade to 12.2.1.4.0 from 12.2.1.2.0 (In-place)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.