起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 资源和服务 › BeX5应用产品 › HR组织机构管理新建机构保存不了
返回列表 发新帖回复
查看: 2284|回复: 5

[结贴] HR组织机构管理新建机构保存不了

[复制链接]

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
发表于 2014-9-30 11:45:05 | 显示全部楼层 |阅读模式
如图。保存报错。错误信息如下：

  2. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  3.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  4.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  5.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  6.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  7.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  8.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  9.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  10.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  11.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  12.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  13.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  14.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  15.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  16.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  17.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  18.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  19.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  20.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  21.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  22.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  23.         at java.lang.Thread.run(Thread.java:619)
  24. Caused by: java.lang.reflect.InvocationTargetException
  25.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  26.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  27.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  28.         at java.lang.reflect.Method.invoke(Method.java:597)
  29.         at com.justep.system.action.Engine.invokeActions(Native Method)
  30.         ... 21 more
复制代码



QQ截图20140930114242.png
天天就知道打酱油打酱油，有点出息行么。QQ:497923435
回复

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2014-9-30 11:45:55 | 显示全部楼层
  1. Caused by: com.justep.model.exception.ModelException: 执行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)时出错！
  2.         at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
  3.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
  4.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  5.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  6.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  7.         at com.x5hr.org.HROrgURL.reBuildOrgURL(HROrgURL.java:42)
  8.         at com.x5hr.org.HROrgSync.synchronizeHROrgToSA(HROrgSync.java:22)
  9.         at HRToSystemSync.orgSync(HRToSystemSync.java:10)
  10.         ... 26 more
  11. Caused by: com.justep.model.exception.ModelException: 执行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:[/, ., /, /]出错！
  12.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
  13.         ... 34 more
  14. Caused by: java.sql.SQLException: You can't specify target table 'HR_OG_Org' for update in FROM clause
  15.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
  16.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
  17.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
  18.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
  19.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
  20.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
  21.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
  22.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
  23.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  24.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  25.         ... 35 more
复制代码
天天就知道打酱油打酱油，有点出息行么。QQ:497923435
点评回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2014-9-30 11:46:13 | 显示全部楼层
  1. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
  2.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
  3.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
  4.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
  5.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
  6.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
  7.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
  8.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  9.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
  10.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  11.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  12.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  13.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  14.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  15.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  16.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  17.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  18.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  19.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  20.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  21.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  22.         at java.lang.Thread.run(Thread.java:619)
  23. Caused by: java.lang.reflect.InvocationTargetException
  24.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  25.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  26.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  27.         at java.lang.reflect.Method.invoke(Method.java:597)
  28.         at com.justep.system.action.Engine.invokeActions(Native Method)
  29.         ... 21 more
  30. Caused by: com.justep.model.exception.ModelException: 执行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)时出错！
  31.         at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
  32.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
  33.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  34.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  35.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
  36.         at com.x5hr.org.HROrgURL.reBuildOrgURL(HROrgURL.java:42)
  37.         at com.x5hr.org.HROrgSync.synchronizeHROrgToSA(HROrgSync.java:22)
  38.         at HRToSystemSync.orgSync(HRToSystemSync.java:10)
  39.         ... 26 more
  40. Caused by: com.justep.model.exception.ModelException: 执行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:[/, ., /, /]出错！
  41.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
  42.         ... 34 more
  43. Caused by: java.sql.SQLException: You can't specify target table 'HR_OG_Org' for update in FROM clause
  44.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
  45.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
  46.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
  47.         at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
  48.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
  49.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
  50.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
  51.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
  52.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  53.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
  54.         ... 35 more
复制代码
天天就知道打酱油打酱油，有点出息行么。QQ:497923435
点评回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2014-9-30 14:42:52 | 显示全部楼层
You can't specify target table 'HR_OG_Org' for update in FROM clause
百度了一下，在mysql中不支持SQL的这种写法
天天就知道打酱油打酱油，有点出息行么。QQ:497923435
点评回复 支持 反对

使用道具 举报

39

主题

1379

帖子

2464

积分

金牌会员

Rank: 6Rank: 6

积分
2464
发表于 2014-10-8 09:29:40 | 显示全部楼层
ly201026 发表于 2014-9-30 14:42
You can't specify target table 'HR_OG_Org' for update in FROM clause
百度了一下，在mysql中不支持SQL ...

hr不支持mysql数据库
点评回复 支持 反对

使用道具 举报

185

主题

777

帖子

1644

积分

金牌会员

Rank: 6Rank: 6

积分
1644
QQ
 楼主| 发表于 2014-10-8 16:34:58 | 显示全部楼层
lixin_justep 发表于 2014-10-8 09:29
hr不支持mysql数据库

酱紫啊。。好吧，结贴吧
天天就知道打酱油打酱油，有点出息行么。QQ:497923435
点评回复 支持 反对

使用道具 举报

返回列表 发新帖 回复
高级模式
B Color Image Link Quote Code Smilies |上传

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-5-5 01:30 , Processed in 0.078035 second(s), 26 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表