Large paylod oracle b2b — oracle-tech

    Forum Stats

  • 3,708,965 Users
  • 2,241,167 Discussions
  • 7,840,725 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Large paylod oracle b2b

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([email protected])>

<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[email protected]53a4faa5

Sign In or Register to comment.