B2B is not processing payload over 20 Mb : java.sql.SQLRecoverableException: IO Error: Connection reset by peer (Doc ID 2387567.1)

Last updated on AUGUST 16, 2024

Applies to:

Symptoms

Customer is having issue in processing payloads over 20 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 20 Mb is received with large payload size set to 2Mb, following exception occurs in JDBC layer.

There are no wire or business messages created.

2018-04-16T10:23:34.334-04:00] [b2b_zlp37195_12105] [ERROR] [] [oracle.soa.b2b.engine] [tid: [ACTIVE].ExecuteThread: '41' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ECID>,0:1] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] weblogic.transaction.RollbackException: Unexpected exception in beforeCompletion: sync=org.eclipse.persistence.transaction.JTASynchronizationListener@4c3fd3a[[

Internal Exception: java.sql.SQLRecoverableException: IO Error: Connection reset by peer
Error Code: 17002
Call: SELECT BLOB_VALUE FROM B2B_DATA_STORAGE WHERE (ID = ?) FOR UPDATE
bind => [1 parameter bound]
Query: InsertObjectQuery(oracle.tip.b2b.model.instance.DataStorage@4eb7590f)
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(TransactionImpl.java:2104)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:376)

Cause

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