DB Adapter Fails while Reading Large Data

(Doc ID 1393650.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Symptoms

DB Adapter sometimes fails while loading large data.
In the logs you can notice the following error:

['java.sql.SQLException:
Unexpected exception while enlisting XAConnection java.sql.SQLException:
XA error: XAER_NOTA : The XID is not valid start() failed on resource '[connection pool]':
XAER_NOTA :
The XID is not valid oracle.jdbc.xa.OracleXAException']

Cause

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