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 SEPTEMBER 27, 2021
Applies to:
Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and laterInformation 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 |