1 Reply Latest reply on Jun 16, 2008 8:41 AM by 666705

    OutOfMemory Exception

    666705
      Sorry Guys as i am new to this forum, i need help here from application prospectus, The server went out of allocated 60 connections, trying to make more connections....Help from some one is really appreciated
      ExecuteThread: '109' for queue: 'weblogic.kernel.Default (self-tuning)'> <ca_messenger01> <> <> <1208960237193> <BEA-010051> <EJB Exception occurred during invocation from home: com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_HomeImpl@4669946 threw exception: javax.ejb.EJBException: Unable to get database connection. SQL Vendor code = 0. SQL Error message = weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PM_DB to allocate to applications, please increase the size of the pool and retry... SQL State = null; nested exception is: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PM_DB to allocate to applications, please increase the size of the pool and retry..

      javax.ejb.EJBException: Unable to get database connection. SQL Vendor code = 0. SQL Error message = weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PM_DB to allocate to applications, please increase the size of the pool and retry... SQL State = null; nested exception is: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool PM_DB to allocate to applications, please increase the size of the pool and retry..

      at com.choicehotels.util.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:49)

      at com.choicehotels.pms.dbinterface.DatabaseDAO.getDataSourceConnection(DatabaseDAO.java:251)

      at com.choicehotels.pms.dbinterface.DatabaseDAO.createCallableStatement(DatabaseDAO.java:80)

      at com.choicehotels.pms.data.mssql.MSSQLPropertyInformationDAO.getPMPropertySynchronizationStatus(MSSQLPropertyInformationDAO.java:1245)

      at com.choicehotels.ejb.CentralInterfaceEJB.getPMPropertySynchronizationStatus(CentralInterfaceEJB.java:773)

      at com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_EOImpl.getPMPropertySynchronizationStatus(CentralInterfaceEJB_peb3j4_EOImpl.java:217)

      at com.choicehotels.pms.exif.centralclient.PMGetPropertySynchStatusHandler.processMessageImpl(PMGetPropertySynchStatusHandler.java:67)

      at com.choicehotels.pms.exif.centralclient.CentralClientHandler.processMessage(CentralClientHandler.java:98)

      at com.choicehotels.pms.exif.centralclient.servlet.JCRSMessageServlet.doPost(JCRSMessageServlet.java:234)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)

      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3395)

      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

      at weblogic.security.service.SecurityManager.runAs(Unknown Source)

      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)

      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)

      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)

      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)

      at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)

      The Out of memory exception as well:-
      java.lang.OutOfMemoryError: nativeGetNewTLA
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperDatabase.getRoleKey(AdvantageRoleMapperDatabase.java:447)
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperDatabase.getRoleKey(AdvantageRoleMapperDatabase.java:434)
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperDatabase.getPrincipalsForRole(AdvantageRoleMapperDatabase.java:281)
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperProviderImpl.roleMatches(AdvantageRoleMapperProviderImpl.java:367)
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperProviderImpl.getRoles(AdvantageRoleMapperProviderImpl.java:341)
      at com.choicehotels.security.providers.roles.AdvantageRoleMapperProviderImpl.getRoles(AdvantageRoleMapperProviderImpl.java:167)
      at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
      at $Proxy34.getRoles(Unknown Source)
      at com.bea.common.security.internal.service.RoleMappingServiceImpl.getRoles(RoleMappingServiceImpl.java:101)
      at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
      at $Proxy35.getRoles(Unknown Source)
      at weblogic.security.service.RoleManager.getRoles(Unknown Source)
      at weblogic.security.service.AuthorizationManager.isAccessAllowed(Unknown Source)
      at weblogic.ejb.container.internal.SecurityHelperWLS.isAccessAllowed(SecurityHelperWLS.java:423)
      at weblogic.ejb.container.internal.SecurityHelper.isAccessAllowed(SecurityHelper.java:411)
      at weblogic.ejb.container.internal.SecurityHelper.isAccessAllowed(SecurityHelper.java:401)
      at weblogic.ejb.container.internal.MethodDescriptor.checkAccess(MethodDescriptor.java:640)
      at weblogic.ejb.container.internal.MethodDescriptor.checkMethodPermissions(MethodDescriptor.java:609)
      at weblogic.ejb.container.internal.MethodDescriptor.checkMethodPermissionsRemote(MethodDescriptor.java:556)
      at weblogic.ejb.container.internal.BaseRemoteObject.checkMethodPermissions(BaseRemoteObject.java:118)
      at weblogic.ejb.container.internal.BaseRemoteObject.preInvoke(BaseRemoteObject.java:272)
      at weblogic.ejb.container.internal.StatelessRemoteObject.preInvoke(StatelessRemoteObject.java:49)
      at com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_EOImpl.synchPMReservation(CentralInterfaceEJB_peb3j4_EOImpl.java:559)
      at com.choicehotels.pms.exif.centralclient.PMSynchReservationHandler.processMessageImpl(PMSynchReservationHandler.java:67)
      at com.choicehotels.pms.exif.centralclient.CentralClientHandler.processMessage(CentralClientHandler.java:98)
      at com.choicehotels.pms.exif.centralclient.servlet.JCRSMessageServlet.doPost(JCRSMessageServlet.java:234)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3395)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(Unknown Source)
        • 1. Re: OutOfMemory Exception
          666705
          Sorry Guys as i am new to this forum, i need help
          here from application prospectus, The server went out
          of allocated 60 connections, trying to make more
          connections....Help from some one is really
          appreciated
          ExecuteThread: '109' for queue:
          'weblogic.kernel.Default (self-tuning)'>
          <ca_messenger01> <> <> <1208960237193> <BEA-010051>
          <EJB Exception occurred during invocation from home:
          com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_HomeIm
          pl@4669946 threw exception: javax.ejb.EJBException:
          Unable to get database connection. SQL Vendor code =
          0. SQL Error message =
          weblogic.common.resourcepool.ResourceLimitException:
          No resources currently available in pool PM_DB to
          allocate to applications, please increase the size of
          the pool and retry... SQL State = null; nested
          exception is:
          weblogic.jdbc.extensions.PoolLimitSQLException:
          weblogic.common.resourcepool.ResourceLimitException:
          No resources currently available in pool PM_DB to
          allocate to applications, please increase the size of
          the pool and retry..

          javax.ejb.EJBException: Unable to get database
          connection. SQL Vendor code = 0. SQL Error message =
          weblogic.common.resourcepool.ResourceLimitException:
          No resources currently available in pool PM_DB to
          allocate to applications, please increase the size of
          the pool and retry... SQL State = null; nested
          exception is:
          weblogic.jdbc.extensions.PoolLimitSQLException:
          weblogic.common.resourcepool.ResourceLimitException:
          No resources currently available in pool PM_DB to
          allocate to applications, please increase the size of
          the pool and retry..

          at
          at
          at
          at
          com.choicehotels.util.ConnectionManagerImpl.getConnect
          ion(ConnectionManagerImpl.java:49)

          at
          at
          at
          at
          com.choicehotels.pms.dbinterface.DatabaseDAO.getDataSo
          urceConnection(DatabaseDAO.java:251)

          at
          at
          at
          at
          com.choicehotels.pms.dbinterface.DatabaseDAO.createCal
          lableStatement(DatabaseDAO.java:80)

          at
          at
          at
          at
          com.choicehotels.pms.data.mssql.MSSQLPropertyInformati
          onDAO.getPMPropertySynchronizationStatus(MSSQLProperty
          InformationDAO.java:1245)

          at
          at
          at
          at
          com.choicehotels.ejb.CentralInterfaceEJB.getPMProperty
          SynchronizationStatus(CentralInterfaceEJB.java:773)

          at
          at
          at
          at
          com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_EOImpl
          .getPMPropertySynchronizationStatus(CentralInterfaceEJ
          B_peb3j4_EOImpl.java:217)

          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.PMGetPropertyS
          ynchStatusHandler.processMessageImpl(PMGetPropertySync
          hStatusHandler.java:67)

          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.CentralClientH
          andler.processMessage(CentralClientHandler.java:98)

          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.servlet.JCRSMe
          ssageServlet.doPost(JCRSMessageServlet.java:234)

          at
          at
          at
          at
          javax.servlet.http.HttpServlet.service(HttpServlet.jav
          a:727)

          at
          at
          at
          at
          javax.servlet.http.HttpServlet.service(HttpServlet.jav
          a:820)

          at
          at
          at
          at
          weblogic.servlet.internal.StubSecurityHelper$ServletSe
          rviceAction.run(StubSecurityHelper.java:226)

          at
          at
          at
          at
          weblogic.servlet.internal.StubSecurityHelper.invokeSer
          vlet(StubSecurityHelper.java:124)

          at
          at
          at
          at
          weblogic.servlet.internal.ServletStubImpl.execute(Serv
          letStubImpl.java:283)

          at
          at
          at
          at
          weblogic.servlet.internal.ServletStubImpl.execute(Serv
          letStubImpl.java:175)

          at
          at
          at
          at
          weblogic.servlet.internal.WebAppServletContext$Servlet
          InvocationAction.run(WebAppServletContext.java:3395)

          at
          at
          at
          at
          weblogic.security.acl.internal.AuthenticatedSubject.do
          As(AuthenticatedSubject.java:321)

          at
          at
          at
          at
          weblogic.security.service.SecurityManager.runAs(Unknow
          n Source)

          at
          at
          at
          at
          weblogic.servlet.internal.WebAppServletContext.secured
          Execute(WebAppServletContext.java:2140)

          at
          at
          at
          at
          weblogic.servlet.internal.WebAppServletContext.execute
          (WebAppServletContext.java:2046)

          at
          at
          at
          at
          weblogic.servlet.internal.ServletRequestImpl.run(Servl
          etRequestImpl.java:1366)

          at
          at
          at
          at
          weblogic.work.ExecuteThread.execute(ExecuteThread.java
          :200)

          at
          at
          at
          at
          weblogic.work.ExecuteThread.run(ExecuteThread.java:172
          )

          The Out of memory exception as well:-
          java.lang.OutOfMemoryError: nativeGetNewTLA
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperDatabase.getRoleKey(AdvantageRoleMapperDatabase
          .java:447)
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperDatabase.getRoleKey(AdvantageRoleMapperDatabase
          .java:434)
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperDatabase.getPrincipalsForRole(AdvantageRoleMapp
          erDatabase.java:281)
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperProviderImpl.roleMatches(AdvantageRoleMapperPro
          viderImpl.java:367)
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperProviderImpl.getRoles(AdvantageRoleMapperProvid
          erImpl.java:341)
          at
          at
          at
          at
          com.choicehotels.security.providers.roles.AdvantageRol
          eMapperProviderImpl.getRoles(AdvantageRoleMapperProvid
          erImpl.java:167)
          at
          at
          at
          at
          sun.reflect.GeneratedMethodAccessor50.invoke(Unknown
          Source)
          at
          at
          at
          at
          sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega
          tingMethodAccessorImpl.java:25)
          at
          at
          at
          at java.lang.reflect.Method.invoke(Method.java:585)
          at
          at
          at
          at
          com.bea.common.security.internal.utils.Delegator$Proxy
          InvocationHandler.invoke(Delegator.java:57)
          at $Proxy34.getRoles(Unknown Source)
          at
          at
          at
          at
          com.bea.common.security.internal.service.RoleMappingSe
          rviceImpl.getRoles(RoleMappingServiceImpl.java:101)
          at
          at
          at
          at
          sun.reflect.GeneratedMethodAccessor49.invoke(Unknown
          Source)
          at
          at
          at
          at
          sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega
          tingMethodAccessorImpl.java:25)
          at
          at
          at
          at java.lang.reflect.Method.invoke(Method.java:585)
          at
          at
          at
          at
          com.bea.common.security.internal.utils.Delegator$Proxy
          InvocationHandler.invoke(Delegator.java:57)
          at $Proxy35.getRoles(Unknown Source)
          at
          at
          at
          at
          weblogic.security.service.RoleManager.getRoles(Unknown
          Source)
          at
          at
          at
          at
          weblogic.security.service.AuthorizationManager.isAcces
          sAllowed(Unknown Source)
          at
          at
          at
          at
          weblogic.ejb.container.internal.SecurityHelperWLS.isAc
          cessAllowed(SecurityHelperWLS.java:423)
          at
          at
          at
          at
          weblogic.ejb.container.internal.SecurityHelper.isAcces
          sAllowed(SecurityHelper.java:411)
          at
          at
          at
          at
          weblogic.ejb.container.internal.SecurityHelper.isAcces
          sAllowed(SecurityHelper.java:401)
          at
          at
          at
          at
          weblogic.ejb.container.internal.MethodDescriptor.check
          Access(MethodDescriptor.java:640)
          at
          at
          at
          at
          weblogic.ejb.container.internal.MethodDescriptor.check
          MethodPermissions(MethodDescriptor.java:609)
          at
          at
          at
          at
          weblogic.ejb.container.internal.MethodDescriptor.check
          MethodPermissionsRemote(MethodDescriptor.java:556)
          at
          at
          at
          at
          weblogic.ejb.container.internal.BaseRemoteObject.check
          MethodPermissions(BaseRemoteObject.java:118)
          at
          at
          at
          at
          weblogic.ejb.container.internal.BaseRemoteObject.preIn
          voke(BaseRemoteObject.java:272)
          at
          at
          at
          at
          weblogic.ejb.container.internal.StatelessRemoteObject.
          preInvoke(StatelessRemoteObject.java:49)
          at
          at
          at
          at
          com.choicehotels.ejb.CentralInterfaceEJB_peb3j4_EOImpl
          .synchPMReservation(CentralInterfaceEJB_peb3j4_EOImpl.
          java:559)
          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.PMSynchReserva
          tionHandler.processMessageImpl(PMSynchReservationHandl
          er.java:67)
          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.CentralClientH
          andler.processMessage(CentralClientHandler.java:98)
          at
          at
          at
          at
          com.choicehotels.pms.exif.centralclient.servlet.JCRSMe
          ssageServlet.doPost(JCRSMessageServlet.java:234)
          at
          at
          at
          at
          javax.servlet.http.HttpServlet.service(HttpServlet.jav
          a:727)
          at
          at
          at
          at
          javax.servlet.http.HttpServlet.service(HttpServlet.jav
          a:820)
          at
          at
          at
          at
          weblogic.servlet.internal.StubSecurityHelper$ServletSe
          rviceAction.run(StubSecurityHelper.java:226)
          at
          at
          at
          at
          weblogic.servlet.internal.StubSecurityHelper.invokeSer
          vlet(StubSecurityHelper.java:124)
          at
          at
          at
          at
          weblogic.servlet.internal.ServletStubImpl.execute(Serv
          letStubImpl.java:283)
          at
          at
          at
          at
          weblogic.servlet.internal.ServletStubImpl.execute(Serv
          letStubImpl.java:175)
          at
          at
          at
          at
          weblogic.servlet.internal.WebAppServletContext$Servlet
          InvocationAction.run(WebAppServletContext.java:3395)
          at
          at
          at
          at
          weblogic.security.acl.internal.AuthenticatedSubject.do
          As(AuthenticatedSubject.java:321)
          at
          at
          at
          at
          weblogic.security.service.SecurityManager.runAs(Unknow
          n Source)
          Pls check the code and ensure that open connection is being released properly.