换了授权模式，无法登录

wurui8

原来有的是3.6版的企业版本，现在升级到  3.9版本的  集群模式布署，启动时没有报错，   用户登录是   报用户名和密码错误（已经确认过没有问题）。具体看图片报错

wurui8

附件是后台报错的日志

wurui8

报错，之前3.6版本也没有加这个表，现在为什么报错了

wurui8

wurui8 发表于 2021-3-3 15:32
报错，之前3.6版本也没有加这个表，现在为什么报错了

这个怎么能不查这些表，因为之前一直都没用

wurui8

wurui8 发表于 2021-3-3 15:32
报错，之前3.6版本也没有加这个表，现在为什么报错了

data目录中有这个，为什么提示找不到

jishuang

ontology目录下有这个概念的定义吗？
确认system和SA是平台版本中默认带的，不是从老版本复制的？

wurui8

之前的问题都 解决了，现在是登录成功后，后台一个错  。 --> binds:[%, 1, 1, 1, 1683F048147A47A2933812B5645518CE, psm]
--> dataModel|M|/system/data
--> fnModelnull
java.lang.RuntimeException: queryLimit: 10000, ksql: select pm.sFID AS pm_fid,pm.sFName AS pm_fname,pm.sFCode AS pm_fcode, r, r.sCode as r_sCode, r.sName as r_sName, perm1.*  from SA_OPOrg pm  OPTIONAL JOIN SA_OPAuthorize au ON pm.sFID like concat(au.sOrgFID, '%')  JOIN SA_OPRole r ON (au.sAuthorizeRoleID=r AND r.sValidState = 1)  OPTIONAL JOIN SA_OPPermission perm1 ON (perm1.sPermissionRoleID=r  and perm1.sValidState=1)  WHERE pm.sValidState=1 and pm.sPersonID=:personId and pm.sOrgKindID=:kind
        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.KSQL.select(Unknown Source)
        at com.justep.system.opm.Operator.loadActionPermission(Unknown Source)
        at com.justep.system.opm.Operator.loadPersonPermission(Unknown Source)
        at com.justep.system.opm.Operator.<init>(Unknown Source)
        at com.justep.system.opm.OrgUtils.login(Native Method)
        at com.justep.system.opm.OrgUtils.login1(Unknown Source)
        at OPMProcedure.login(OPMProcedure.java:155)
        at OPMProcedure.login(OPMProcedure.java:137)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        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:741)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)

jishuang

http://bbs.wex5.com/forum.php?mo ... 7&pid=165664992