My Oracle Support Banner

"Connection reset by peer" When Loading Large Volumes of Data to Autonomous Database from On-Premise Database Using ODI on Marketplace (Doc ID 2696693.1)

Last updated on AUGUST 28, 2020

Applies to:

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

Symptoms

When attempting to load a large volume of data from an on-premise Oracle Database to Autonomous Data Warehouse (ADW) using Oracle Data Integrator (ODI) on Marketplace, the following error intermittently occurs:

oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: IO Error: Connection reset by peer
  at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:350)
  at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:47)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset by peer
  at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1051)
  at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3561)
  at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:743)
  at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:699)
  at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:413)
  at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:330)
  ...

The knowledge modules in use are LKM SQL to Oracle (Built-in) and IKM Oracle Insert.

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


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