Oracle Analytics and AI

Nathan OBI

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?

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.

Joel Acha

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?