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

Last updated on JULY 13, 2016

Applies to:

Oracle Payments - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jun-2014***

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)
...

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