Subscriber Does Not Recover from XA Error (Doc ID 794044.1)

Last updated on JUNE 02, 2016

Applies to:

Oracle Retail Integration Bus - Version 11.1 to 12.0.9 [Release 11 to 12.0]
Information in this document applies to any platform.

Symptoms

ewASNOutToRMS subscriber eWay encountered the XA error noted. Seebeyond logs show adapter going through a disconnect/connect sequence to the database.

Review of SeeBeyond log shows that after the reconnection, all messages fail with a

java.SQL.Exception, "cannot construct ARRAY instance, invalid connection" at
com.retek.rib.collab.XMLToOracleObjectParser.endElement(XMLToOracleObjectParser.java:197).



Review of RIBLOGS log shows that in spite of the fact that the normal message processing logic
believes it has an invalid connection, the message is successfully inserted (or updated) in the
Error Hospital.

That might lead someone to believe the normal message processing logic is using a stale connection
- the one that was disconnected after the XA error, not the one created when the subscriber
reconnected.

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