"java.sql.SQLException: IO exception: Broken pipe" Exception Intermittently in Allocations

(Doc ID 1449653.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Retail Allocation - Version 13 to 13.2 [Release 13.0 to 13.2]
Information in this document applies to any platform.

Goal

Why are Allocations stuck in 'Calculation Waiting' status, with the calculation queue log showing the following exception:

2011-06-08 09:25:55,892 ERROR java.lang.String (?:?) -
java.sql.SQLException: Io exception: Broken pipe
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:578)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1189)
at oracle.jdbc.OracleConnectionWrapper.rollback(OracleConnectionWrapper.java:122)
at com.retek.alloc.service.QueueProcessService.findAndRemoveNextQueueEntry(QueueProcessService.java:104)
at com.retek.alloc.queue.QueueProcess.run(QueueProcess.java:56)
at java.lang.Thread.run(Thread.java:810)

Solution

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