Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

[nQSError: 60009] The user request exceeded the maximum query governing execution time

Question
34
Views
0
Comments
997883
997883 Rank 1 - Community Starter
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

Hi All,

we have installed obiee11g and Upgraded RPD and webcatalog from 10g.

We are getting the below error while users are running reports, Also sometimes the drop down list also longtime to fetch the result.

Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [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)


Installed softwares.

OBIEE11g(11.1.1.7)

Applied Patch(Jan2016 patch).

OHS 11g.



Thanks,

Jeevan Veereddy.