My Oracle Support Banner

Encountered "No More Data To Read From Socket" Intermittently While Executing LP (Doc ID 2549200.1)

Last updated on MAY 24, 2023

Applies to:

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


After initiating a load plan (LP) execution by Data Integration Cloud Service (DICS), it will begin to process data. However, some time later it encounters the following error message:

ODI-1519: Serial step "EXECUTION_STARTUP (InternalID:<ID>)" failed because child step "<CHILD_STEP_NAME>" is in error.
ODI-1217: Session <SESSION_NAME> fails with return code 17410.
ODI-1226: Step <STEP_NAME> fails after 1 attempt(s).
ODI-1228: Task Variable -<VARIABLE_NAME> - fails on the target connection <TARGET_CONNECTION_NAME>.
Caused By: java.sql.SQLRecoverableException: No more data to read from socket


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

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