ODI 12c Salesforce Dataserver Connection Test Timed Out Using a Standalone Agent

(Doc ID 2313634.1)

Last updated on OCTOBER 20, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

In an Oracle Data Integrator (ODI) 12.1.3 environment, testing a Salesforce Data Server connection using a Standalone Collocated Agent results in the below error message.

However, testing the connection through the Local (No Agent) is successful.

[2017-07-04T07:43:41.815-04:00] [odi] [ERROR] [ODI-1131] [oracle.odi.agent] [tid: 14434] [ecid: 0000LoDPvq2ATOd5xfg8yW1PMV3500000P,0:4] [oracle.odi.runtime.MrepExtId: 1454995623909] [oracle.odi.runtime.AgentName: TESTODIAGENT] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: b2beabea-da1b-41d8-b4a3-663b17401b27] Agent TESTODIAGENT encountered an error: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Connection timed out: connect
[2017-07-04T07:43:41.815-04:00] [odi] [ERROR] [] [oracle.odi.agent] [tid: 14434] [ecid: 0000LoDPvq2ATOd5xfg8yW1PMV3500000P,0:4] [oracle.odi.runtime.MrepExtId: 1454995623909] [oracle.odi.runtime.AgentName: TESTODIAGENT] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: b2beabea-da1b-41d8-b4a3-663b17401b27] oracle.odi.runtime.agent.ExecutionException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Connection timed out: connect[[
    at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:170)
    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:724)
    at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:640)
...
Caused by: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Connection timed out: connect
    at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doActionWithoutResult(TestDataServerProcessor.java:156)
    at oracle.odi.core.persistence.dwgobject.MasterRepositoryDwgObjectCallbackWithoutResult.doAction(MasterRepositoryDwgObjectCallbackWithoutResult.java:22)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
    at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:87)
... 21 more
Caused by: java.sql.SQLException: [DataDirect][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Connection timed out: connect
    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.doActionWithoutResult(TestDataServerProcessor.java:151)
... 24 more
Caused by: java.sql.SQLNonTransientConnectionException: [DataDirect][SForce JDBC Driver][SForce]java.net.ConnectException: ConnectException invoking https://login.salesforce.com/services/Soap/u/38.0: Connection timed out: connect
    at com.ddtek.jdbc.sforcebase.ddcn.b(Unknown Source)
...
    at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
...

Environment configuration:

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms