Essbase Report Failing With Error Code [nQSError: 96002]Essbase Error: Request [MdxReport] from user [<USER>] Was Terminated Since It Exceeded The Time Limit
(Doc ID 2744846.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
Essbase report failing with following error after applying bundle patch which gives 12.2.1.4.200714 version and the same report works with 12.2.1.4.200114 version.
The non-working analysis is against Essbase source only.
ERROR:
--------
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Request [MdxReport] from user [<USER>] was terminated since it exceeded the time limit (HY000)
--------
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Request [MdxReport] from user [<USER>] was terminated since it exceeded the time limit (HY000)
Changes
Patched OBIEE from 12.2.1.4.200114 version to 12.2.1.4.200714 version.
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 |