An "ORA-17410: No More Data to Read From Socket" Error Has Been Signaled From An ODI Integration Interface

(Doc ID 423982.1)

Last updated on AUGUST 21, 2017

Applies to:

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



Symptoms

When using Oracle Data Integrator (ODI) to extract data from an Oracle database, after 17000 rows the extraction process interrupts and the following error is signaled:

17410 : null : java.sql.SQLException: No more data to read from socket

or:

java.sql.SQLRecoverableException : No more data to read from socket

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms