Oracle Analytics Cloud and Server

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

Categories

Hourly Agent fails sporadically with Authentication Failed Errors

Received Response
33
Views
3
Comments
Nathan OBI
Nathan OBI ✭✭✭
edited August 13 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 ✭✭✭✭✭

    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 ✭✭✭✭✭

    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 ✭✭✭

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