2 Replies Latest reply: Jul 21, 2014 9:48 AM by pawel RSS

    Weblogic 8.1 - java.sql.SQLException: Resource manager is unavailable

    pawel

      Hi,
      Last time we've errors like this at production mode: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAER_RMFAIL : Resource manager is unavailable start() failed on resource 'PICPool': XAER_RMFAIL : Resource manager is unavailable at few managed servers. Probably we didn't change sth important but i'm not sure.
      My CP PICPool driver type:  oracle.jdbc.xa.client.OracleXADataSource and i've checked option: Supports Local Transaction
      And my datasource doesn't has checked option: Emulate Two-Phase Commit for non-XA
      Driver Driver file: ojdbc14.jar (1322KB, 2006-11-08 date), we used oracle database 9 but migrated over 6 months to oracle 11 - but we didn't have any problems during few months.

       

      Could you help ? regards

        • 1. Re: Weblogic 8.1 - java.sql.SQLException: Resource manager is unavailable
          Luz Mestre-Oracle

          1. Could  you please confirm the exact WLS version? (e.g: 8.1 SP6 )

          2. Post the complete error for us to better  understand the issue.

          3. Does this occur during high load?

          Best Regards

          Luz

          • 2. Re: Weblogic 8.1 - java.sql.SQLException: Resource manager is unavailable
            pawel

            1. At file: startManagedWebLogic.sh i have set: JAVA_HOME="/bea/bea814/jrockit81sp6_142_10"

             

            2. Example error:

             

            java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAER_RMFAIL : Resource manager is unavailable start() failed on resource 'PICPool': XAER_RMFAIL : Resource manager is unavailable javax.transaction.xa.XAException: Internal error: XAResource 'PICPool' is unregistered         at weblogic.transaction.internal.XAResourceDescriptor.checkResource(XAResourceDescriptor.java:1061)         at weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:614)         at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1139)         at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1072)         at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:240)         at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:463)         at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1392)         at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1334)         at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:432)         at weblogic.jdbc.jta.DataSource.connect(DataSource.java:354)         at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)         at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.getConnection(RDBMSPersistenceManager.java:2753)         at aliases.Aliases_1sk45s__WebLogic_CMP_RDBMS.ejbFindByCif(Aliases_1sk45s__WebLogic_CMP_RDBMS.java:444)         at jrockit.reflect.CompiledMethodInvoker.invoke0(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)         at jrockit.reflect.CompiledMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)         at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)         at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.collectionFinder(RDBMSPersistenceManager.java:385)         at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1784)         at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1756)         at weblogic.ejb20.internal.EntityEJBLocalHome.finder(EntityEJBLocalHome.java:547)         at aliases.Aliases_1sk45s_LocalHomeImpl.findByCif(Aliases_1sk45s_LocalHomeImpl.java:132)         at aliases.AliasesSessionFacadeBean.aliasesFindByCif(AliasesSessionFacadeBean.java:149)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl.aliasesFindByCif(AliasesSessionFacade_ybwbnw_EOImpl.java:46)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl_CBV.aliasesFindByCif(Ljava.lang.String;)[Laliases.AliasesDto;(Unknown Source)         at aliases.AliasesDelegate.aliasesFindByCif(AliasesDelegate.java:32)         at bphpbk.pi.piservice.PIServiceBean.executeService(PIServiceBean.java:2287)         at bphpbk.pi.piservice.PIServiceBean.PIService_aroundBody4(PIServiceBean.java:732)         at bphpbk.pi.piservice.PIServiceBean$AjcClosure5.run(PIServiceBean.java:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7cproceed(InvocationInterceptor.aj:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7c(InvocationInterceptor.aj:79)         at bphpbk.pi.piservice.PIServiceBean.PIService(PIServiceBean.java:599)         at bphpbk.pi.piservice.PIService_px3dm8_EOImpl.PIService(PIService_px3dm8_EOImpl.java:46)         at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1397)         at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1334)         at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:432)         at weblogic.jdbc.jta.DataSource.connect(DataSource.java:354)         at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)         at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.getConnection(RDBMSPersistenceManager.java:2753)         at aliases.Aliases_1sk45s__WebLogic_CMP_RDBMS.ejbFindByCif(Aliases_1sk45s__WebLogic_CMP_RDBMS.java:444)         at jrockit.reflect.CompiledMethodInvoker.invoke0(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)         at jrockit.reflect.CompiledMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)         at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Unknown Source)         at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.collectionFinder(RDBMSPersistenceManager.java:385)         at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1784)         at weblogic.ejb20.manager.BaseEntityManager.collectionFinder(BaseEntityManager.java:1756)         at weblogic.ejb20.internal.EntityEJBLocalHome.finder(EntityEJBLocalHome.java:547)         at aliases.Aliases_1sk45s_LocalHomeImpl.findByCif(Aliases_1sk45s_LocalHomeImpl.java:132)         at aliases.AliasesSessionFacadeBean.aliasesFindByCif(AliasesSessionFacadeBean.java:149)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl.aliasesFindByCif(AliasesSessionFacade_ybwbnw_EOImpl.java:46)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl_CBV.aliasesFindByCif(Ljava.lang.String;)[Laliases.AliasesDto;(Unknown Source)         at aliases.AliasesDelegate.aliasesFindByCif(AliasesDelegate.java:32)         at bphpbk.pi.piservice.PIServiceBean.executeService(PIServiceBean.java:2287)         at bphpbk.pi.piservice.PIServiceBean.PIService_aroundBody4(PIServiceBean.java:732)         at bphpbk.pi.piservice.PIServiceBean$AjcClosure5.run(PIServiceBean.java:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7cproceed(InvocationInterceptor.aj:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7c(InvocationInterceptor.aj:79)

             

            or simillar:

             

            nested exception is: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAER_RMFAIL : Resource manager is unavailable start() failed on resource 'PICPool': XAER_RMFAIL : Resource manager is unavailable javax.transaction.xa.XAException: Internal error: XAResource 'PICPool' is unregistered         at weblogic.transaction.internal.XAResourceDescriptor.checkResource(XAResourceDescriptor.java:1061)         at weblogic.transaction.internal.XAResourceDescriptor.startResourceUse(XAResourceDescriptor.java:614)         at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1139)         at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1072)         at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:240)         at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:463)         at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1392)         at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1334)         at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:432)         at weblogic.jdbc.jta.DataSource.connect(DataSource.java:354)         at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:305)         at weblogic.ejb20.cmp.rdbms.RDBMSPersistenceManager.getConnection(RDBMSPersistenceManager.java:2753)         at aliases.Aliases_1sk45s__WebLogic_CMP_RDBMS.__WL_loadGroup0(Aliases_1sk45s__WebLogic_CMP_RDBMS.java:712)         at aliases.Aliases_1sk45s__WebLogic_CMP_RDBMS.getCif(Aliases_1sk45s__WebLogic_CMP_RDBMS.java:320)         at aliases.Aliases_1sk45s_ELOImpl.getCif(Aliases_1sk45s_ELOImpl.java:155)         at aliases.AliasesDtoAssembler.createDto(AliasesDtoAssembler.java:14)         at aliases.AliasesSessionFacadeBean.assembleAliasesDto(AliasesSessionFacadeBean.java:131)         at aliases.AliasesSessionFacadeBean.assembleAliasesDtos(AliasesSessionFacadeBean.java:140)         at aliases.AliasesSessionFacadeBean.aliasesFindByCif(AliasesSessionFacadeBean.java:152)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl.aliasesFindByCif(AliasesSessionFacade_ybwbnw_EOImpl.java:46)         at aliases.AliasesSessionFacade_ybwbnw_EOImpl_CBV.aliasesFindByCif(Ljava.lang.String;)[Laliases.AliasesDto;(Unknown Source)         at aliases.AliasesDelegate.aliasesFindByCif(AliasesDelegate.java:32)         at bphpbk.pi.piservice.PIServiceBean.executeService(PIServiceBean.java:2287)         at bphpbk.pi.piservice.PIServiceBean.PIService_aroundBody4(PIServiceBean.java:732)         at bphpbk.pi.piservice.PIServiceBean$AjcClosure5.run(PIServiceBean.java:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7cproceed(InvocationInterceptor.aj:1)         at com.ericpol.ejbim.aspect.InvocationInterceptor.ajc$around$com_ericpol_ejbim_aspect_InvocationInterceptor$1$649afe7c(InvocationInterceptor.aj:79)         at bphpbk.pi.piservice.PIServiceBean.PIService(PIServiceBean.java:599)         at bphpbk.pi.piservice.PIService_px3dm8_EOImpl.PIService(PIService_px3dm8_EOImpl.java:46)         at bphpbk.pi.piservice.PIService_px3dm8_EOImpl_WLSkel.invoke(ILweblogic.rmi.spi.InboundRequest;Lweblogic.rmi.spi.OutboundResponse;Ljava.lang.Object;)Lweblogic.rmi.spi.OutboundResponse;(Unknown Source)         at weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:90)         at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:420)         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)         at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:415)         at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:27)         at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)         at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)

             

            3. I'm not sure, probably no becouse above second error is from last saturday (no high load)

             

            regards