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

Agent failed due to error

Received Response
63
Views
4
Comments
User_DJD1A
User_DJD1A Rank 1 - Community Starter
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

Hi Everyone,

I am new to OBIEE. We have a system which was working fine recently one of our agent is failed when i try to run it manually i am getting following error. I am not able to understand it. Could you please let me know what need to be done. Strange thing is other 7-8 agents are running fine from same server.

[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Authentication Failure.

Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC

Location: saw.connectionPool.getConnection, saw.securitysubsystem.checkauthentication.runimpl, saw.securitysubsystem.checkauthentication, saw.delivers.rpc.getDeviceContent, 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.

[nQSError: 43113] Message returned from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password. (08004)

Error Codes:

Location: saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

.

Error Codes: AGEGTYVF

    AgentID: /shared/Agents/Daily SIK Call Reporting_test

    ...Trying Agent Get Response Content loop again.... Sleeping for 3 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Authentication Failure.

Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC

Location: saw.connectionPool.getConnection, saw.securitysubsystem.checkauthentication.runimpl, saw.securitysubsystem.checkauthentication, saw.delivers.rpc.getDeviceContent, 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.

[nQSError: 43113] Message returned from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password. (08004)

Error Codes:

Location: saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

.

Error Codes: AGEGTYVF

    AgentID: /shared/Agents/Daily SIK Call Reporting_test

    ...Trying Agent Get Response Content loop again.... Sleeping for 5 seconds.[nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Authentication Failure.

Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC

Location: saw.connectionPool.getConnection, saw.securitysubsystem.checkauthentication.runimpl, saw.securitysubsystem.checkauthentication, saw.delivers.rpc.getDeviceContent, 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.

[nQSError: 43113] Message returned from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password. (08004)

Error Codes:

Location: saw.delivers.rpc.getDeviceContent, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

.

Error Codes: AGEGTYVF

    AgentID: /shared/Agents/Daily SIK Call Reporting_test

    Exceeded number of request retries for method GetResponseContent.

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Does the Analysis that your /shared/Agents/Daily SIK Call Reporting_test agent run OK? Which version of OBIEE? Which OS? Are the others that work running against the same underlying data source?

  • User_DJD1A
    User_DJD1A Rank 1 - Community Starter

    Thanks Joel for checking.

    This agent runs every day. But from few days it is not running. Other agents with same data source also delivered. We are using OBIEE  11.1.1.7.150120 on Windows server 2008 R2.

    /shared/Agents/Daily SIK Call Reporting_test is a agent which runs and send the entire dashboard as attachment. let me know if you need more information.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Does the Analysis that your Agent runs work ok? When you run the Analysis, do you get any errors? How large (number of rows/columns) is this analysis?

  • User_DJD1A
    User_DJD1A Rank 1 - Community Starter

    Yes, i see all the analysis are working and have no issue. When i download the entire Dashboard it will work but it take time.