weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications.. Error Code: 0 Call: SQLCall(UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?) Query: DataModifyQuery()

Oracle Community | 947629 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Getting error selected operation process could not be invoked while testing?

    Oracle Community | 3 years ago | 947629
    weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications.. Error Code: 0 Call: SQLCall(UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?) Query: DataModifyQuery()

    Root Cause Analysis

    1. weblogic.jdbc.extensions.PoolDisabledSQLException

      weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications.. Error Code: 0 Call: SQLCall(UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?) Query: DataModifyQuery()

      at oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation()
    2. oracle.sysman.emas
      WSView.invokeOperation
      1. oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:575)
      2. oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:381)
      3. oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:298)
      3 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. EL
      MethodExpressionImpl.invoke
      1. com.sun.el.parser.AstValue.invoke(AstValue.java:157)
      2. com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:283)
      2 frames
    5. org.apache.myfaces
      MethodExpressionMethodBinding.invoke
      1. org.apache.myfaces.trinidadinternal.taglib.util.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:53)
      1 frame
    6. Apache MyFaces Trinidad API
      UIXCommand.broadcast
      1. org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodBinding(UIXComponentBase.java:1259)
      2. org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:183)
      2 frames
    7. oracle.adf.view
      UIXInclude.broadcast
      1. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:90)
      2. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:309)
      3. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:94)
      4. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:97)
      5. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:90)
      6. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:309)
      7. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:94)
      8. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:91)
      8 frames
    8. JavaEE 7
      UIViewRoot.processApplication
      1. javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:475)
      2. javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:756)
      2 frames
    9. oracle.adfinternal.view
      LifecycleImpl.execute
      1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:698)
      2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:285)
      3. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:177)
      3 frames
    10. JavaEE 7
      FacesServlet.service
      1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
      1 frame
    11. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      5 frames
    12. oracle.adfinternal.view
      RegistrationFilter.doFilter
      1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:97)
      1 frame
    13. org.apache.myfaces
      TrinidadFilterImpl$FilterListChain.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
      1 frame
    14. oracle.adfinternal.view
      AdsFilter.doFilter
      1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
      1 frame
    15. org.apache.myfaces
      TrinidadFilterImpl.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:420)
      2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:247)
      3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:157)
      3 frames
    16. Apache MyFaces Trinidad API
      TrinidadFilter.doFilter
      1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
      1 frame
    17. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    18. oracle.help.web
      OHWFilter.doFilter
      1. oracle.help.web.rich.OHWFilter.doFilter(Unknown Source)
      1 frame
    19. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    20. oracle.sysman.emSDK
      LicenseFilter.doFilter
      1. oracle.sysman.emSDK.license.LicenseFilter.doFilter(LicenseFilter.java:101)
      1 frame
    21. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    22. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:191)
      1 frame
    23. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    24. oracle.sysman.emas
      MASConnectionFilter.doFilter
      1. oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:41)
      1 frame
    25. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    26. oracle.adf.library
      LibraryFilter.doFilter
      1. oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:159)
      1 frame
    27. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    28. oracle.sysman.eml
      AuditServletFilter.doFilter
      1. oracle.sysman.eml.app.AuditServletFilter.doFilter(AuditServletFilter.java:179)
      1 frame
    29. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    30. oracle.sysman.eml
      EMRepLoginFilter.doFilter
      1. oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:203)
      1 frame
    31. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    32. oracle.sysman.core
      PerfFilter.doFilter
      1. oracle.sysman.core.app.perf.PerfFilter.doFilter(PerfFilter.java:141)
      1 frame
    33. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    34. oracle.sysman.eml
      ContextInitFilter.doFilter
      1. oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:542)
      1 frame
    35. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      1 frame
    36. oracle.dms.wls
      DMSServletFilter.doFilter
      1. oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)
      1 frame
    37. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
      5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
      5 frames
    38. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    39. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
      1 frame
    40. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
      3 frames
    41. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      2 frames