1 Reply Latest reply: Jan 17, 2012 10:40 AM by 911525 RSS

    PoolConnection Lost Problem SQLServer BPM 11G

    911525
      The below error happens intermittently as a popup:

      weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_jdbc_SQLServerConnection
      java.lang.NullpointerException

      Every time I return to the screen or try to access it more than once that happens, it just loses the Pool.

      I've increased the maximum size of the pool to absurd numbers, increased the JTA timeout and not got a solution.

      Has anyone had this problem?

      I use ADF 11G, 11G BPM, SQLServer as a database.
        • 1. Re: PoolConnection Lost Problem SQLServer BPM 11G
          911525
          ERROR LOG:

          ]] Root cause of ServletException.
          javax.el.ELException: oracle.jbo.common.ampool.ApplicationPoolException: JBO-30003: O pool de aplicações exibirnumerodoprojetoui.AppModuleLocal falhou ao fazer o checkout de um módulo de aplicação devido à seguinte exceção:
               at javax.el.BeanELResolver.getValue(BeanELResolver.java:266)
               ...
               at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
               at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
               at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
               at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
               at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
               at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
               at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
               at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
               at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
          ...
          Caused By: oracle.jbo.common.ampool.ApplicationPoolException: JBO-30003: Application pool exibirnumerodoprojetoui.AppModuleLocal fails to check out an application module due to the following exception:
               at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2553)
               at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2343)
               at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3242)
               at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:572)
               at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:234)
               at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:505)
               at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:500)
               at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:516)
               at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:862)
               at oracle.adf.model.binding.DCDataControl.setErrorHandler(DCDataControl.java:483)
               at oracle.jbo.uicli.binding.JUApplication.setErrorHandler(JUApplication.java:261)
               at oracle.adf.model.BindingContext.put(BindingContext.java:1326)
               at oracle.adf.model.binding.DCDataControlReference.getDataControl(DCDataControlReference.java:174)
               at oracle.adf.model.BindingContext.instantiateDataControl(BindingContext.java:1045)
               at oracle.adf.model.dcframe.DataControlFrameImpl.doFindDataControl(DataControlFrameImpl.java:1565)
               at oracle.adf.model.dcframe.DataControlFrameImpl.internalFindDataControl(DataControlFrameImpl.java:1437)
               at oracle.adf.model.dcframe.DataControlFrameImpl.findDataControl(DataControlFrameImpl.java:1397)
               at oracle.adf.model.BindingContext.internalFindDataControl(BindingContext.java:1175)
               at oracle.adf.model.BindingContext.get(BindingContext.java:1128)
               at javax.el.MapELResolver.getValue(MapELResolver.java:164)
               at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:173)
               at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:200)
               at com.sun.el.parser.AstValue.getValue(Unknown Source)
               at com.sun.el.ValueExpressionImpl.getValue(Unknown Source)
               at com.br.fleury.selecionartipodeprojeto.util.JSFUtils.resolveExpression(JSFUtils.java:42)
               at com.br.fleury.selecionartipodeprojeto.util.ADFUtils.getApplicationModuleForDataControl(ADFUtils.java:41)
               at com.br.fleury.exibirnumerodoproejeto.bean.ExibirNumeroDoProejeto.geraCodigoDoProjeto(ExibirNumeroDoProejeto.java:57)
               at com.br.fleury.exibirnumerodoproejeto.bean.ExibirNumeroDoProejeto.getUsaCodigoProjeto(ExibirNumeroDoProejeto.java:75)
               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 javax.el.BeanELResolver.getValue(BeanELResolver.java:261)
               at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:173)
               at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:200)
               at com.sun.el.parser.AstValue.getValue(Unknown Source)
               at com.sun.el.ValueExpressionImpl.getValue(Unknown Source)
               at org.apache.myfaces.trinidad.bean.FacesBeanImpl.getProperty(FacesBeanImpl.java:68)
               at oracle.adfinternal.view.faces.renderkit.rich.ValueRenderer.getValue(ValueRenderer.java:184)
               at oracle.adfinternal.view.faces.renderkit.rich.ValueRenderer.getConvertedString(ValueRenderer.java:145)
               at oracle.adfinternal.view.faces.renderkit.rich.OutputLabelRenderer.encodeAll(OutputLabelRenderer.java:104)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer._encodeFormItem(PanelFormLayoutRenderer.java:1045)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer.access$100(PanelFormLayoutRenderer.java:46)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer$FormColumnEncoder.processComponent(PanelFormLayoutRenderer.java:1491)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer$FormColumnEncoder.processComponent(PanelFormLayoutRenderer.java:1410)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
               at org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:255)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer._encodeChildren(PanelFormLayoutRenderer.java:352)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelFormLayoutRenderer.encodeAll(PanelFormLayoutRenderer.java:187)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer._encodeChild(PanelGroupLayoutRenderer.java:432)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.access$300(PanelGroupLayoutRenderer.java:30)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:682)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:601)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
               at org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:255)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:358)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:415)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelBoxRenderer._encodeAllChildren(PanelBoxRenderer.java:1352)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelBoxRenderer._renderContentRow(PanelBoxRenderer.java:1265)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelBoxRenderer.encodeAll(PanelBoxRenderer.java:348)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer._encodeChild(PanelGroupLayoutRenderer.java:432)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.access$300(PanelGroupLayoutRenderer.java:30)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:682)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:601)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
               at org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:255)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:358)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:415)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.renderChildrenAfterHelpAndInfo(PanelHeaderRenderer.java:508)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer._renderContentCell(PanelHeaderRenderer.java:1032)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.renderContentRow(PanelHeaderRenderer.java:456)
               at oracle.adfinternal.view.faces.renderkit.rich.ShowDetailHeaderRenderer.renderContentRow(ShowDetailHeaderRenderer.java:165)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.encodeAll(PanelHeaderRenderer.java:217)
               at oracle.adfinternal.view.faces.renderkit.rich.ShowDetailHeaderRenderer.encodeAll(ShowDetailHeaderRenderer.java:86)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer._encodeChild(PanelGroupLayoutRenderer.java:432)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.access$300(PanelGroupLayoutRenderer.java:30)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:682)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:601)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
               at org.apache.myfaces.trinidad.component.UIXComponent.encodeFlattenedChildren(UIXComponent.java:255)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:358)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeAllChildren(CoreRenderer.java:415)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.renderChildrenAfterHelpAndInfo(PanelHeaderRenderer.java:508)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer._renderContentCell(PanelHeaderRenderer.java:1032)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.renderContentRow(PanelHeaderRenderer.java:456)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelHeaderRenderer.encodeAll(PanelHeaderRenderer.java:217)
               at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1396)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:335)
               at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:767)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
               at org.apache.myfaces.trinidad.render.CoreRenderer.encodeChild(CoreRenderer.java:399)
               at oracle.adf.view.rich.render.RichRenderer.encodeChild(RichRenderer.java:2633)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer._encodeChild(PanelGroupLayoutRenderer.java:432)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.access$300(PanelGroupLayoutRenderer.java:30)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:682)
               at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer$EncoderCallback.processComponent(PanelGroupLayoutRenderer.java:601)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:170)
               at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:290)
          Caused By: java.lang.ClassCastException: weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_jdbc_SQLServerConnection
               at oracle.jbo.server.OracleSQLBuilderImpl.setSessionTimeZone(OracleSQLBuilderImpl.java:5535)
               at oracle.jbo.server.DBTransactionImpl.refreshConnectionMetadata(DBTransactionImpl.java:5307)
               at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1190)
               at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6823)
               at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:301)
               at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:335)
               at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:203)
               at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:594)