WARN (Periodic Recovery) com.arjuna.ats.jta ARJUNA016027

Q&A
1

Hello everyone.

I have Bonita 2021.1 installed on Linux (CentOS), it uses a Postgres database but when I check the Bonita log I find SQLServer errors.

Below the error:


2021-11-29 15:32:44.619 -0300 WARN (Periodic Recovery) com.arjuna.ats.jta ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR
javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Error al crear la conexión de control XA. Error: "La conexión está cerrada.".
        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:738)
        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:822)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:659)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:240)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:182)
        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:770)
        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:382)

2021-11-29 15:32:44.620 -0300 WARN (Periodic Recovery) com.arjuna.ats.jta ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR
javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Error al crear la conexión de control XA. Error: "La conexión está cerrada.".
        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:738)
        at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:822)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:659)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:240)
        at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:182)
        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:770)
        at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:382)
 

Do you know how to solve it?

2

Hi, 

I wrote a blog post about this famous error, you can try implement the solutions suggested here: https://community.bonitasoft.com/blog/how-get-rid-warning-warn-periodic-recovery-comarjunaatsjta-arjuna016027

Hopefully it'll help you!