Hi Team,
Unable to login to OBIEE Analytics on our existing OBIEE12c with Admin as well, we are getting below issue:
Issue1:
Error[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW).SeverityError[nQSError: 13052] The authentication has exceeded the allowed amount of time.SeverityError[13011] Query for Initialization Block 'status' has failed.SeverityError[nQSError: 60009] The user request exceeded the maximum query governing execution time.SeverityErrorOdbc driver returned an error (SQLDriverConnectW).
Issue2:
[2025-02-23T08:58:06.970+05:30] [OBIS] [ERROR:1] [] [] [ecid: 006BgQKISZZ89xBUvYctkH0001jO00002S,0:6:4] [sik: ssi] [tid: b8869700] [nQSError: 60009] The user request exceeded the maximum query governing execution time. [[^M
file: server/Query/Execution/DbGateway/Oci10g/../Oci8/Src/SQXDGOci8.cpp; line: 411^M
Properties: description=SessionVar Exchange; producerID=0x3991a000; requestID=0xfffe0044; sessionID=0xfffe0000; userName=weblogic; ^M
[nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation
at OCI call OCIStmtFetch.^M
********** Task: 1. Running for (mls): **********
Description: At OCI call OCIStmtFetch
Oci8Status:OCI_ERROR
RequestID:fffe0044
SQL Query:select msg from OBIEE_INPROGRESS_STATUS
Kindly note below:
- All OBIEE services and deployment on weblogic console is showing good
- All other URLs like EM Console, Weblogic Console, XMLP Server able to login
- There is enough space and sufficient resources on host and DB
Request you to help!
Thanks and Regards,
Sudharsan C
