PurgeDSDAndPurchaseOrders Batch Failing With SimServerException (Doc ID 2846461.1)

Last updated on MAY 16, 2022

Applies to:

Symptoms

PurgeDSDAndPurchaseOrders batch failing with SimServerException , before this error temp segment error was observed in purge_error_log table, after increasing the table space receiving this new error:

ERROR
-----------------------
ERROR-230741 Time: 4/21/21 1:21 AM Type: SimServerException Message: Error executing stored procedure.

ERROR [main][o.r.sim.batch.core.SimBatchRunner] Error executing batch: PurgeDsdAndPurchaseOrdersJob
javax.ejb.EJBException: ; nested exception is:
java.io.EOFException
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.unwrapRemoteException(RemoteBusinessIntfProxy.java:130)
at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:102)
at com.sun.proxy.$Proxy39.purgeDsdAndPurchaseOrders(Unknown Source)
at oracle.retail.sim.service.purge.PurgeServiceClient.purgeDsdAndPurchaseOrders(Unknown Source)
at oracle.retail.sim.batch.job.PurgeDsdAndPurchaseOrdersJob.doExecute(Unknown Source)
at oracle.retail.sim.batch.core.SimBatch.execute(Unknown Source)
at oracle.retail.sim.batch.core.SimBatchRunner.main(Unknown Source)
Caused by: java.io.EOFException: null
at weblogic.rjvm.t3.client.MuxableSocketT3.endOfStream(MuxableSocketT3.java:194)
at weblogic.socket.SocketMuxer.deliverExceptionAndCleanup(SocketMuxer.java:857)
at weblogic.socket.SocketMuxer.deliverEndOfStream(SocketMuxer.java:782)
at weblogic.socket.SocketMuxer.readReadySocketOnce(SocketMuxer.java:984)
at weblogic.socket.SocketMuxer.readReadySocket(SocketMuxer.java:919)
at weblogic.socket.JavaSocketMuxer.processSockets(JavaSocketMuxer.java:385)
at weblogic.socket.SocketReaderRequest.run(SocketReaderRequest.java:30)
at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:147)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:119)


Steps to reproduce:

1. All the purge batches are triggered in parallel.
2. When PurgeDSDAndPurchaseOrders batch is run failing with error.

Cause

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