每次用户登录时，justep.biz.log报queryLimit: 10000，如何调整？

doris

每次用户登录时，justep.biz.log报queryLimit: 10000，如何调整？tomcat控制台刷得太多了……

2020-01-14 18:58:28 [http-8080-24] [com.justep.system.data.impl.TableUtilsImplement] WARN: queryLimit: 10000, exec KSQL: SELECT SA_OPOrg.*,SA_OPPerson.sPhotoLastModified as sPhotoLastModified,SA_OPPerson.sNumb as sNumb  FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE (SA_OPOrg.sValidState >= 0) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
--> sql:SELECT  SA_OPOrg.sID AS SA_OPOrg, SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPPerson.SPHOTOLASTMODIFIED AS sPhotoLastModified, SA_OPPerson.SNUMB AS sNumb FROM SA_OPOrg SA_OPOrg LEFT JOIN SA_OPPerson SA_OPPerson ON SA_OPOrg.SPERSONID = SA_OPPerson.sID  WHERE SA_OPOrg.SVALIDSTATE >= ?  ORDER BY SA_OPOrg.SSEQUENCE ASC
--> binds:[0]
--> dataModel|M|/system/data
--> fnModelnull
java.lang.RuntimeException: queryLimit: 10000, ksql: SELECT SA_OPOrg.*,SA_OPPerson.sPhotoLastModified as sPhotoLastModified,SA_OPPerson.sNumb as sNumb  FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE (SA_OPOrg.sValidState >= 0) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, -1
        at com.justep.system.data.impl.TableUtilsImplement.queryWarn(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at com.justep.system.opm.OrgQuery.query(Unknown Source)
        at OPMProcedure.query(OPMProcedure.java:141)
        at sun.reflect.GeneratedMethodAccessor420.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)
        at java.lang.Thread.run(Thread.java:745)

jishuang

这个只是警告，不会影响你功能的任何使用，只是告诉你一次性加载的数据超过了这么多条

doris

jishuang 发表于 2020-1-15 09:12
这个只是警告，不会影响你功能的任何使用，只是告诉你一次性加载的数据超过了这么多条 ...

但是每次用户登录要刷这么一长串，数量又多，感觉登录都要卡一下。有方法不警告吗？

jishuang

apache-tomcat\bin\catalina.bat的JAVA_OPTS配置中加上-DJUSTEP_KSQL_QUERY_LIMIT=100可以把100改为一个很大值，默认是10000

doris

jishuang 发表于 2020-1-15 10:41
apache-tomcat\bin\catalina.bat的JAVA_OPTS配置中加上-DJUSTEP_KSQL_QUERY_LIMIT=100可以把100改为一个很 ...

谢谢，请结贴