数据权限配置后界面报错

adjust

如题，配置好数据权限，条件在数据库中执行是正确的，但打开功能界面报错如下：完整报错见附件

1. 2020-10-22 10:55:17 [http-80-4] [com.justep.system.ksql.permission.PermissionVisitor] ERROR: 编码: JUSTEP154098; 提示: 错误权限表达式，只能是AND 或者 OR开头, and SQL.isnull(HP_ContractInfo.fEducationAttr,'科技处') = '社科处'
   
2. com.justep.exception.BusinessException: 编码: JUSTEP154098; 提示: 错误权限表达式，只能是AND 或者 OR开头, and SQL.isnull(HP_ContractInfo.fEducationAttr,'科技处') = '社科处'
   
3.         at com.justep.exception.BusinessException.create(Unknown Source)
   
4.         at com.justep.util.Utils.check(Unknown Source)
   
5.         at com.justep.system.ksql.permission.DataPermissionImpl.extractInfo(Unknown Source)
   
6.         at com.justep.system.ksql.permission.PermissionVisitor.parse(Unknown Source)
   
7.         at com.justep.system.data.impl.TableUtilsImplement.parseDataPermission(Unknown Source)
   
8.         at com.justep.system.data.KSQL.parseDataPermission(Unknown Source)
   
9.         at com.justep.system.opm.MActionPermission.initinalParameter(Unknown Source)
   
10.         at com.justep.system.opm.Permissions.getActionPermission(Unknown Source)
    
11.         at com.justep.system.opm.Person.getPermissionParameter(Unknown Source)
    
12.         at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
    
13.         at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
    
14.         at com.justep.system.interceptor.CheckPermission.actionParamInit(Unknown Source)
    
15.         at com.justep.system.interceptor.CheckPermission.execute(Unknown Source)
    
16.         at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
    
17.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
18.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
19.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
20.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
21.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
22.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
23.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
24.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
25.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
26.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
27.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
28.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
29.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
30.         at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
    
31.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
32.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
33.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
34.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
35.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
36.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
37.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
38.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
39.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
40.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
41.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
42.         at java.lang.Thread.run(Thread.java:745)
    

复制代码

jishuang

and要改为大写

adjust

jishuang 发表于 2020-10-22 11:37
and要改为大写

之前就测试过了的，发帖时没有截取那一段，AND改成大写，还是同样的报错。报错日志是一样的

1. 2020-10-23 08:48:42 [http-80-18] [com.justep.business.server.BusinessServerServlet] ERROR: Not registed session:39C56A947995D33F53F3732297A153AB, jsessionid:JSESSIONID=47BEF21C46096BCD5E5D7AB0B54B8F13, action: check_session
   
2. 2020-10-23 08:48:48 [http-80-2] [com.justep.system.ksql.permission.PermissionVisitor] ERROR: 编码: JUSTEP154098; 提示: 错误权限表达式，只能是AND 或者 OR开头, AND SQL.isnull(HP_ContractInfo.fEducationAttr,'科技处') = '科技处'
   
3. com.justep.exception.BusinessException: 编码: JUSTEP154098; 提示: 错误权限表达式，只能是AND 或者 OR开头, AND SQL.isnull(HP_ContractInfo.fEducationAttr,'科技处') = '科技处'

复制代码

jishuang

数据权限中完整的是怎么写的？

adjust

jishuang 发表于 2020-10-23 10:13
数据权限中完整的是怎么写的？

1. <xml><a name="queryHP_ContractInfoAction" label="queryHP_ContractInfoAction"><p name="range" label="range" kind="expr"><v> AND SQL.isnull(HP_ContractInfo.fEducationAttr,'科技处') = '科技处'</v></p></a></xml>

复制代码

jishuang

数据权限中直接写写xml节点？

adjust

jishuang 发表于 2020-10-26 20:00
数据权限中直接写写xml节点？

见图

jishuang

把SQL.isnull去掉看看

adjust

jishuang 发表于 2020-10-27 15:51
把SQL.isnull去掉看看

效果还是一样

1. 2020-10-28 09:20:26 [http-80-1] [com.justep.business.server.BusinessServerServlet] ERROR: Not registed session:821A47A3510BAEC6B7E16DF0317E8393, jsessionid:JSESSIONID=3394CBB74807C7DB29F51B0CBF0709AA, action: check_session
   
2. 2020-10-28 09:20:37 [http-80-3] [com.justep.system.ksql.permission.PermissionVisitor] ERROR: 编码: JUSTEP154096; 提示: 错误的权限表达式, AND HP_ContractInfo.fEducationAttr = '科技处'
   
3. com.justep.exception.BusinessException: 编码: JUSTEP154096; 提示: 错误的权限表达式, AND HP_ContractInfo.fEducationAttr = '科技处'
   
4.         at com.justep.exception.BusinessException.create(Unknown Source)
   
5.         at com.justep.util.Utils.check(Unknown Source)
   
6.         at com.justep.system.ksql.permission.DataPermissionImpl.extractInfo(Unknown Source)
   
7.         at com.justep.system.ksql.permission.PermissionVisitor.parse(Unknown Source)
   
8.         at com.justep.system.data.impl.TableUtilsImplement.parseDataPermission(Unknown Source)
   
9.         at com.justep.system.data.KSQL.parseDataPermission(Unknown Source)
   
10.         at com.justep.system.opm.MActionPermission.initinalParameter(Unknown Source)
    
11.         at com.justep.system.opm.Permissions.getActionPermission(Unknown Source)
    
12.         at com.justep.system.opm.Person.getPermissionParameter(Unknown Source)
    
13.         at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
    
14.         at com.justep.system.opm.Operator.getPermissionParameter(Unknown Source)
    
15.         at com.justep.system.interceptor.CheckPermission.actionParamInit(Unknown Source)
    
16.         at com.justep.system.interceptor.CheckPermission.execute(Unknown Source)
    
17.         at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
    
18.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
19.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
20.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
21.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
22.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
23.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
24.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
25.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
26.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
27.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
28.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
29.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
30.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
31.         at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
    
32.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
33.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
34.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
35.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
36.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
37.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
38.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
39.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
40.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
41.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
42.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
43.         at java.lang.Thread.run(Thread.java:745)

复制代码

jishuang

AND (HP_ContractInfo.fEducationAttr = '科技处')

这样