SQL Server error "XAER_PROTO: Function invoked in an impropercontext." in EAP 6
Issue
- Randomly encountering
IJ000305
,XAER_RMERR
andXAER_PROTO
failures when starting a transaction against SQL Server
23:37:29,646 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (http-/0.0.0.0:8080-6) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@296e06bf[state=NORMAL ...XAManagedConnection@18a226f ...PoolBySubject@45208c78 ...SemaphoreArrayListManagedConnectionPool@7d3dc6f[pool=jdbc.ddp] xaResource=XAResourceWrapperImpl@59c9e0da[... overrideRmValue=false productName=Microsoft SQL Server productVersion=11.00.5582 jndiName=java:jboss/jdbc/SQLSDS] txSync=null]: javax.transaction.xa.XAException: XAER_RMERR: A resource manager error occurred in the transaction branch.
...
23:37:29,656 WARN [com.arjuna.ats.jta] (http-/0.0.0.0:8080-6) ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_PROTO for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff0a061020:5d216307:561594a7:674d, node_name=1, branch_uid=0:ffff0a061020:5d216307:561594a7:6753, subordinatenodename=null, eis_name=java:jboss/jdbc/SQLSDS >: javax.transaction.xa.XAException: XAER_PROTO: Function invoked in an impropercontext.
at net.sourceforge.jtds.jdbc.XASupport.raiseXAException(XASupport.java:677) [jtds-1.2.5.jar:1.2.5]
at net.sourceforge.jtds.jdbc.XASupport.xa_start(XASupport.java:186) [jtds-1.2.5.jar:1.2.5]
at net.sourceforge.jtds.jdbcx.JtdsXAResource.start(JtdsXAResource.java:105) [jtds-1.2.5.jar:1.2.5]
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
...
Environment
- Red Hat JBoss Enterprise Application Platform (EAP) 6
- Microsoft SQL Server
- jTDS driver
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.