java.sql.SQLException: ORA-14911: XA transactions are not supported by Transaction Guard

IT by javier mugueta

Oracle SOA 12.2.x over Oracle database 12.1 in standby DataGuard with Transaction Guard enabled.

It seems SOA Suite does not support transaction guard, hence you must ask your DBA to configure the service with this setting: COMMIT OUTCOME = FALSE

Enjoy 😉

Caused By: oracle.jdbc.xa.OracleXAException Caused By: java.sql.SQLException: ORA-14911: XA transactions are not supported by Transaction Guard.<oracle.soa.mediator.common> <BEA-000000> <Transaction rollback failed due to exception java.lang.IllegalStateException: Transaction does not exist <Error> <oracle.soa.mediator.dispatch.db> <BEA-000000> <Rollback of transaction failed in DBContainerIdManager.run() oracle.tip.mediator.infra.exception.MediatorException: ORAMED-03504:[Transaction Rollback]Unable to rollback transaction.Possible Fix:Check log file for any ceptions and contact Oracle Support Services for further help. Caused By: java.lang.IllegalStateException: Transaction does not exist

 

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.