ODI 12c Salesforce Dataserver Connection Test Timed Out Using a Standalone Agent
(Doc ID 2313634.1)
Last updated on APRIL 29, 2021
Applies to:
Oracle Data Integrator - Version 12.1.3.0.0 and laterInformation 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: <TID>] [ecid: <ECID>] [oracle.odi.runtime.MrepExtId: <ID>] [oracle.odi.runtime.AgentName: <ODI_AGENT_NAME>] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: <GUID>] Agent <ODI_AGENT_NAME> 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: <TID>] [ecid: <ECID>] [oracle.odi.runtime.MrepExtId: <ID>] [oracle.odi.runtime.AgentName: <ODI_AGENT_NAME>] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: SUPERVISOR] [oracle.odi.runtime.EntityGuid: <GUID>] 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
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |