My Oracle Support Banner

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 FEBRUARY 02, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information 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)

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


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