|
|
之前挺好的没问题，最近新增出现问题 新增时点击保存出现以下的错误。
[tr][td]编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO XMSX XMSX(XMSX, XMSX.version, XMSX.YUSBH, XMSX.YSBH, XMSX.XMMC, XMSX.XMLX, XMSX.JHND, XMSX.YSND, XMSX.JHJSZGM, XMSX.SJJSZGM, XMSX.SJXZGDMJ, XMSX.JHZTZ, XMSX.SJZTZ, XMSX.XMID, XMSX.XMFSMC, XMSX.XMWZ, XMSX.SFSCSL, XMSX.BZ, XMSX.operateName, XMSX.createDate, XMSX.updateDate) VALUES (:XMSX, :version, :YUSBH, :YSBH, :XMMC, :XMLX, :JHND, :YSND, :JHJSZGM, :SJJSZGM, :SJXZGDMJ, :JHZTZ, :SJZTZ, :XMID, :XMFSMC, :XMWZ, :SFSCSL, :BZ,  perateName, :createDate, :updateDate)
编码: JUSTEP150039; 提示: 执行sql: INSERT INTO XMSX (XMSX.XMID, XMSX.VERSION, XMSX.YUSBH, XMSX.YSBH, XMSX.XMMC, XMSX.XMLX, XMSX.JHND, XMSX.YSND, XMSX.JHJSZGM, XMSX.SJJSZGM, XMSX.SJXZGDMJ, XMSX.JHZTZ, XMSX.SJZTZ, XMSX.XMID, XMSX.XMFSMC, XMSX.XMWZ, XMSX.SFSCSL, XMSX.BZ, XMSX.OPERATENAME, XMSX.CREATEDATE, XMSX.UPDATEDATE) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [6BC4B32B69BE4676B4D9B2A08CCC7646, 0, , , , , , , null, null, null, null, null, , , , , , test, 2017-08-03 10:15:06.01, 2017-08-03 10:15:06.011]出错
Column 'XMID' specified twice
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)
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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO XMSX XMSX(XMSX, XMSX.version, XMSX.YUSBH, XMSX.YSBH, XMSX.XMMC, XMSX.XMLX, XMSX.JHND, XMSX.YSND, XMSX.JHJSZGM, XMSX.SJJSZGM, XMSX.SJXZGDMJ, XMSX.JHZTZ, XMSX.SJZTZ, XMSX.XMID, XMSX.XMFSMC, XMSX.XMWZ, XMSX.SFSCSL, XMSX.BZ, XMSX.operateName, XMSX.createDate, XMSX.updateDate) VALUES (:XMSX, :version, :YUSBH, :YSBH, :XMMC, :XMLX, :JHND, :YSND, :JHJSZGM, :SJJSZGM, :SJXZGDMJ, :JHZTZ, :SJZTZ, :XMID, :XMFSMC, :XMWZ, :SFSCSL, :BZ, perateName, :createDate, :updateDate)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(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.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at BizProcedure.save(BizProcedure.java:17)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO XMSX (XMSX.XMID, XMSX.VERSION, XMSX.YUSBH, XMSX.YSBH, XMSX.XMMC, XMSX.XMLX, XMSX.JHND, XMSX.YSND, XMSX.JHJSZGM, XMSX.SJJSZGM, XMSX.SJXZGDMJ, XMSX.JHZTZ, XMSX.SJZTZ, XMSX.XMID, XMSX.XMFSMC, XMSX.XMWZ, XMSX.SFSCSL, XMSX.BZ, XMSX.OPERATENAME, XMSX.CREATEDATE, XMSX.UPDATEDATE) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [6BC4B32B69BE4676B4D9B2A08CCC7646, 0, , , , , , , null, null, null, null, null, , , , , , test, 2017-08-03 10:15:06.01, 2017-08-03 10:15:06.011]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 35 more
Caused by: java.sql.SQLException: Column 'XMID' specified twice
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
url:/UI/system/service/common/bizAction.j
param:{"process":"/LandRenovation/ProjectList/process/projet/projetProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"saveXMSXAction","parameters":{"table":{"@type":"table","userdata":{"relationAlias":"calculate0,YUSBH,YSBH,XMMC,XMLX,JHND,YSND,JHJSZGM,SJJSZGM,SJXZGDMJ,JHZTZ,SJZTZ,calculate2,space-column,version,XMID,XMFSMC,XMWZ,SFSCSL,BZ,operateName,createDate,updateDate","relationTypes":"Object,String,String,String,String,String,String,Decimal,Decimal,Decimal,Decimal,Decimal,Object,Object,Integer,String,String,String,String,String,String,DateTime,DateTime","idColumnType":"String","sys.rowid":"XMSX","idColumnDefine":"XMSX","idColumnName":"XMSX","sys.count":2,"relations":"EXPRESS,XMSX.YUSBH,XMSX.YSBH,XMSX.XMMC,XMSX.XMLX,XMSX.JHND,XMSX.YSND,XMSX.JHJSZGM,XMSX.SJJSZGM,XMSX.SJXZGDMJ,XMSX.JHZTZ,XMSX.SJZTZ,EXPRESS,EXPRESS,XMSX.version,XMSX.XMID,XMSX.XMFSMC,XMSX.XMWZ,XMSX.SFSCSL,XMSX.BZ,XMSX.operateName,XMSX.createDate,XMSX.updateDate","model":"/LandRenovation/ProjectList/data","updateMode":"whereVersion","concept":"XMSX","conceptAlias":"XMSX"},"rows":[{"userdata":{"id":{"value":"6BC4B32B69BE4676B4D9B2A08CCC7646","originalValue":null,"changed":null},"recordState":"new"},"calculate0":{"value":"3","originalValue":"","changed":"0"},"YUSBH":{"value":"","originalValue":"","changed":"1"},"YSBH":{"value":"","originalValue":"","changed":"1"},"XMMC":{"value":"","originalValue":"","changed":"1"},"XMLX":{"value":"","originalValue":"","changed":"1"},"JHND":{"value":"","originalValue":"","changed":"1"},"YSND":{"value":"","originalValue":"","changed":"1"},"JHJSZGM":{"value":"","originalValue":"","changed":"1"},"SJJSZGM":{"value":"","originalValue":"","changed":"1"},"SJXZGDMJ":{"value":"","originalValue":"","changed":"1"},"JHZTZ":{"value":"","originalValue":"","changed":"1"},"SJZTZ":{"value":"","originalValue":"","changed":"1"},"calculate2":{"value":"","originalValue":"","changed":"0"},"space-column":{"value":"","originalValue":"","changed":"1"},"version":{"value":0,"originalValue":0,"changed":"0"},"XMID":{"value":"","originalValue":"","changed":"1"},"XMFSMC":{"value":"","originalValue":"","changed":"1"},"XMWZ":{"value":"","originalValue":"","changed":"1"},"SFSCSL":{"value":"","originalValue":"","changed":"1"},"BZ":{"value":"","originalValue":"","changed":"1"},"operateName":{"value":"test","originalValue":"test","changed":"1"},"createDate":{"value":"2017-08-03T10:15:06.010Z","originalValue":"2017-08-03T10:15:06.010Z","changed":"1"},"updateDate":{"value":"2017-08-03T10:15:06.011Z","originalValue":"2017-08-03T10:15:06.011Z","changed":"1"}}]}},"translateParameter":null}
at (http://localhost:8080/x5/$va7548cab61224dcda43534f5f217e4b9/base/base.js?language=zh_CN:1)98289
[/td][/tr]
[/table] 提示
|
|
IP卡
狗仔卡
发表于 2017-8-3 10:18:21
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2017-8-3 10:58:38
楼主