4 Replies Latest reply: Aug 7, 2013 6:32 AM by Ramdeepak RSS

    Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'Operational': XAER_RMERR : A resource manager error has occured in the transaction branch

    Ramdeepak

      Hi

       

      Am getting the following error :

       

      Having

      Weblogic version 10.3

      Driver :    <driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>

      Transaction Info :  <global-transactions-protocol>TwoPhaseCommit</global-transactions-protocol>

       

      The exception started from when the upgrade done on the Database, upgraded the Oracle DB version from 10g to 11g (11.2.0.3.0) no other change mage. Appreciate any help on this.

       

      Thanks in advance

       

      Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'Operational': XAER_RMERR : A resource manager error has occured in the transaction branch
      oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1101)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:237)
      at weblogic.jdbc.wrapper.VendorXAResource.start(VendorXAResource.java:50)
      at weblogic.jdbc.jta.DataSource.start(DataSource.java:695)
      at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1183)
      at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1116)
      at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:275)
      at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:511)
      at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:438)
      at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1406)
      at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1330)
      at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:425)
      at weblogic.jdbc.jta.DataSource.connect(DataSource.java:382)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
      at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
      at org.hibernate.loader.Loader.doQuery(Loader.java:801)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      at org.hibernate.loader.Loader.doList(Loader.java:2542)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      at org.hibernate.loader.Loader.list(Loader.java:2271)
      at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
      at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
      at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
      at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
      at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
      at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
      ........................................

      ........................................

      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:597)
      at org.springframework.remoting.rmi.RmiClientInterceptorUtils.invokeRemoteMethod(RmiClientInterceptorUtils.java:111)
      at org.springframework.ejb.access.SimpleRemoteSlsbInvokerInterceptor.doInvoke(SimpleRemoteSlsbInvokerInterceptor.java:99)
      at org.springframework.ejb.access.AbstractRemoteSlsbInvokerInterceptor.invokeInContext(AbstractRemoteSlsbInvokerInterceptor.java:141)
      at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:189)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy51.dispatchCommand(Unknown Source)

      ........................................ 

      ........................................

      at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

      at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1411)
      at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1330)
      at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:425)
      at weblogic.jdbc.jta.DataSource.connect(DataSource.java:382)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
      at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
      at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
      at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
      at org.hibernate.loader.Loader.doQuery(Loader.java:801)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      at org.hibernate.loader.Loader.doList(Loader.java:2542)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      at org.hibernate.loader.Loader.list(Loader.java:2271)
      at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
      at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
      at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
      at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
      at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
      at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
      ........................................ 

      ........................................

      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:597)
      at org.springframework.remoting.rmi.RmiClientInterceptorUtils.invokeRemoteMethod(RmiClientInterceptorUtils.java:111)
      at org.springframework.ejb.access.SimpleRemoteSlsbInvokerInterceptor.doInvoke(SimpleRemoteSlsbInvokerInterceptor.java:99)
      at org.springframework.ejb.access.AbstractRemoteSlsbInvokerInterceptor.invokeInContext(AbstractRemoteSlsbInvokerInterceptor.java:141)
      at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:189)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
      at $Proxy51.dispatchCommand(Unknown Source)
      at com.addval.command.client.CommandDispatcherHelper.dispatchCommand(CommandDispatcherHelper.java:155)
      at com.addval.uldmgr.impl.UldEventTaskHandler.lookupUnProcessedUldActivities(UldEventTaskHandler.java:300)
      at com.addval.uldmgr.impl.UldEventTaskHandler.execute(UldEventTaskHandler.java:78)
      at com.addval.uldmgr.impl.UldEventTaskScheduler.executeImpl(UldEventTaskScheduler.java:16)
      at com.addval.task.impl.BaseJob.executeInternal(BaseJob.java:42)
      at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)