HR组织路径重构,却报错

cnjszd

这里,人力资源管理系统中,HR组织初始化,成功,但HR组织路径重构,却报错,如图所示,请教下如何解决,谢谢

lixin_justep

是下载的最新资源吗？在线测试没有出现这个问题，把报错的详细贴一下

cnjszd

贴着呢,就这个,是最新的,我前天才下载的

lixin_justep

cnjszd 发表于 2013-9-18 09:18
贴着呢,就这个,是最新的,我前天才下载的

是点开详细，帖详细里的内容

cnjszd

详细内容如下：

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 HR_EP_Pluralism p set p.fFID = (select concat((select o.fFID from HR_OG_OrgPosition o where o = p.fPositionID), '/' , (select e from HR_EP_Employee e where e = p.fMasterID), '.psm') from HR_EP_Pluralism pp), p.fFCode = (select concat((select o.fFCode from HR_OG_OrgPosition o where o = p.fPositionID) , '/' , (select e.fCode from HR_EP_Employee e where e = p.fMasterID)) from HR_EP_Pluralism pp), p.fFName = (select concat((select o.fFName from HR_OG_OrgPosition o where o = p.fPositionID), '/' , (select e.fName from HR_EP_Employee e where e = p.fMasterID)) from HR_EP_Pluralism pp) where p.fPositionID is not 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.HROrgURL.regenerateHRPluralismURLByFilter(HROrgURL.java:312)
at x5hr.utils.HROrgURL.regenerateHRPluralismURLByOrgURLs(HROrgURL.java:331)
at x5hr.utils.HROrgURL.regenerateHROrgURL(HROrgURL.java:24)
at HRSysTools.regenerateHRURL(HRSysTools.java:20)
... 26 more
Caused by: com.justep.model.exception.ModelException: 执行sql：UPDATE HR_EP_Pluralism SET HR_EP_Pluralism.FFID = (SELECT (SELECT o.FFID AS fFID FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.fID FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) + ? FROM HR_EP_Pluralism pp), HR_EP_Pluralism.FFCODE = (SELECT (SELECT o.FFCODE AS fFCode FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.FCODE AS fCode FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) FROM HR_EP_Pluralism pp), HR_EP_Pluralism.FFNAME = (SELECT (SELECT o.FFNAME AS fFName FROM HR_OG_OrgPosition o WHERE o.fID = HR_EP_Pluralism.FPOSITIONID) + ? + (SELECT e.FNAME AS fName FROM HR_EP_Employee e WHERE e.fID = HR_EP_Pluralism.fMasterID) FROM HR_EP_Pluralism pp) WHERE HR_EP_Pluralism.FPOSITIONID IS NOT NULL, binds:[/, .psm, /, /]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 35 more
Caused by: java.sql.SQLException: 子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 36 more

url:/UI/system/service/common/bizAction.j
param:undefined
at (http://127.0.0.1:8080/x5/$v62d6e5ae49ef4edabd1be8acff3628d1/base/base.js?language=zh_CN:1)

lixin_justep

cnjszd 发表于 2013-9-29 15:08
详细内容如下：

com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetExcepti ...

检查一下hr组织机构的数据
查看下边两个表中的两个字段的数据是否重复
HR_OG_OrgPosition ： FFCODE  FFNAME

HR_EP_Employee ： FCODE  FNAME