RICS Adapters are Going Down with XA error: XAResource.XAER_PROTO start() failed on resource 'rib-xxx-xxx-managed-datasource_RIBDomain' (Doc ID 2861512.1)

Last updated on MARCH 11, 2024

Applies to:

Symptoms

Adapters are going down with the below error:

... java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_PROTO start() failed on resource 'rib-ext-hosp-managed-datasource_RIBDomain': XAER_PROTO : Routine was invoked in an improper context
javax.transaction.xa.XAException: Unexpected error during start for XAResource 'rib-ext-hosp-managed-datasource': XA error: oracle.jdbc.xa.OracleXAException: XAErr (-6): Routine was invoked in an inproper context. ORA-24776 SQLErr (0): OracleError = 24776; OracleSQLError = 0; XAError = -6: XAErr (-6): Routine was invoked in an inproper context. ORA-24776 SQLErr (0)

OR

Unexpected error during prepare for XAResource 'rib-rms-hosp-managed-datasource': XA error: oracle.jdbc.xa.OracleXAException: XAErr (-4): The XID is not valid. ORA-24756 SQLErr (0): OracleError = 24756; OracleSQLError = 0; XAError = -4: XAErr (-4): The XID is not valid. ORA-24756 SQLErr (0)
....
Caused by: javax.transaction.xa.XAException: Unexpected error during prepare for XAResource 'rib-rms-hosp-managed-datasource': XA error: oracle.jdbc.xa.OracleXAException: XAErr (-4): The XID is not valid. ORA-24756 SQLErr (0): OracleError = 24756; OracleSQLError = 0; XAError = -4: XAErr (-4): The XID is not valid. ORA-24756 SQLErr (0)
....
Caused by: oracle.jdbc.xa.OracleXAException: XAErr (-4): The XID is not valid. ORA-24756 SQLErr (0)
...
Caused by: java.sql.SQLException: ORA-24756: transaction does not exist

Cause