Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

After upgrade to 12c report is erroing out saying The user request exceeded the maximum query govern

Question
21
Views
0
Comments

Hi All,

Hi All,

We have just upgraded to Oracle Business Intelligence 12.2.1.2.0 version from Oracle Business Intelligence 11.1.1.9.3.  whenever we execute the reports it is failing with the message as below.

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

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 17001.
Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 60009. [nQSError: 60009] The user request exceeded the maximum query governing execution time.
Please have your System Administrator look at the log for more details on this error. (HY000)

While searching we found the below solutions Doc ID 2060310.1,  Doc ID 2187713.1 but after performing these steps also the report is throwing same error.
Can you Help on the same.