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:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |