"No more data to read from socket" Exception when Running Create Settlement Batches (Doc ID 1437170.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Create Settlement Batches fails with the following exception:

prog_name: IBY_FC_CREATE_SETTLE_BATCHES
retry_flag: N
Task Parameter: key: P_CONC_PROGRAM_NAME, value: IBY_FC_CREATE_SETTLE_BATCHES
Task Parameter: key: P_RETRY_FLAG, value: N

Processing EFT BATCH CLOSE operations ..

java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
...
...
oracle.apps.iby.exception.DatabaseException: IBY_40000 (SQL_EXCEPTION=No more data to read from socket)
at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:208)
at oracle.apps.iby.database.DBWrapper.raiseDBException(DBWrapper.java:218)
at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:89)
at oracle.apps.iby.engine.ExtractGenerator.createExtract(ExtractGenerator.java:56)
at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:874)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
...

Changes

Cause

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