当前位置: 代码迷 >> DB2 >> DB2经常报40001及54028求优化方法。代码目前不能做大的修改解决办法
  详细解决方案

DB2经常报40001及54028求优化方法。代码目前不能做大的修改解决办法

热度:10483   发布时间:2013-02-26 00:00:00.0
DB2经常报40001及54028求优化方法。代码目前不能做大的修改
参数审批通过失败:EJB Exception: : com.general.wf.util.WorkflowException: addTaskAssignExecutor:EJB Exception: ; nested exception is: javax.ejb.EJBException: updateUserTaskAssign:EJB Exception: ; nested exception is: javax.ejb.EJBException: getTaskList:[IBM][CLI Driver][DB2/NT] SQL0429N 已超过并发 LOB 定位器的最大数目。 SQLSTATE=54028 at com.general.wf.server.client.worklist.WorklistBean.updateUserTaskAssign(I)V(WorklistBean.java:578) at com.general.wf.server.client.worklist.Worklist_41xytu_EOImpl.updateUserTaskAssign(I)V(Worklist_41xytu_EOImpl.java:208) at com.amerisia.ebills.parameter.ejbs.ParameterApproveManagerEJB.approvePass(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Z(ParameterApproveManagerEJB.java:214) at com.amerisia.ebills.parameter.ejbs.ParameterApproveManager_prjwil_ELOImpl.approvePass(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Z(ParameterApproveManager_prjwil_ELOImpl.java:559) at com.amerisia.ebills.parameter.facade.ParameterManagerEJB.approvePass(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Z(ParameterManagerEJB.java:3563) at com.amerisia.ebills.parameter.facade.ParameterManager_r03vyj_EOImpl.approvePass(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Z(ParameterManager_r03vyj_EOImpl.java:9350) at com.amerisia.ebills.parameter.facade.ParameterManager_r03vyj_EOImpl_WLSkel.invoke(I[Ljava.lang.Object;Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source) at weblogic.rmi.internal.ServerRequest.sendReceive()Lweblogic.rmi.spi.InboundResponse;(ServerRequest.java:166) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Lweblogic.rmi.extensions.server.RemoteReference;Lweblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:290) at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Ljava.rmi.Remote;Lweblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:247) at com.amerisia.ebills.parameter.facade.ParameterManager_r03vyj_EOImpl_814_WLStub.approvePass(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)Z(Unknown Source) at com.amerisia.ebills.console.param.action.ParameterApproveAction.approvePass(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(ParameterApproveAction.java:144) at jrockit.reflect.NativeMethodInvoker.invoke0(Ljava.lang.Object;ILjava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source) at jrockit.reflect.NativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Optimized Method) at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava.lang.Object;[Ljava.lang.Object;)Ljava.lang.Object;(Optimized Method) at java.lang.reflect.Method.invoke(Ljava.lang.Object;[Ljava.lang.Object;I)Ljava.lang.Object;(Optimized Method) at com.amerisia.ebills.commons.action.EbillsBaseDispatchAction.dispatchMethod(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Ljava.lang.String;)Lorg.apache.struts.action.ActionForward;(EbillsBaseDispatchAction.java:916) at org.apache.struts.actions.DispatchAction.execute(Lorg.apache.struts.action.ActionMapping;Lorg.apache.struts.action.ActionForm;Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)Lorg.apache.struts.action.ActionForward;(DispatchAction.java:194) at org.apache.struts.action.RequestProcessor.processActionPerform(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;Lorg.apache.struts.action.Action;Lorg.apache.struts.action.ActionForm;Lorg.apache.struts.action.ActionMapping;)Lorg.apache.struts.action.ActionForward;(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:1006) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:419) at weblogic.servlet.internal.TailFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(TailFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27) at com.amerisia.ebills.commons.web.EncodingFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(EncodingFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27) at com.amerisia.ebills.commons.web.EncodingFilter.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Ljavax.servlet.FilterChain;)V(EncodingFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(FilterChainImpl.java:27) ; nested exception is: com.general.wf.util.WorkflowException: addTaskAssignExecutor:EJB Exception: ; nested exception is: javax.ejb.EJBException: updateUserTaskAssign:EJB Exception: ; nested exception is: javax.ejb.EJBException: getTaskList:[IBM][CLI Driver][DB2/NT] SQL0429N 已超过并发 LOB 定位器的最大数目。 SQLSTATE=54028
  相关解决方案