V5.37版本中丢失了组织权限的菜单

gost_1223

如题，V5.37版本中丢失了组织权限的菜单  貌似也没做什么操作

jishuang

BeX5的问题，到BeX5论坛板块发帖

参考平台tools\init\script\对应的数据库类型\system.sql中提供的权限相关的初始化语句到数据库中查看是不是权限被删除了

gost_1223

是权限被删除了，角色未删除，然后我添加权限，添加了sa_oppermission权限标与sa_opauthorize授权标，添加完重启报错，
之后测试只添加sa_oppermission表数据就出错
如下：
java.lang.reflect.InvocationTargetException
        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.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 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.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.system.util.BizSystemException: 编码: JUSTEP180048; 提示: 加载权限出错, process="/SA/OPM/organization/organizationProcess", activity="mainActivity", actions="<CLOB>"
        at com.justep.system.util.BizSystemException.create(Unknown Source)
        at com.justep.system.opm.Permission.readActions(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:152)
        at OPMProcedure.login(OPMProcedure.java:137)
        ... 26 more
Caused by: org.dom4j.DocumentException: Error on line 1 of document  : XML 文档结构必须从头至尾包含在同一个实体内。 Nested exception: XML 文档结构必须从头至尾包含在同一个实体内。
        at org.dom4j.io.SAXReader.read(SAXReader.java:482)
        at org.dom4j.io.SAXReader.read(SAXReader.java:365)
        ... 34 more

jishuang

确认sa_oppermission中的数据添加的正确？

gost_1223

jishuang 发表于 2018-9-28 09:55
确认sa_oppermission中的数据添加的正确？

insert into sa_oppermission (SID, SPERMISSIONROLEID, SPROCESS, SACTIVITYFNAME, SACTIVITY, SACTIONSNAMES, SACTIONS, SSEMANTICDP, SPERMISSIONKIND, SDESCRIPTION, SSEQUENCE, SVALIDSTATE, VERSION)
values ('SYS-OPM-01', '0DF950BEA2E54DC48161D41C4FC92736', '/SA/OPM/organization/organizationProcess', '/组织权限/组织管理', 'mainActivity', '<CLOB>', '<CLOB>', null, 0, null, 1, 1, 0);
第二列是roleID

jishuang

'<CLOB>', '<CLOB>'这两个数据明显不正确啊

gost_1223

jishuang 发表于 2018-9-28 10:28
'', ''这两个数据明显不正确啊

要值为空吗

jishuang

看平台提供的脚本中啊，脚本中肯定不是这样的吧

gost_1223

jishuang 发表于 2018-9-28 10:32
看平台提供的脚本中啊，脚本中肯定不是这样的吧

嗯，我是从同事那导出的数据就直接插入了，clob类型，空值，导出显示成那样，把那两列改为空就好了