分析原因

主因 sql太差 深层次原因 表碎片化造成oracle计划错误

解决思路 优化sql 碎片化整理

日志 ] , which is more than the configured time (StuckThreadMaxTime) of 600 seconds. Stack trace: Thread-455 [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) alive, in native, suspended, priority 1, DAEMON {     jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)     jrockit.net.SocketNativeIO.socketRead(SocketNativeIO.java:24)     java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)     java.net.SocketInputStream.read(SocketInputStream.java:107)     oracle.net.ns.Packet.receive(Packet.java:241)     oracle.net.ns.DataPacket.receive(DataPacket.java:106)     oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:307)     oracle.net.ns.NetInputStream.read(NetInputStream.java:252)     oracle.net.ns.NetInputStream.read(NetInputStream.java:185)     oracle.net.ns.NetInputStream.read(NetInputStream.java:90)     oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:120)     oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:75)     oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1132)     oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:281)     oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:176)     oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:381)     oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:67)     oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:871)     oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1132)     oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1246)     oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4670)     oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10514)     oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)     oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3629)     ^-- Holding lock: oracle.jdbc.driver.T4CConnection 239d4ef3[thin lock]     oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)     weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:123)     com.neusoft.udolink.common.impl.StoreManager.executeBasicQuery(StoreManager.java:1875)     com.neusoft.udolink.common.impl.StoreManager.executeQuery(StoreManager.java:2009)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1359)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1468)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1326)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1321)     com.neusoft.drm.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:240)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:125)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:110)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:76)     com.neusoft.si.simis.local.medicare.applogic.impl.LzjbPayAsDisease.calcFactPays(Unknown Source)     com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.forDisease(Unknown Source)     com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.calcSettle(Unknown Source)     com.neusoft.si.simis.medicare.domain.organsettlement.applogic.impl.MonthSettleApplogicImpl.monthSettleCalc(Unknown Source)     com.neusoft.si.simis.medicare.interaction.organsettlement.impl.MonthSettleInteractionImpl.executeMonthSettleCalc(MonthSettleInteractionImpl.java:52)     sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:???)     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:27)     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     java.lang.reflect.Method.invoke(Method.java:575)     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.bl.interaction.advice.InteractionExchangeLogInterceptor.invoke(InteractionExchangeLogInterceptor.java:33)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.bl.interaction.advice.InteractionAutoTestIntercetor.invoke(InteractionAutoTestIntercetor.java:35)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.services.database.advice.InteractionTransactionInterceptor.invoke(InteractionTransactionInterceptor.java:45)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:49)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:150)     $Proxy413.executeMonthSettleCalc(Unknown Source)     sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:???)     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:27)     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     java.lang.reflect.Method.invoke(Method.java:575)     com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.BusinessExecute(SiBusinessDelegateAction.java:220)     com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.execute(SiBusinessDelegateAction.java:72)     org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)     org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:163)     com.neusoft.unieap.action.EAPActionServlet.process(EAPActionServlet.java:796)     org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)     javax.servlet.http.HttpServlet.service(HttpServlet.java:700)     javax.servlet.http.HttpServlet.service(HttpServlet.java:815)     weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:224)     weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:108)     weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:207)     weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.intercept.filter.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:77)     com.neusoft.unieap.service.security.ui.webapp.UniEAPSecurityEnforcementFilter.doFilter(UniEAPSecurityEnforcementFilter.java:124)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:266)     com.neusoft.unieap.service.security.ui.webapp.AuthenticationProcessingFilter.doFilter(AuthenticationProcessingFilter.java:115)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:164)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.accountPolicy.AccountPolicyFilter.doFilter(AccountPolicyFilter.java:47)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.ui.webapp.JcaptchaProcessingFilter.doFilter(JcaptchaProcessingFilter.java:88)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:157)     net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:121)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     com.neusoft.unieap.comp.ajaxanywhere.AAFilter.doFilter(AAFilter.java:48)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     org.ecside.filter.ECSideFilter.doFilter(ECSideFilter.java:138)     com.neusoft.unieap.comp.transcoding.TranscodingFilter.doFilter(TranscodingFilter.java:23)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     com.neusoft.unieap.core.filter.IEModeFilter.doFilter(IEModeFilter.java:37)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3720)     weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)     weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:308)     weblogic.security.service.SecurityManager.runAs(SecurityManager.java:116)     weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2219)     weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2134)     weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1466)     weblogic.work.ExecuteThread.execute(ExecuteThread.java:257)     weblogic.work.ExecuteThread.run(ExecuteThread.java:213) }

  2020-8-28 01ʱ36ST Error WebLogicServer BEA-000337 [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) has been busy for 673 seconds working on the request Workmanager: default, Version: 0, Scheduled true, Started true, Started time: 673464 ms [ POST /eapdomain/SiBusinessDelegateAction.do?method execute BUSINESS_REQUEST_ID REQ-KF-M-001-00 MENUID 1382089906516 BUSINESS_ID HTTP/1.1 Accept: */* ajaxRequest: true Content-Type: multipart/form-data Referer: http://10.30.12.26:7024/eapdomain/si/pages/medicare/organsettlement/monthsettle/orgmonthsettle.jsp?checkGrade 1 CUSTOMPARA SI_TYPE~1~VAR menuid 1382089906516 Accept-Language: zh-cn Accept-Encoding: gzip, deflate User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko Content-Length: 552 Connection: Keep-Alive Cache-Control: no-cache Cookie: SI_USERNAME test; JSESSIONID P_Mzg7nwBuBt4bp04zzZEMWSTrJBPKXGBh0gjRdraM_XTXbuijXP!-125918212

] , which is more than the configured time (StuckThreadMaxTime) of 600 seconds. Stack trace: Thread-455 [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) alive, in native, suspended, priority 1, DAEMON {     jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)     jrockit.net.SocketNativeIO.socketRead(SocketNativeIO.java:24)     java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)     java.net.SocketInputStream.read(SocketInputStream.java:107)     oracle.net.ns.Packet.receive(Packet.java:241)     oracle.net.ns.DataPacket.receive(DataPacket.java:106)     oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:307)     oracle.net.ns.NetInputStream.read(NetInputStream.java:252)     oracle.net.ns.NetInputStream.read(NetInputStream.java:185)     oracle.net.ns.NetInputStream.read(NetInputStream.java:90)     oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:120)     oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:75)     oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1132)     oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:281)     oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:176)     oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:381)     oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:67)     oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:871)     oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1132)     oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1246)     oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4670)     oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10514)     oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3568)     oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3629)     ^-- Holding lock: oracle.jdbc.driver.T4CConnection 239d4ef3[thin lock]     oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)     weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:123)     com.neusoft.udolink.common.impl.StoreManager.executeBasicQuery(StoreManager.java:1875)     com.neusoft.udolink.common.impl.StoreManager.executeQuery(StoreManager.java:2009)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1359)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1468)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1326)     com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1321)     com.neusoft.drm.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:240)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:125)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:110)     com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:76)     com.neusoft.si.simis.local.medicare.applogic.impl.LzjbPayAsDisease.calcFactPays(Unknown Source)     com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.forDisease(Unknown Source)     com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.calcSettle(Unknown Source)     com.neusoft.si.simis.medicare.domain.organsettlement.applogic.impl.MonthSettleApplogicImpl.monthSettleCalc(Unknown Source)     com.neusoft.si.simis.medicare.interaction.organsettlement.impl.MonthSettleInteractionImpl.executeMonthSettleCalc(MonthSettleInteractionImpl.java:52)     sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:???)     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:27)     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     java.lang.reflect.Method.invoke(Method.java:575)     org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)     org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.bl.interaction.advice.InteractionExchangeLogInterceptor.invoke(InteractionExchangeLogInterceptor.java:33)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.bl.interaction.advice.InteractionAutoTestIntercetor.invoke(InteractionAutoTestIntercetor.java:35)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     com.neusoft.si.sys.services.database.advice.InteractionTransactionInterceptor.invoke(InteractionTransactionInterceptor.java:45)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:49)     org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)     org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:150)     $Proxy413.executeMonthSettleCalc(Unknown Source)     sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:???)     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:27)     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     java.lang.reflect.Method.invoke(Method.java:575)     com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.BusinessExecute(SiBusinessDelegateAction.java:220)     com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.execute(SiBusinessDelegateAction.java:72)     org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)     org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:163)     com.neusoft.unieap.action.EAPActionServlet.process(EAPActionServlet.java:796)     org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)     javax.servlet.http.HttpServlet.service(HttpServlet.java:700)     javax.servlet.http.HttpServlet.service(HttpServlet.java:815)     weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:224)     weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:108)     weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:207)     weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.intercept.filter.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:77)     com.neusoft.unieap.service.security.ui.webapp.UniEAPSecurityEnforcementFilter.doFilter(UniEAPSecurityEnforcementFilter.java:124)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:266)     com.neusoft.unieap.service.security.ui.webapp.AuthenticationProcessingFilter.doFilter(AuthenticationProcessingFilter.java:115)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:164)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.accountPolicy.AccountPolicyFilter.doFilter(AccountPolicyFilter.java:47)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     com.neusoft.unieap.service.security.ui.webapp.JcaptchaProcessingFilter.doFilter(JcaptchaProcessingFilter.java:88)     net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:286)     net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:157)     net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:121)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     com.neusoft.unieap.comp.ajaxanywhere.AAFilter.doFilter(AAFilter.java:48)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     org.ecside.filter.ECSideFilter.doFilter(ECSideFilter.java:138)     com.neusoft.unieap.comp.transcoding.TranscodingFilter.doFilter(TranscodingFilter.java:23)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     com.neusoft.unieap.core.filter.IEModeFilter.doFilter(IEModeFilter.java:37)     weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:59)     weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3720)     weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)     weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:308)     weblogic.security.service.SecurityManager.runAs(SecurityManager.java:116)     weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2219)     weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2134)     weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1466)     weblogic.work.ExecuteThread.execute(ExecuteThread.java:257)     weblogic.work.ExecuteThread.run(ExecuteThread.java:213) }

  2020/08/28-13:41:37 ERROR [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) com.neusoft.udolink.logger.Log4jLogger.error(Log4jLogger.java:138) DRM_R_1005 com.neusoft.drm.DrmException:  **DrmException: DRM_R_1005 : ҵѯʧ  **UDOLink Waring: So far,UDOLink does not support multi-thread to share one PM!         at com.neusoft.drm.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:248)         at com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:132)         at com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:110)         at com.neusoft.si.sys.services.database.SqlUtil.executeQuery(SqlUtil.java:76)         at com.neusoft.si.simis.local.medicare.applogic.impl.LzjbPayAsDisease.calcFactPays(Unknown Source)         at com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.forDisease(Unknown Source)         at com.neusoft.si.simis.local.medicare.domain.treataudit.applogic.impl.LzjbPayAsSettlement.calcSettle(Unknown Source)         at com.neusoft.si.simis.medicare.domain.organsettlement.applogic.impl.MonthSettleApplogicImpl.monthSettleCalc(Unknown Source)         at com.neusoft.si.simis.medicare.interaction.organsettlement.impl.MonthSettleInteractionImpl.executeMonthSettleCalc(MonthSettleInteractionImpl.java:55)         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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)         at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at com.neusoft.si.sys.bl.interaction.advice.InteractionExchangeLogInterceptor.invoke(InteractionExchangeLogInterceptor.java:39)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at com.neusoft.si.sys.bl.interaction.advice.InteractionAutoTestIntercetor.invoke(InteractionAutoTestIntercetor.java:47)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at com.neusoft.si.sys.services.database.advice.InteractionTransactionInterceptor.invoke(InteractionTransactionInterceptor.java:84)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)         at $Proxy413.executeMonthSettleCalc(Unknown Source)         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 com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.BusinessExecute(SiBusinessDelegateAction.java:250)         at com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.execute(SiBusinessDelegateAction.java:136)         at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)         at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)         at com.neusoft.unieap.action.EAPActionServlet.process(EAPActionServlet.java:835)         at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:434)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)         at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)         at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)         at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)         at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)         at com.neusoft.unieap.service.security.intercept.filter.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:105)         at com.neusoft.unieap.service.security.ui.webapp.UniEAPSecurityEnforcementFilter.doFilter(UniEAPSecurityEnforcementFilter.java:137)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:306)         at com.neusoft.unieap.service.security.ui.webapp.AuthenticationProcessingFilter.doFilter(AuthenticationProcessingFilter.java:116)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:263)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.accountPolicy.AccountPolicyFilter.doFilter(AccountPolicyFilter.java:55)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.ui.webapp.JcaptchaProcessingFilter.doFilter(JcaptchaProcessingFilter.java:133)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)         at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:126)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at com.neusoft.unieap.comp.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at org.ecside.filter.ECSideFilter.doFilter(ECSideFilter.java:156)         at com.neusoft.unieap.comp.transcoding.TranscodingFilter.doFilter(TranscodingFilter.java:33)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at com.neusoft.unieap.core.filter.IEModeFilter.doFilter(IEModeFilter.java:60)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)         at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)         at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)         at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)         at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) Caused by: com.neusoft.udolink.OPPersistenceException:  **UDOLink Waring: So far,UDOLink does not support multi-thread to share one PM!         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.preCheckID(DBPersistenceManagerImpl.java:1945)         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.preCheck(DBPersistenceManagerImpl.java:1896)         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1326)         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:1321)         at com.neusoft.drm.common.impl.DBPersistenceManagerImpl.executeQuery(DBPersistenceManagerImpl.java:241)         ... 81 more 2020/08/28-13:41:37 ERROR [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) com.neusoft.udolink.logger.Log4jLogger.error(Log4jLogger.java:138) Thread [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) ,  **UDOLink Waring: So far,UDOLink does not support multi-thread to share one PM!

ExceptionMessage **UDOLink Waring: So far,UDOLink does not support multi-thread to share one PM!         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.preCheckID(DBPersistenceManagerImpl.java:1945)         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.preCheck(DBPersistenceManagerImpl.java:1896)         at com.neusoft.udolink.common.impl.DBPersistenceManagerImpl.currentTransaction(DBPersistenceManagerImpl.java:264)         at com.neusoft.udolink.common.globaltran.UDOLinkTransactionServiceImpl.rollbackInternalForUserConfigJDBCTran(UDOLinkTransactionServiceImpl.java:558)         at com.neusoft.udolink.common.globaltran.UDOLinkTransactionServiceImpl.unknownUserTypeRollback(UDOLinkTransactionServiceImpl.java:667)         at com.neusoft.udolink.common.globaltran.UDOLinkTransactionServiceImpl.rollbackTran(UDOLinkTransactionServiceImpl.java:635)         at com.neusoft.si.sys.services.database.advice.InteractionTransactionInterceptor.invoke(InteractionTransactionInterceptor.java:117)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)         at $Proxy413.executeMonthSettleCalc(Unknown Source)         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 com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.BusinessExecute(SiBusinessDelegateAction.java:250)         at com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.execute(SiBusinessDelegateAction.java:136)         at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)         at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)         at com.neusoft.unieap.action.EAPActionServlet.process(EAPActionServlet.java:835)         at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:434)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)         at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)         at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)         at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)         at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)         at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)         at com.neusoft.unieap.service.security.intercept.filter.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:105)         at com.neusoft.unieap.service.security.ui.webapp.UniEAPSecurityEnforcementFilter.doFilter(UniEAPSecurityEnforcementFilter.java:137)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:306)         at com.neusoft.unieap.service.security.ui.webapp.AuthenticationProcessingFilter.doFilter(AuthenticationProcessingFilter.java:116)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:263)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.accountPolicy.AccountPolicyFilter.doFilter(AccountPolicyFilter.java:55)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at com.neusoft.unieap.service.security.ui.webapp.JcaptchaProcessingFilter.doFilter(JcaptchaProcessingFilter.java:133)         at net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)         at net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)         at net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:126)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at com.neusoft.unieap.comp.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at org.ecside.filter.ECSideFilter.doFilter(ECSideFilter.java:156)         at com.neusoft.unieap.comp.transcoding.TranscodingFilter.doFilter(TranscodingFilter.java:33)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at com.neusoft.unieap.core.filter.IEModeFilter.doFilter(IEModeFilter.java:60)         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:61)         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)         at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)         at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)         at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)         at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)         at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

2020/08/28-13:41:37  WARN [STUCK] ExecuteThread: 19 for queue: weblogic.kernel.Default (self-tuning) com.neusoft.si.sys.bl.action.SiBusinessDelegateAction.responseError(SiBusinessDelegateAction.java:172)  

**DrmException: DRM_R_1005 : ҵѯʧ  **UDOLink Waring: So far,UDOLink does not support multi-thread to share one PM!