2.5版本报错

mnnm1983

如下，移动组织机构及特送都报错：
Caused by: com.justep.model.exception.ModelException: 执行ksql:update SA_OPRoleManagement SA_OPRoleManagement         set SA_OPRoleManagement.sOrgID = :newID,                  SA_OPRoleManagement.sOrgFID = concat(:newFullID,                                 substring(SA_OPRoleManagement.sOrgFID, length(ldFullID) + 1, length(SA_OPRoleManagement.sOrgFID))),                 SA_OPRoleManagement.sOrgFName = concat(:newFullName,                                 substring(SA_OPRoleManagement.sOrgFName, length(ldFullName) + 1, length(SA_OPRoleManagement.sOrgFName))),                SA_OPRoleManagement.version = SA_OPRoleManagement.version + 1         where SA_OPRoleManagement.sOrgFID like :likeFullID时出错！
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.opm.api.OrgHelper.a(Unknown Source)
        at com.justep.system.opm.api.OrgHelper.a(Unknown Source)
        at com.justep.system.opm.api.OrgHelper.moveOrg(Unknown Source)
        at OrgProcedure.moveOrg(OrgProcedure.java:236)
        ... 31 more
Caused by: com.justep.model.exception.ModelException: 执行sql：UPDATE SA_OPRoleManagement SET SA_OPRoleManagement.SORGID =  ? , SA_OPRoleManagement.SORGFID =  ?  || SUBSTR(SA_OPRoleManagement.SORGFID, ( LENGTH( ? ) + ? ), LENGTH(SA_OPRoleManagement.SORGFID)), SA_OPRoleManagement.SORGFNAME =  ?  || SUBSTR(SA_OPRoleManagement.SORGFNAME, ( LENGTH( ? ) + ? ), LENGTH(SA_OPRoleManagement.SORGFNAME)), SA_OPRoleManagement.VERSION = ( SA_OPRoleManagement.VERSION + ? )  WHERE SA_OPRoleManagement.SORGFID LIKE  ? , binds:[E5F15D07EBC74E549169F4EB3D4A3065@dept00010, /ORG01.ogn/dept00010.dpt/E5F15D07EBC74E549169F4EB3D4A3065@dept00010.psm, /ORG01.ogn/dept00022.dpt/E5F15D07EBC74E549169F4EB3D4A3065@dept00022.psm, 1, /青岛炼化/发展计划部/新建人员, /青岛炼化/行政事务中心/新建人员, 1, 1, /ORG01.ogn/dept00022.dpt/E5F15D07EBC74E549169F4EB3D4A3065@dept00022.psm%]出错！
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 38 more
Caused by: java.sql.SQLException: ORA-20401:Reject By Dbsec                    
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:114)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:114)
        ... 39 more

jishuang

之前都好好的，突然就报错了吗？报错先修改了什么？

错误是报的oracle数据库的错误

mnnm1983

jishuang 发表于 2021-8-2 19:02
之前都好好的，突然就报错了吗？报错先修改了什么？

错误是报的oracle数据库的错误 ...

我们没做什么操作。这个oracle的错，网上也没找到解决方案。看起步这边能不能提供个排查的方案。

jishuang

确认是不是操作特定的组织的时候才有问题，把sql语句拿到数据库执行，一点一点跟踪操作的数据看看是不是数据有问题