使用了5.2.7的hr放入5.3.8中

胡屠户

使用了5.2.7的hr系统放入5.3.8中后组织机构无法进行修改，每次都报使用的自带的save方法

Caused by: java.sql.SQLException: Table 'HR_OG_Org' is specified twice, both as a target for 'UPDATE' and as a separate source for data



Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update HR_OG_Org a  set a.fFID = (select concat(b.fFID,'/',a,'.',a.fOrgKindID) from HR_OG_Org b where b = a.fParent),     a.fFCode = (select concat(b.fFCode,'/',a.fCode) from HR_OG_Org b where b = a.fParent),     a.fFName = (select concat(b.fFName,'/',a.fName) from HR_OG_Org b where b = a.fParent)  where a.fFID is null and a.fParent in(select o from HR_OG_Org o where o.fFID is not null)
        at com.justep.exception.BusinessException.create(Unknown Source)
        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.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.x5hr.org.HROrgURL.reBuildOrgURL(HROrgURL.java:42)
        at com.x5hr.org.HROrgSync.synchronizeHROrgToSA(HROrgSync.java:22)
        at HRToSystemSync.orgSync(HRToSystemSync.java:10)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: UPDATE HR_OG_Org SET HR_OG_Org.FFID = (SELECT  concat_ws('',b.FFID, ?, HR_OG_Org.fID, ?, HR_OG_Org.FORGKINDID) FROM HR_OG_Org b  WHERE b.fID = HR_OG_Org.fParent), HR_OG_Org.FFCODE = (SELECT  concat_ws('',b.FFCODE, ?, HR_OG_Org.FCODE) FROM HR_OG_Org b  WHERE b.fID = HR_OG_Org.fParent), HR_OG_Org.FFNAME = (SELECT  concat_ws('',b.FFNAME, ?, HR_OG_Org.FNAME) FROM HR_OG_Org b  WHERE b.fID = HR_OG_Org.fParent)  WHERE  (HR_OG_Org.FFID IS NULL) AND (HR_OG_Org.fParent IN (SELECT  o.fID FROM HR_OG_Org o  WHERE o.FFID IS NOT NULL)) , binds: [/, ., /, /]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 38 more
Caused by: java.sql.SQLException: Table 'HR_OG_Org' is specified twice, both as a target for 'UPDATE' and as a separate source for data

jishuang

java.sql.SQLException: Table 'HR_OG_Org' is specified twice, both as a target for 'UPDATE' and as a separate source for data

这个是数据库的标准错误信息，到网上查找原因

胡屠户

jishuang 发表于 2018-8-22 17:39
java.sql.SQLException: Table 'HR_OG_Org' is specified twice, both as a target for 'UPDATE' and as a ...

这个是ontology生产的标准动作保存，能改吗？

jishuang

select部分可以自己修改

jishuang

  at com.x5hr.org.HROrgURL.reBuildOrgURL(HROrgURL.java:42)
        at com.x5hr.org.HROrgSync.synchronizeHROrgToSA(HROrgSync.java:22)
        at HRToSystemSync.orgSync(HRToSystemSync.java:10)

应该是sql中拼接的