HR机构管理中职位类别设置新增保存报错

ly201026

后台错误如下：

1. 
   
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:595)
    
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:592)
    
29.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
30.         ... 21 more
    
31. Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO HR_OG_PositionKind HR_OG_PositionKind(HR_OG_PositionKind, HR_OG_PositionKind.version, HR_OG_PositionKind.fUseStatusName, HR_OG_PositionKind.fSequence, HR_OG_PositionKind.fCode, HR_OG_PositionKind.fName, HR_OG_PositionKind.fDescription, HR_OG_PositionKind.fUseStatus, HR_OG_PositionKind.fParentCode, HR_OG_PositionKind.fLevel, HR_OG_PositionKind.fURL, HR_OG_PositionKind.fCreateOgnID, HR_OG_PositionKind.fCreateOgnName, HR_OG_PositionKind.fCreateDeptID, HR_OG_PositionKind.fCreateDeptName, HR_OG_PositionKind.fCreatePsnID, HR_OG_PositionKind.fCreatePsnName, HR_OG_PositionKind.fCreatePsnFID, HR_OG_PositionKind.fCreateTime, HR_OG_PositionKind.fUpdatePsnID, HR_OG_PositionKind.fUpdatePsnName, HR_OG_PositionKind.fUpdateTime) VALUES (:HR_OG_PositionKind, :version, :fUseStatusName, :fSequence, :fCode, :fName, :fDescription, :fUseStatus, :fParentCode, :fLevel, :fURL, :fCreateOgnID, :fCreateOgnName, :fCreateDeptID, :fCreateDeptName, :fCreatePsnID, :fCreatePsnName, :fCreatePsnFID, :fCreateTime, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime)时出错！
    
32.         at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
    
33.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(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.justep.system.data.impl.TableImpl.insert(Unknown Source)
    
37.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
    
38.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
    
39.         at com.justep.system.data.BizData.save(Unknown Source)
    
40.         at BizProcedure.save(BizProcedure.java:18)
    
41.         ... 26 more
    
42. Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO HR_OG_PositionKind (HR_OG_PositionKind.fID, HR_OG_PositionKind.VERSION, HR_OG_PositionKind.FUSESTATUSNAME, HR_OG_PositionKind.FSEQUENCE, HR_OG_PositionKind.FCODE, HR_OG_PositionKind.FNAME, HR_OG_PositionKind.FDESCRIPTION, HR_OG_PositionKind.FUSESTATUS, HR_OG_PositionKind.FPARENTCODE, HR_OG_PositionKind.FLEVEL, HR_OG_PositionKind.FURL, HR_OG_PositionKind.FCREATEOGNID, HR_OG_PositionKind.FCREATEOGNNAME, HR_OG_PositionKind.FCREATEDEPTID, HR_OG_PositionKind.FCREATEDEPTNAME, HR_OG_PositionKind.FCREATEPSNID, HR_OG_PositionKind.FCREATEPSNNAME, HR_OG_PositionKind.FCREATEPSNFID, HR_OG_PositionKind.FCREATETIME, HR_OG_PositionKind.FUPDATEPSNID, HR_OG_PositionKind.FUPDATEPSNNAME, HR_OG_PositionKind.FUPDATETIME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[B85B793FC8704031915928E26EEC7739, 0, 未启用, null, null, 未完成, null, 0, null, null, null, ORG01, 起步软件, null, null, PSN01, system, /ORG01.ogn/PSN01@ORG01.psm, 2013-10-12 10:03:31.324, PSN01, system, 2013-10-12 10:03:33.0]出错！
    
43.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
    
44.         ... 35 more
    
45. Caused by: java.sql.SQLException: 不能在具有唯一索引 'IDX_2061253224' 的对象 'dbo.HR_OG_PositionKind' 中插入重复键的行。
    
46.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
    
47.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
    
48.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
    
49.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
    
50.         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
    
51.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
    
52.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
    
53.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    
54.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    
55.         ... 36 more
    
56. 2013-10-12 10:03:34 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
    
57. <actions><action direct-execute="false" process="/TCERP/org/process/posKindSet/posKindSetProcess" activity="posKindSetActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="saveHR_OG_PositionKindAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="model">/TCERP/org/data</userdata><userdata name="id-column-name">HR_OG_PositionKind</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">HR_OG_PositionKind</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">HR_OG_PositionKind.fUseStatusName,HR_OG_PositionKind.fSequence,HR_OG_PositionKind.fCode,HR_OG_PositionKind.fName,HR_OG_PositionKind.fDescription,EXPRESS,HR_OG_PositionKind.version,HR_OG_PositionKind.fUseStatus,HR_OG_PositionKind.fParentCode,HR_OG_PositionKind.fLevel,HR_OG_PositionKind.fURL,HR_OG_PositionKind.fCreateOgnID,HR_OG_PositionKind.fCreateOgnName,HR_OG_PositionKind.fCreateDeptID,HR_OG_PositionKind.fCreateDeptName,HR_OG_PositionKind.fCreatePsnID,HR_OG_PositionKind.fCreatePsnName,HR_OG_PositionKind.fCreatePsnFID,HR_OG_PositionKind.fCreateTime,HR_OG_PositionKind.fUpdatePsnID,HR_OG_PositionKind.fUpdatePsnName,HR_OG_PositionKind.fUpdateTime</userdata><userdata name="relation-types">String,String,String,String,String,Object,Integer,String,String,Integer,String,String,String,String,String,String,String,String,DateTime,String,String,DateTime</userdata><userdata name="relation-alias">fUseStatusName,fSequence,fCode,fName,fDescription,space-column,version,fUseStatus,fParentCode,fLevel,fURL,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime</userdata><userdata name="sys.rowid">HR_OG_PositionKind</userdata><userdata name="sys.count">1</userdata><userdata name="concept">HR_OG_PositionKind</userdata><userdata name="concept-alias">HR_OG_PositionKind</userdata><userdata name="update-mode">whereVersion</userdata><row id="B85B793FC8704031915928E26EEC7739" original-id="undefined" selected="1"><userdata name="recordState">new</userdata><cell original-value="%E6%9C%AA%E5%90%AF%E7%94%A8" changed="1">%E6%9C%AA%E5%90%AF%E7%94%A8</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1">%E6%9C%AA%E5%AE%8C%E6%88%90</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="0">0</cell><cell changed="1" original-value="0">0</cell><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value="ORG01">ORG01</cell><cell changed="1" original-value="%E8%B5%B7%E6%AD%A5%E8%BD%AF%E4%BB%B6">%E8%B5%B7%E6%AD%A5%E8%BD%AF%E4%BB%B6</cell><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value="PSN01">PSN01</cell><cell changed="1" original-value="system">system</cell><cell changed="1" original-value="%2FORG01.ogn%2FPSN01%40ORG01.psm">%2FORG01.ogn%2FPSN01%40ORG01.psm</cell><cell changed="1" original-value="2013-10-12T10%3A03%3A31.324Z">2013-10-12T10%3A03%3A31.324Z</cell><cell changed="1" original-value="">PSN01</cell><cell changed="1" original-value="">system</cell><cell changed="1" original-value="2013-10-12T10%3A03%3A31.324Z">2013-10-12T10%3A03%3A33.000Z</cell></row></rows></xbiz:table></parameter></parameters></action></actions>
    
58. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
    
59.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
60.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
61.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
62.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
63.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
64.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
65.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
66.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
67.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
68.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
69.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
70.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
71.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
72.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
73.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
74.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
75.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
76.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
77.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
78.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
79.         at java.lang.Thread.run(Thread.java:595)
    
80. Caused by: java.lang.reflect.InvocationTargetException
    
81.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
82.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
83.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
84.         at java.lang.reflect.Method.invoke(Method.java:592)
    
85.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
86.         ... 21 more
    
87. Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO HR_OG_PositionKind HR_OG_PositionKind(HR_OG_PositionKind, HR_OG_PositionKind.version, HR_OG_PositionKind.fUseStatusName, HR_OG_PositionKind.fSequence, HR_OG_PositionKind.fCode, HR_OG_PositionKind.fName, HR_OG_PositionKind.fDescription, HR_OG_PositionKind.fUseStatus, HR_OG_PositionKind.fParentCode, HR_OG_PositionKind.fLevel, HR_OG_PositionKind.fURL, HR_OG_PositionKind.fCreateOgnID, HR_OG_PositionKind.fCreateOgnName, HR_OG_PositionKind.fCreateDeptID, HR_OG_PositionKind.fCreateDeptName, HR_OG_PositionKind.fCreatePsnID, HR_OG_PositionKind.fCreatePsnName, HR_OG_PositionKind.fCreatePsnFID, HR_OG_PositionKind.fCreateTime, HR_OG_PositionKind.fUpdatePsnID, HR_OG_PositionKind.fUpdatePsnName, HR_OG_PositionKind.fUpdateTime) VALUES (:HR_OG_PositionKind, :version, :fUseStatusName, :fSequence, :fCode, :fName, :fDescription, :fUseStatus, :fParentCode, :fLevel, :fURL, :fCreateOgnID, :fCreateOgnName, :fCreateDeptID, :fCreateDeptName, :fCreatePsnID, :fCreatePsnName, :fCreatePsnFID, :fCreateTime, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime)时出错！
    
88.         at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
    
89.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
    
90.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
    
91.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
    
92.         at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
    
93.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
    
94.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
    
95.         at com.justep.system.data.BizData.save(Unknown Source)
    
96.         at BizProcedure.save(BizProcedure.java:18)
    
97.         ... 26 more
    
98. Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO HR_OG_PositionKind (HR_OG_PositionKind.fID, HR_OG_PositionKind.VERSION, HR_OG_PositionKind.FUSESTATUSNAME, HR_OG_PositionKind.FSEQUENCE, HR_OG_PositionKind.FCODE, HR_OG_PositionKind.FNAME, HR_OG_PositionKind.FDESCRIPTION, HR_OG_PositionKind.FUSESTATUS, HR_OG_PositionKind.FPARENTCODE, HR_OG_PositionKind.FLEVEL, HR_OG_PositionKind.FURL, HR_OG_PositionKind.FCREATEOGNID, HR_OG_PositionKind.FCREATEOGNNAME, HR_OG_PositionKind.FCREATEDEPTID, HR_OG_PositionKind.FCREATEDEPTNAME, HR_OG_PositionKind.FCREATEPSNID, HR_OG_PositionKind.FCREATEPSNNAME, HR_OG_PositionKind.FCREATEPSNFID, HR_OG_PositionKind.FCREATETIME, HR_OG_PositionKind.FUPDATEPSNID, HR_OG_PositionKind.FUPDATEPSNNAME, HR_OG_PositionKind.FUPDATETIME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[B85B793FC8704031915928E26EEC7739, 0, 未启用, null, null, 未完成, null, 0, null, null, null, ORG01, 起步软件, null, null, PSN01, system, /ORG01.ogn/PSN01@ORG01.psm, 2013-10-12 10:03:31.324, PSN01, system, 2013-10-12 10:03:33.0]出错！
    
99.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
    
100.         ... 35 more
     
101. Caused by: java.sql.SQLException: 不能在具有唯一索引 'IDX_2061253224' 的对象 'dbo.HR_OG_PositionKind' 中插入重复键的行。
     
102.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
     
103.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
     
104.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
     
105.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
     
106.         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
     
107.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
     
108.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
     
109.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
110.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
111.         ... 36 more
     
112. 2013-10-12 10:04:53 invokeActions error！
     
113. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
     
114.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
     
115.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
     
116.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
     
117.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
     
118.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
     
119.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
     
120.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
     
121.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
     
122.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
     
123.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     
124.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     
125.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
     
126.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     
127.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
     
128.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
     
129.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     
130.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
     
131.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
     
132.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
     
133.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
     
134.         at java.lang.Thread.run(Thread.java:595)
     
135. Caused by: java.lang.reflect.InvocationTargetException
     
136.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     
137.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     
138.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     
139.         at java.lang.reflect.Method.invoke(Method.java:592)
     
140.         at com.justep.system.action.Engine.invokeActions(Native Method)
     
141.         ... 21 more
     
142. Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO HR_OG_PositionKind HR_OG_PositionKind(HR_OG_PositionKind, HR_OG_PositionKind.version, HR_OG_PositionKind.fUseStatusName, HR_OG_PositionKind.fSequence, HR_OG_PositionKind.fCode, HR_OG_PositionKind.fName, HR_OG_PositionKind.fDescription, HR_OG_PositionKind.fUseStatus, HR_OG_PositionKind.fParentCode, HR_OG_PositionKind.fLevel, HR_OG_PositionKind.fURL, HR_OG_PositionKind.fCreateOgnID, HR_OG_PositionKind.fCreateOgnName, HR_OG_PositionKind.fCreateDeptID, HR_OG_PositionKind.fCreateDeptName, HR_OG_PositionKind.fCreatePsnID, HR_OG_PositionKind.fCreatePsnName, HR_OG_PositionKind.fCreatePsnFID, HR_OG_PositionKind.fCreateTime, HR_OG_PositionKind.fUpdatePsnID, HR_OG_PositionKind.fUpdatePsnName, HR_OG_PositionKind.fUpdateTime) VALUES (:HR_OG_PositionKind, :version, :fUseStatusName, :fSequence, :fCode, :fName, :fDescription, :fUseStatus, :fParentCode, :fLevel, :fURL, :fCreateOgnID, :fCreateOgnName, :fCreateDeptID, :fCreateDeptName, :fCreatePsnID, :fCreatePsnName, :fCreatePsnFID, :fCreateTime, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime)时出错！
     
143.         at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
     
144.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
     
145.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
     
146.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
     
147.         at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
     
148.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
     
149.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
     
150.         at com.justep.system.data.BizData.save(Unknown Source)
     
151.         at BizProcedure.save(BizProcedure.java:18)
     
152.         ... 26 more
     
153. Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO HR_OG_PositionKind (HR_OG_PositionKind.fID, HR_OG_PositionKind.VERSION, HR_OG_PositionKind.FUSESTATUSNAME, HR_OG_PositionKind.FSEQUENCE, HR_OG_PositionKind.FCODE, HR_OG_PositionKind.FNAME, HR_OG_PositionKind.FDESCRIPTION, HR_OG_PositionKind.FUSESTATUS, HR_OG_PositionKind.FPARENTCODE, HR_OG_PositionKind.FLEVEL, HR_OG_PositionKind.FURL, HR_OG_PositionKind.FCREATEOGNID, HR_OG_PositionKind.FCREATEOGNNAME, HR_OG_PositionKind.FCREATEDEPTID, HR_OG_PositionKind.FCREATEDEPTNAME, HR_OG_PositionKind.FCREATEPSNID, HR_OG_PositionKind.FCREATEPSNNAME, HR_OG_PositionKind.FCREATEPSNFID, HR_OG_PositionKind.FCREATETIME, HR_OG_PositionKind.FUPDATEPSNID, HR_OG_PositionKind.FUPDATEPSNNAME, HR_OG_PositionKind.FUPDATETIME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[B85B793FC8704031915928E26EEC7739, 0, 未启用, null, null, 未完成, null, 0, null, null, null, ORG01, 起步软件, null, null, PSN01, system, /ORG01.ogn/PSN01@ORG01.psm, 2013-10-12 10:03:31.324, PSN01, system, 2013-10-12 10:03:33.0]出错！
     
154.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
     
155.         ... 35 more
     
156. Caused by: java.sql.SQLException: 不能在具有唯一索引 'IDX_2061253224' 的对象 'dbo.HR_OG_PositionKind' 中插入重复键的行。
     
157.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
     
158.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
     
159.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
     
160.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
     
161.         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
     
162.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
     
163.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
     
164.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
165.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
166.         ... 36 more
     
167. 2013-10-12 10:04:53 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
     
168. <actions><action direct-execute="false" process="/TCERP/org/process/posKindSet/posKindSetProcess" activity="posKindSetActivity" action-flag="__action_0__" executor="PSN01" execute-context="" name="saveHR_OG_PositionKindAction" accept="*/*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="model">/TCERP/org/data</userdata><userdata name="id-column-name">HR_OG_PositionKind</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">HR_OG_PositionKind</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">HR_OG_PositionKind.fUseStatusName,HR_OG_PositionKind.fSequence,HR_OG_PositionKind.fCode,HR_OG_PositionKind.fName,HR_OG_PositionKind.fDescription,EXPRESS,HR_OG_PositionKind.version,HR_OG_PositionKind.fUseStatus,HR_OG_PositionKind.fParentCode,HR_OG_PositionKind.fLevel,HR_OG_PositionKind.fURL,HR_OG_PositionKind.fCreateOgnID,HR_OG_PositionKind.fCreateOgnName,HR_OG_PositionKind.fCreateDeptID,HR_OG_PositionKind.fCreateDeptName,HR_OG_PositionKind.fCreatePsnID,HR_OG_PositionKind.fCreatePsnName,HR_OG_PositionKind.fCreatePsnFID,HR_OG_PositionKind.fCreateTime,HR_OG_PositionKind.fUpdatePsnID,HR_OG_PositionKind.fUpdatePsnName,HR_OG_PositionKind.fUpdateTime</userdata><userdata name="relation-types">String,String,String,String,String,Object,Integer,String,String,Integer,String,String,String,String,String,String,String,String,DateTime,String,String,DateTime</userdata><userdata name="relation-alias">fUseStatusName,fSequence,fCode,fName,fDescription,space-column,version,fUseStatus,fParentCode,fLevel,fURL,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreateTime,fUpdatePsnID,fUpdatePsnName,fUpdateTime</userdata><userdata name="sys.rowid">HR_OG_PositionKind</userdata><userdata name="sys.count">1</userdata><userdata name="concept">HR_OG_PositionKind</userdata><userdata name="concept-alias">HR_OG_PositionKind</userdata><userdata name="update-mode">whereVersion</userdata><row id="B85B793FC8704031915928E26EEC7739" original-id="undefined" selected="1"><userdata name="recordState">new</userdata><cell original-value="%E6%9C%AA%E5%90%AF%E7%94%A8" changed="1">%E6%9C%AA%E5%90%AF%E7%94%A8</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1">%E6%9C%AA%E5%AE%8C%E6%88%90</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="0">0</cell><cell changed="1" original-value="0">0</cell><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value="ORG01">ORG01</cell><cell changed="1" original-value="%E8%B5%B7%E6%AD%A5%E8%BD%AF%E4%BB%B6">%E8%B5%B7%E6%AD%A5%E8%BD%AF%E4%BB%B6</cell><cell changed="1" original-value=""/><cell changed="1" original-value=""/><cell changed="1" original-value="PSN01">PSN01</cell><cell changed="1" original-value="system">system</cell><cell changed="1" original-value="%2FORG01.ogn%2FPSN01%40ORG01.psm">%2FORG01.ogn%2FPSN01%40ORG01.psm</cell><cell changed="1" original-value="2013-10-12T10%3A03%3A31.324Z">2013-10-12T10%3A03%3A31.324Z</cell><cell changed="1" original-value="">PSN01</cell><cell changed="1" original-value="">system</cell><cell changed="1" original-value="2013-10-12T10%3A03%3A31.324Z">2013-10-12T10%3A03%3A33.000Z</cell></row></rows></xbiz:table></parameter></parameters></action></actions>
     
169. com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
     
170.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
     
171.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
     
172.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
     
173.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
     
174.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
     
175.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
     
176.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
     
177.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
     
178.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
     
179.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     
180.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     
181.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
     
182.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     
183.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
     
184.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
     
185.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     
186.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
     
187.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
     
188.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
     
189.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
     
190.         at java.lang.Thread.run(Thread.java:595)
     
191. Caused by: java.lang.reflect.InvocationTargetException
     
192.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     
193.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     
194.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     
195.         at java.lang.reflect.Method.invoke(Method.java:592)
     
196.         at com.justep.system.action.Engine.invokeActions(Native Method)
     
197.         ... 21 more
     
198. Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO HR_OG_PositionKind HR_OG_PositionKind(HR_OG_PositionKind, HR_OG_PositionKind.version, HR_OG_PositionKind.fUseStatusName, HR_OG_PositionKind.fSequence, HR_OG_PositionKind.fCode, HR_OG_PositionKind.fName, HR_OG_PositionKind.fDescription, HR_OG_PositionKind.fUseStatus, HR_OG_PositionKind.fParentCode, HR_OG_PositionKind.fLevel, HR_OG_PositionKind.fURL, HR_OG_PositionKind.fCreateOgnID, HR_OG_PositionKind.fCreateOgnName, HR_OG_PositionKind.fCreateDeptID, HR_OG_PositionKind.fCreateDeptName, HR_OG_PositionKind.fCreatePsnID, HR_OG_PositionKind.fCreatePsnName, HR_OG_PositionKind.fCreatePsnFID, HR_OG_PositionKind.fCreateTime, HR_OG_PositionKind.fUpdatePsnID, HR_OG_PositionKind.fUpdatePsnName, HR_OG_PositionKind.fUpdateTime) VALUES (:HR_OG_PositionKind, :version, :fUseStatusName, :fSequence, :fCode, :fName, :fDescription, :fUseStatus, :fParentCode, :fLevel, :fURL, :fCreateOgnID, :fCreateOgnName, :fCreateDeptID, :fCreateDeptName, :fCreatePsnID, :fCreatePsnName, :fCreatePsnFID, :fCreateTime, :fUpdatePsnID, :fUpdatePsnName, :fUpdateTime)时出错！
     
199.         at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
     
200.         at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
     
201.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
     
202.         at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
     
203.         at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
     
204.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
     
205.         at com.justep.system.data.impl.TableImpl.save(Unknown Source)
     
206.         at com.justep.system.data.BizData.save(Unknown Source)
     
207.         at BizProcedure.save(BizProcedure.java:18)
     
208.         ... 26 more
     
209. Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO HR_OG_PositionKind (HR_OG_PositionKind.fID, HR_OG_PositionKind.VERSION, HR_OG_PositionKind.FUSESTATUSNAME, HR_OG_PositionKind.FSEQUENCE, HR_OG_PositionKind.FCODE, HR_OG_PositionKind.FNAME, HR_OG_PositionKind.FDESCRIPTION, HR_OG_PositionKind.FUSESTATUS, HR_OG_PositionKind.FPARENTCODE, HR_OG_PositionKind.FLEVEL, HR_OG_PositionKind.FURL, HR_OG_PositionKind.FCREATEOGNID, HR_OG_PositionKind.FCREATEOGNNAME, HR_OG_PositionKind.FCREATEDEPTID, HR_OG_PositionKind.FCREATEDEPTNAME, HR_OG_PositionKind.FCREATEPSNID, HR_OG_PositionKind.FCREATEPSNNAME, HR_OG_PositionKind.FCREATEPSNFID, HR_OG_PositionKind.FCREATETIME, HR_OG_PositionKind.FUPDATEPSNID, HR_OG_PositionKind.FUPDATEPSNNAME, HR_OG_PositionKind.FUPDATETIME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds:[B85B793FC8704031915928E26EEC7739, 0, 未启用, null, null, 未完成, null, 0, null, null, null, ORG01, 起步软件, null, null, PSN01, system, /ORG01.ogn/PSN01@ORG01.psm, 2013-10-12 10:03:31.324, PSN01, system, 2013-10-12 10:03:33.0]出错！
     
210.         at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
     
211.         ... 35 more
     
212. Caused by: java.sql.SQLException: 不能在具有唯一索引 'IDX_2061253224' 的对象 'dbo.HR_OG_PositionKind' 中插入重复键的行。
     
213.         at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
     
214.         at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
     
215.         at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
     
216.         at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
     
217.         at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
     
218.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
     
219.         at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
     
220.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
221.         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
     
222.         ... 36 more
     

复制代码

我看了下错误，索引设置了唯一性，也就是fCreatePsnFID字段唯一性，但是不知道怎么这个字段是自动生成的值都是/ORG01.ogn/PSN01@ORG01.psm，不知道是不是平台的BUG

lixin_justep

这个表的唯一索引是fID，不是fCreatePsnFID，楼主是下载的数据库还是执行的脚本？

ly201026

lixin_justep 发表于 2013-10-12 11:21
这个表的唯一索引是fID，不是fCreatePsnFID，楼主是下载的数据库还是执行的脚本？ ...

我是到数据库里面看的，我把唯一去掉后就没问题了。还有概念文件里面也是设置的唯一

lixin_justep

ly201026 发表于 2013-10-12 11:59
我是到数据库里面看的，我把唯一去掉后就没问题了。还有概念文件里面也是设置的唯一 ...

这里设成唯一是有问题，多谢楼主

ly201026

lixin_justep 发表于 2013-10-12 12:10
这里设成唯一是有问题，多谢楼主

那这个设置是要去掉是吧

ly201026

lixin_justep 发表于 2013-10-12 12:10
这里设成唯一是有问题，多谢楼主

HR_OG_PositionLevel这个表的设置也是一样的。