XAException
vij7 Mar 15, 2006 9:22 AMHi all,
Im getting a strange error on one of my machines, I doesnt always seem to be happening and seems random. The database is sqlserver2000, with opta2000 inet jdbc driver on jboss 3.2.3.
Has anyone seen this before or recognise what it could be? It seems to be losing or not recognising a transaction.
Thanks
Vijay
abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) enabling audit trail methods for trade audit report...
2006-03-01 13:18:49,803 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh
2006-03-01 13:18:49,803 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Checking driver for URL: jdbc:inetdae7:SQLXXX
2006-03-01 13:18:49,813 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Driver already registered for url: jdbc:inetdae7:SQLXXX
2006-03-01 13:18:49,853 DEBUG [com.abc.f3.security.SQLLoginModule] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) checkforlockout: guest 0/-1/true
2006-03-01 13:18:49,853 DEBUG [com.abc.f3.security.SQLLoginModule] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) password expiry: pwdbirth=2005-08-30/1125374400000 maxage=-1 now=1141237129853
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Created new instance for tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TxManager] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) began tx: TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Committing, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=], status=STATUS_ACTIVE
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Before completion done, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=], status=STATUS_ACTIVE
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Zero phase commit: No resources.
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Committed OK, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TxManager] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) suspended tx: TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//1, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) Created new instance for tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TxManager] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) began tx: TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=]
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) enlistResource(): Entered, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=] status=STATUS_ACTIVE
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) startResource(XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=1]) entered: org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@c4aa05 flags=0
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) startResource(XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=1]) leaving: org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@c4aa05 flags=0
2006-03-01 13:18:49,883 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) registerSynchronization(): Entered, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=] status=STATUS_ACTIVE
2006-03-01 13:18:49,913 TRACE [org.jboss.tm.TxManager] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) suspended tx: TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=]
2006-03-01 13:18:49,913 TRACE [org.jboss.tm.TxManager] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) resumed tx: TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=]
2006-03-01 13:18:49,913 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) enlistResource(): Entered, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=] status=STATUS_ACTIVE
2006-03-01 13:18:49,913 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) startResource(XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=2]) entered: org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@15b1bc2 flags=0
2006-03-01 13:18:49,933 TRACE [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) startResource(XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=2]) leaving: org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@15b1bc2 flags=0
2006-03-01 13:18:49,933 WARN [org.jboss.tm.TransactionImpl] (main:jboss.scripts:type=BeanShell,url=file%3a/C%3a/abc/jboss/server/default/tmp/deploy/tmp1341reports_tradingaudit.jar-contents/META-INF/reports_tradingaudit.jar-startup.bsh BeanShellScript) XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=NY-LRM-PC-420//3, BranchQual=] errorCode=XA_UNKNOWN(0)
javax.transaction.xa.XAException: [SQLRISK]Cannot enlist in the transaction because the transaction does not exist.
at com.inet.tds.o.if(Unknown Source)
at com.inet.tds.o.start(Unknown Source)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:143)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1148)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:636)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:455)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:149)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:111)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:49)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:571)
at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:299)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:300)
at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:637)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
at com.abc.f3.audit.AuditTrailInterceptor.invokeHome(AuditTrailInterceptor.java:116)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
at com.abc.f3.accesscontrol.JBossEJBInterceptor.invokeHome(JBossEJBInterceptor.java:115)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
at org.jboss.ejb.Container.invoke(Container.java:720)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
at $Proxy61.findByModuleBeanAndMethodName(Unknown Source)
at com.abc.f3.audit.AuditTrailServiceBean.enableMethod(AuditTrailServiceBean.java:100)