软件包不存在错误

james

在人力资源--系统工具中，点击“HR组织初始化”按钮，报如下错误：

该错误在新建组织机构处，也有出现。

lixin_justep

检查路径model\BIZ\HR\systools\logic\code\dsrc下是否有HRSysTools.java文件，如果有，就重新编译一下

james

重新编译后，人力资源--系统工具中，点击“HR组织初始化”按钮，报如下错误：

lixin_justep

james 发表于 2013-12-5 13:37
重新编译后，人力资源--系统工具中，点击“HR组织初始化”按钮，报如下错误：
...

请帖一下控制台详细内容

james

initHROrgBySys->regenerateSAOrgURL
regenerateSAOrgURL->sqlClearURL: update SA_OPOrg o set  o.sFID = 'null', o.sFCode = 'null',  o.sFName = 'null', o.version =  o.version + 1
2013-12-06 09:20:03 invokeActions error！
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:update SA_OPOrg  o  set o.sFID = 'null', o.sFCode = 'null', o.sFName = 'null'  where  o.sParent in (select b from SA_OPOrg b where  b.sFID ='null')时出错！
        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 x5hr.utils.SysOrgURL.regenerateSAOrgURL(SysOrgURL.java:81)
        at x5hr.utils.SysOrgURL.regenerateSAOrgURL(SysOrgURL.java:24)
        at x5hr.utils.HROrgInit.initHROrgBySys(HROrgInit.java:24)
        at HRSysTools.initHROrg(HRSysTools.java:8)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：UPDATE SA_OPOrg SET SA_OPOrg.sFID = ?, SA_OPOrg.SFCODE = ?, SA_OPOrg.sFName = ?  WHERE SA_OPOrg.sParent IN (SELECT  b.sID FROM SA_OPOrg b  WHERE b.sFID = ?), binds:[null, null, null, null]出错！
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 35 more
Caused by: java.sql.SQLException: You can't specify target table 'SA_OPOrg' for update in FROM clause
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 36 more
2013-12-06 09:20:03 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/HR/systools/process/systools/systoolsProcess" activity="systoolsActivity" action-flag="__action_0__" executor="" execute-context="" name="InitHROrgAction">undefined</action>
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
        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:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        ... 21 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:update SA_OPOrg  o  set o.sFID = 'null', o.sFCode = 'null', o.sFName = 'null'  where  o.sParent in (select b from SA_OPOrg b where  b.sFID ='null')时出错！
        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 x5hr.utils.SysOrgURL.regenerateSAOrgURL(SysOrgURL.java:81)
        at x5hr.utils.SysOrgURL.regenerateSAOrgURL(SysOrgURL.java:24)
        at x5hr.utils.HROrgInit.initHROrgBySys(HROrgInit.java:24)
        at HRSysTools.initHROrg(HRSysTools.java:8)
        ... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：UPDATE SA_OPOrg SET SA_OPOrg.sFID = ?, SA_OPOrg.SFCODE = ?, SA_OPOrg.sFName = ?  WHERE SA_OPOrg.sParent IN (SELECT  b.sID FROM SA_OPOrg b  WHERE b.sFID = ?), binds:[null, null, null, null]出错！
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 35 more
Caused by: java.sql.SQLException: You can't specify target table 'SA_OPOrg' for update in FROM clause
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 36 more

lixin_justep

james 发表于 2013-12-6 09:19
initHROrgBySys->regenerateSAOrgURL
regenerateSAOrgURL->sqlClearURL: update SA_OPOrg o set  o.sFID =  ...

数据源连接正常吗

james

数据源连接正常，因为别的功能是可以使用的。

james

等回复

lixin_justep

james 发表于 2013-12-9 09:05
等回复

远程看一下，739066752

lixin_justep

lixin_justep 发表于 2013-12-9 09:38
远程看一下，739066752

已远程，hr目前只支持oracle数据库