ODI Error 'oracle.odi.runtime.agent.ExecutionException: Communications link failure' When Testing Connection to MySQL Technology
(Doc ID 2294027.1)
Last updated on NOVEMBER 30, 2021
Applies to:
Oracle Data Integrator - Version 11.1.1.5.0 and laterInformation in this document applies to any platform.
Symptoms
In Oracle Data Integrator 11.1.1.5 or higher, testing a Data Source connection to a MySQL database fails with both the Local (No Agent) and a remote J2EE Agent, and the following error is displayed:
2017-07-21 11:18:41.929 ERROR ODI-1131 Agent OracleDIAgent encountered an error: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2017-07-21 11:18:41.930 ERROR oracle.odi.runtime.agent.ExecutionException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:144)
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:512)
at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
<...snip...>
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 |