My Oracle Support Banner

ODI Data Server Test Connection to Autonomous Data Warehouse Cloud Fails with Error "java.sql.SQLException: IO Error: General SSLEngine problem, connect lapse 46 ms., Authentication lapse 0 ms" (Doc ID 2479399.1)

Last updated on OCTOBER 22, 2019

Applies to:

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

Symptoms

The following error is observed when using Oracle Data Integrator (ODI) 12.2.1.3 and testing the connection to an Oracle Autonomous Data Warehouse (ADW) Cloud Data Server:

[2018-11-29T09:01:11.955-06:00] [odi] [ERROR] [] [oracle.odi.core.persistence] [tid: <TID>] [ecid: <ECID>] Oracle.odi.runtime.agent.ExecutionException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: General SSLEngine problem, connect lapse 46 ms.,
Authentication lapse 0 ms.[[
  at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:305)
  at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)
  at ...
Caused by: java.sql.SQLException: IO Error: General SSLEngine problem, connect lapse 46 ms., Authentication lapse 0 ms.
  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)
  ... 12 more
Caused by: java.sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 46 ms., Authentication lapse 0 ms.
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:795)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:414)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:387)
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:354)
  at ...
...
...
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
  at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
  at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)
  at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:392)
  ... 35 more

oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:472)
  at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1152)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
  at java.lang.Thread.run(Thread.java:748)

Note: the following properties were added under the "JDBC" tab of the ADW Cloud Data Server:

Key:     oracle.net.wallet_location
Value:     (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY=< Your Unzipped Client Credentials Folder >)))

Key:      oracle.net.ssl_version
Value:    
1.2

 

 

In the example above, the JDBC URL, SID, and Directory details represent a fictitious sample (based upon made up data) or uses the default value and are provided for clarity.  Any similarity to actual environments, previous or current, is purely coincidental and not intended in any manner.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.