ODI 12c Salesforce Dataserver Connection Test Timed Out Using a Standalone Agent (Doc ID 2313634.1)

Last updated on OCTOBER 20, 2017

Applies to:

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:

• Salesforce Data Server is created under Oracle Technology as below:
  Driver: com.ddtek.jdbc.sforce.SForceDriver
  Driver JDBC URL: jdbc:datadirect:sforce://login.salesforce.com;ConfigOptions=(AuditColumns=auditOnly;MapSystemColumnNames=0;UppercaseIdentifiers=false;deletedRowsBehavior=include;CustomSuffix=Include);;CreateDB=forceNew;StmtCallLimit=0;WSTimeout=0;WSFetchSize=0;WSRetryCount=3;LoginTimeout=0;
• The driver jar file (sforce.jar) is set in the userlib folder, also in the variable ODI_POST_CLASSPATH =/path_to_file/sforce.jar from the instance.cmd file.
• ODI Studio is using the browser proxy, ODI -> Preferences are set as below:
  Web Browsers Tab -> Internet Explorer
  Proxy Settings Tab -> Use System Default Proxy Settings

Changes

Cause