分析原因

主因 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!