Hello,
APPLIES TO:
Oracle SOA Suite - Version 12.2.1.3.0
Customer is having issue in processing payloads over 12 Mb.
Flow is : Trading Partner sends a document over AS2 and B2B receives the payload and sends it to a custom AQ queue.
SOA Composite picks and process the payload from custom AQ queue.
Whenever a payload over 10 Mb is received with large payload size set to 2Mb, following exception occurs in JDBC layer.
There are no wire or business messages created.
----
Internal Exception: java.sql.SQLRecoverableException: IO Error: Broken pipe
Error Code: 17002
Call: SELECT CLOB_VALUE FROM B2B_DATA_STORAGE WHERE (ID = ?) FOR UPDATE
bind => [1 parameter bound]
Query: InsertObjectQuery(oracle.tip.b2b.model.instance.DataStorage@5cae52f9)>
<Oct 10, 2019 12:16:27,875 PM WEST> <Warning> <JDBC> <BEA-001594> <Forcibly releasing an already closed connection "[weblogic.jdbc.wrapper.JTAConnection_weblogic_jdbc_wrapper_XAConnection_oracle_jdbc_driver_LogicalConnection-SOADataSource-1428166, null]" back into the data source connection pool "null".>
<Oct 10, 2019 12:16:28,882 PM WEST> <Error> <oracle.soa.b2b.engine> <BEA-000000> <weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@53a4faa5