You are currently reviewing an older revision of this page.
During JBoss startup, the following warning is shown (after startup this warning will be shown intermittently):
21:39:25,801 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_recover'. at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:647) at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:728) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:362) at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.recover(XAResourceWrapperImpl.java:185) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:541) [jbossjts-jacorb-4.17.29.Final-redhat-1.jar:4.17.29.Final-redhat-1] at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:181) [jbossjts-jacorb-4.17.29.Final-redhat-1.jar:4.17.29.Final-redhat-1] at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:747) [jbossjts-jacorb-4.17.29.Final-redhat-1.jar:4.17.29.Final-redhat-1] at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:375) [jbossjts-jacorb-4.17.29.Final-redhat-1.jar:4.17.29.Final-redhat-1]
This warning arises because Microsoft SQL Server is configured as an XA data source in appian-ds.xml, but SQL Server does not come configured for XA transactions by default.
For more information, refer to Redhat's tech note (XAER_RMERR during XA transaction recovery for Oracle database in JBoss EAP) on the issue.
This warning does not prevent Appian from working with SQL Server. If desired, follow the below steps to configure SQL Server for XA transactions.
sqljdbc_4.0\enu\xa
<Microsoft JDBC Driver 4.0 for SQL Server>\sqljdbc_4.0\enu\xa\x64
<Microsoft JDBC Driver 4.0 for SQL Server download>\sqljdbc_4.0\enu\xa\x86
<SQL_SERVER_2008_HOME>\Tools\Binn
<SQL_SERVER_2008_HOME>\LocalDB\Binn
<Microsoft JDBC Driver 4.0 for SQL Server download>\sqljdbc_4.0\enu\xa
In some instances, the following warning message will be displayed:
WARN [loggerI18N] [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery got XA exception javax.transaction.xa.XAException: The function RECfailed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***", XAException.XAER_RMERR
To correct this, perform the following:
Note: These steps have been tested in Microsoft SQL Server 2008. For detailed instructions for other versions, please consult Microsoft's documentation.
As an alternative to configuring SQL Server for XA transactions, follow these steps to hide the warning message instead:
<logger category="com.arjuna">
level
WARN
ERROR
This article applies to all versions of Appian.
Last Reviewed: February 2017