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

997883

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.