OBIEE Agent: Authentication failed: invalid user/password

Question

Hello,

I have an agent that should send a dashboard page by email. But I get the following error message:

[Util Logger] Exception occurred:

Severity:1

Type:PKN3saw9ExceptionE

File:project/ibotapi/ibotrpcproxy.cpp

Line:159

Message:Authentication failed.

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)

So, he seems to use a "SYSTEM" user according to servers/obis1/log files. But I don't know if this is the Oracle SYSTEM User or some intenal Weblogic "system" user. There is some kind of credential store in Weblogic where I set the DB password for the Oracle SYSTEM user (oracle.bi.system --> system.user) but I still get the error message when starting the Agent.

So, which password(s) and users did I not configure correclty?

Any help appreciated.

Thanks

Malte

maltedietsch · Answer

Hi, a) No OBI version specified when your question is clearly for the OBI product Oracle Business Intelligence Product Version 12.2.1.4.0 (Build BIPS-20180409020153 64-bit) b) The question was how your Agent is configured, not your scheduler General Normal Priority, Use Specified User's Credentials: weblogic Schedule Start on 04/24/2020 02:06:00 PM Recur daily Condition Do not use a condition (always deliver content and run actions) Delivery Content /Shared Folders/EIS/Dashboards/Number Of Transactions - Daily/Number Of Transactions - Daily Recipients Destinations Home Page and Dashboard, Email Actions I enteterd one recipient email address. Thanks

[Deleted User] · Answer

a) No OBI version specified when your question is clearly for the OBI product

b) The question was how your Agent is configured, not your scheduler

maltedietsch · Answer

Hi, operating System is: Oracle Linux Server 7.5. The schedulerconfig.xml is as follows: 3 biplatform_datasource Enterprise Information System 25 .... .... 3 0 false false false 0 100 1 True 2 /u01/app/oracle/config/domains/bi/servers/obisch1/logs 1 1 32 1 16 10240 3 /u01/app/oracle/config/domains/bi/config/fmwconfig/bienv/OBISCH/scripts/common /u01/app/oracle/config/domains/bi/config/fmwconfig/bienv/OBISCH/scripts/scheduler false So is there anything wrong with the config? Oracle version is: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production And we have configured our own Authentication Provider so that the user details are retrieved from views on our system. Maybe it interferes somehow with the email agent? Thanks