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

Hourly Agent fails sporadically with Authentication Failed Errors

Received Response
41
Views
3
Comments
Nathan OBI
Nathan OBI Rank 3 - Community Apprentice
edited August 2024 in Oracle Analytics Cloud and Server

We have an agent failing sporadically and I'm trying to track down the cause.

It appears to some sort of authentication error.

Can any of you gurus tell what's failing to authenticate based on these errors?

Agent Error History.png

Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed.

Error Codes: WKY9UVRD:

Authentication Failure.

Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC

Location: saw.connectionPool.getConnection, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Odbc driver returned an error (SQLDriverConnectW).

State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

(08004)

State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.

(HY000)

State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)

, in call Create sessions...Trying main loop again.... Sleeping for 4 seconds.Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed.

Error Codes: WKY9UVRD:

Authentication Failure.

Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC

Location: saw.connectionPool.getConnection, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

Odbc driver returned an error (SQLDriverConnectW).

State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

(08004)

State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.

(HY000)

State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)

, in call Create sessionsTerminal Error: Exceeded number of retries.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Do you mean that the agent works on some occasions and on others, it fails with these errors? What version of OBIEE is this? What is the underlying data source? Have you checked the bi server log files for any possible data source errors?

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Just check the logs:

    Odbc driver returned an error (SQLDriverConnectW).

    State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

    (08004)

    State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.

    (HY000)

    State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)

    , in call Create sessions...Trying main loop again.... Sleeping for 4 seconds.Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed.

    The highlighted ones will give you the clue what is happening and why it's failing.

  • Nathan OBI
    Nathan OBI Rank 3 - Community Apprentice

    This was resolved by pointing OBI to a newer AD server and we also changed 'Group Membership Searching' to Off.