How to resolve error:
[com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
Local XARecoveryModule.xaRecovery - caught exception: java.lang.NullPointerException
How does this error happen and how to prevent this?
This error happens when bad data is passed. For example, a SQL server goes down and transactions was being made at that time. Another time this happens is when a cluster of the primary goes down but there are running transactions. A common solution would be to recycle the Jboss server. Recommendation to prevent this is to make sure the CA Identity Governance machine is shutdown to prevent any interference with the application if any patching or distrubance is happening with the SQL Server.