SOA: XAResource.XAER_RMFAIL start() failed on resource

If you see the Following Exception in the WebLogic log:

XAResource.XAER_RMFAIL start () failed on resource 'XXX_XXX_osb_domain': XAER_RMFAIL: Resource manager is unavailable javax.transaction.xa.XAException: Internal error: XAResource 'GARD_NET3PROD_osb_domain' is unavailable

Solutions:

Set XA Transaction Timeout to a higher value and enable XA Transaction timeout on the Specified data source.

or

Increase MaxXACallMillis   value on JTA Advanced settings on the WebLogic domain. Setting the Applies to the entire domain. (Default: 120000)

If a problem still persists please check the Following Oracle MetaLink note for database patch details:

XAER_RMERR rather than XAER_RMFAIL reported for a JDBC session When The instance HAS aborted.

SOA DB Merge operation is not updating records properly

DBAdapter - Merge operation issue in 11g

If you use the merge operation for updating records using DBAdapter, make sure DetectOmission property is set to false, as by default it's true. Or else values ​​coming as Null Will not Get udpated in database records - Causing updates buggy.

  Property name = "DetectOmissions" value = "false" /