执行个人委托报错，怎么处理

lyqjkl

执行KSQL出错, KSQL: INSERT INTO SA_OPAgent SA_OPAgent(SA_OPAgent, SA_OPAgent.version, SA_OPAgent.sOrgFID, SA_OPAgent.sOrgFName, SA_OPAgent.sAgentID, SA_OPAgent.sStartTime, SA_OPAgent.sFinishTime, SA_OPAgent.sProcess, SA_OPAgent.sValidState, SA_OPAgent.sCreatorID, SA_OPAgent.sCreatorName, SA_OPAgent.sCreateTime, SA_OPAgent.sCanTranAgent) VALUES (:SA_OPAgent, :version, :sOrgFID, :sOrgFName, :sAgentID, :sStartTime, :sFinishTime, :sProcess, :sValidState, :sCreatorID, :sCreatorName, :sCreateTime, :sCanTranAgent),保存数据失败！
编码：JUSTEP150210
隐藏详细
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
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:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO SA_OPAgent SA_OPAgent(SA_OPAgent, SA_OPAgent.version, SA_OPAgent.sOrgFID, SA_OPAgent.sOrgFName, SA_OPAgent.sAgentID, SA_OPAgent.sStartTime, SA_OPAgent.sFinishTime, SA_OPAgent.sProcess, SA_OPAgent.sValidState, SA_OPAgent.sCreatorID, SA_OPAgent.sCreatorName, SA_OPAgent.sCreateTime, SA_OPAgent.sCanTranAgent) VALUES (:SA_OPAgent, :version, :sOrgFID, :sOrgFName, :sAgentID, :sStartTime, :sFinishTime, :sProcess, :sValidState, :sCreatorID, :sCreatorName, :sCreateTime, :sCanTranAgent)
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.impl.TableImpl.save(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.opm.api.AgentHelper.appendAgent(Unknown Source)
at AgentProcedure.saveOPAgent(AgentProcedure.java:51)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_OPAgent (SA_OPAgent.sID, SA_OPAgent.VERSION, SA_OPAgent.SORGFID, SA_OPAgent.SORGFNAME, SA_OPAgent.SAGENTID, SA_OPAgent.SSTARTTIME, SA_OPAgent.SFINISHTIME, SA_OPAgent.SPROCESS, SA_OPAgent.SVALIDSTATE, SA_OPAgent.SCREATORID, SA_OPAgent.SCREATORNAME, SA_OPAgent.SCREATETIME, SA_OPAgent.SCANTRANAGENT) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds: [F50FF4F8C4B4498D9FC5096D3CDD018E, 0, /4949C5F3B9C14F8BA72192CD6CEEE640.ogn/2EEB5DF465E44B23B9DBB66E3D906C27.dpt/A64AF46A072D4A848E4A54AC16319F5B.dpt/2D40796F9E424F44A799BB356386ABB2.pos/D0E6E313030A479D9156ADA24B6B9021@2D40796F9E424F44A799BB356386ABB2.psm, /奥米非克/人事部/人事组/专员/朱文雅, 8BE3F9A9359042D4B099E07965326408, 2015-10-26 17:42:21.078, 2015-10-30 17:42:25.275, <data><r l="001员工">30E4E2E3091749A487C8626E712436B2</r><p s="1">/SA/task/taskView/taskViewProcess</p><p s="1">/SA/task/taskCenter/taskCenterProcess</p><p s="1">/SA/task/remind/remindProcess</p></data>, 1, D0E6E313030A479D9156ADA24B6B9021, 朱文雅, 2015-10-26 17:43:31.918, 0]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 39 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SPROCESS' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
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)
... 40 more
关闭

jishuang

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SPROCESS' at row 1
数据库中的字段长度不够了，把数据库的字段长度改大点