Testing the Salesforce Dataserver Connection Using a J2EE Agent Fails with 'java.net.ConnectException'

Last updated on MARCH 06, 2018

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: 113] [userId: <anonymous>] [ecid: 0000M6rNBKHAtHd5xfk3yW1QY_ob00000A,0:8] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1511866084601] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: 1ba6a1fb-609a-47e9-a8c0-f45a82932e30] 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: login.salesforce.com port: 443
  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://login.salesforce.com/services/Soap/u/38.0: Tried all: 4 addresses, but could not connect over HTTPS to server: login.salesforce.com port: 443
  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://login.salesforce.com/services/Soap/u/38.0: Tried all: 4 addresses, but could not connect over HTTPS to server: login.salesforce.com port: 443
  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