Oracle Business Intelligence Applications

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

OBIEE12C Unable to Login to Analytics

Accepted answer
24
Views
2
Comments

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:

  1. All OBIEE services and deployment on weblogic console is showing good
  2. All other URLs like EM Console, Weblogic Console, XMLP Server able to login
  3. There is enough space and sufficient resources on host and DB

Request you to help!

Thanks and Regards,

Sudharsan C

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hi @User_S2WDB

    Not sure if you already found the answer to this question, but for this error you should check the Init Block in the RPD using the Admin tool. Once you fix (or delete unnecessary) the Init block, the issue should be resolved.

    Regards,

    John

Answers