Testing the Salesforce Dataserver Connection Using a J2EE Agent Fails with 'java.net.ConnectException' (Doc ID 2363906.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

In an Oracle Data Integrator (ODI) 12.2.1.3 environment, testing a Salesforce Data Server (built in Oracle Technology) is successful with the Local / No Agent, however testing the connection with a J2EE Agent is failing with the following message:

[2018-02-21T03:04:32.951-05:00] [ODI_server1] [ERROR] [ODI-1592] [oracle.odi.agent] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: <ID>] [oracle.odi.runtime.AgentName: <OracleDIAgent>] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: <GUID>] Error occurred testing connection to dataserver with agent <OracleDIAgent>[[
ODI-1592: Error occurred testing connection to dataserver with agent <OracleDIAgent>
Caused By: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Tried all: 4 addresses, but could not connect over HTTPS to server: <SALESFORCE_LOGIN_SERVER> port: <PORT>
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:276)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:121)
  at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
  at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:836)
  at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:754)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  ...
Caused by: java.sql.SQLException: [FMWGEN][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://<SALESFORCE_LOGIN_SERVER>/services/Soap/u/38.0: Tried all: 4 addresses, but could not connect over HTTPS to server: <SALESFORCE_LOGIN_SERVER> port: <PORT>
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
  at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:270)
... 53 more
Caused by: java.sql.SQLNonTransientConnectionException: [FMWGEN][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://<SALESFORCE_LOGIN_SERVER>/services/Soap/u/38.0: Tried all: 4 addresses, but could not connect over HTTPS to server: <SALESFORCE_LOGIN_SERVER> port: <PORT>
  at weblogic.jdbc.sforcebase.ddcn.b(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcn.a(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcm.b(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcm.a(Unknown Source)
  at weblogic.jdbc.sforcecloud.ddd.a(Unknown Source)
..... ]]

ODI Studio is configured to use the System Default Proxy settings.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.