5 Replies Latest reply on Mar 20, 2006 7:58 AM by vij hirani

    XAException

    vij hirani Newbie

      Hi 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)