流程结束时通知错误

gzcyp2000

有部分单据（大部分是正常的）在流程最后一步流转时弹出错误提示：

控制台信息：
        at com.justep.system.process.ProcessEngine.advance(Unknown Source)
        at ProcessProcedure.advanceProcess(ProcessProcedure.java:354)
        ... 36 more
Caused by: java.lang.RuntimeException: java.sql.DataTruncation: Data truncation        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.j
ava:147)
        ... 48 more
Caused by: java.sql.DataTruncation: Data truncation        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
        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:633)
        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.execute(JtdsPreparedStatement.java:478)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.java:144)
        ... 48 more
2018-01-09 13:09:59 excute stream action, params:{"actions":[{"accept":"application/json","action":"externalAdvanceProcessAction","actionFlag":"__action_0__","a
ctivity":"businessActivity1","contentType":"application/json","executeContext":"","executor":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/3koISC06WlYLBUHF5TP@iscnjSQ2kbc
goaSQ68l.psm","parameters":{"control":{"class":"com.justep.system.process.ProcessControl","object":{"@@tag":"process-control","customized-enabled":"false","dial
og-enabled":"true","jump-enabled":"false","message":"","notice":[{"@activity-id":"34D7DCCBBA3B42B3A5A270CF7122A3C4","@id":"34D7DCCBBA3B42B3A5A270CF7122A3C4","@i
s-end":"false","@readonly":"false","@selected":"true","executor-kinds":"","executor-range":[{"@@tag":"org-unit","fid":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/Qjy2nl
5D9cPyeYaX5Xu.dpt/SrrPLr6pCzLKijIs8Wf@Qjy2nl5D9cPyeYaX5Xu.psm","fname":"/杭州集美/业务部/九部(六)/楼红燕","responsible":"false"}],"executors":[{"@@tag":"org-un
it","fid":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/Qjy2nl5D9cPyeYaX5Xu.dpt/SrrPLr6pCzLKijIs8Wf@Qjy2nl5D9cPyeYaX5Xu.psm","fname":"/杭州集美/业务部/九部(六)/楼红燕","r
esponsible":false}],"process":"/jimay/order/process/orderReview/orderReviewProcess","task-assign-mode":"singleness","task-relation-value":{"@@tag":"task-relatio
n-value","SA_Task":"F36B1AC7742A476E88DE5225250EACB7","sActivityInTemplate":"end1","sActivityName":"","sCURL":"/jimay/order/process/orderReview/businessActivity
1.a","sCatalogID":"tsTask","sEURL":"/jimay/order/process/orderReview/businessActivity0.a","sExecuteMode":"temPreempt","sExecuteMode2":"finishWhenOpen","sKindID"
:"tkNotice","sLastModifyTime":"2018-01-09T13:09:58.216Z","sLock":"6DA3F6D6169C4E3F9B4445C43642DC78","sName":"【通知】订单评审完毕，生成《购销合同》：D1801-0218"
,"sPreemptMode":"tpmOpen","sProcess":"/jimay/order/process/orderReview/orderReviewProcess","sProcessName":"订单评审管理","sTypeName":"订单评审管理"},"template":
"","unit":"end1"}],"postscript":"","save-history":"true","status":"none","task-join":"false","task-join-mode":"tjmMultiple","to":[{"@activity-id":"044E33BCA0294
FFF820F76965E271BE4","@id":"044E33BCA0294FFF820F76965E271BE4","@is-end":"true","@readonly":"true","@selected":"true","executor-kinds":"","executor-range":[],"ex
ecutors":[],"process":"/jimay/order/process/orderReview/orderReviewProcess","task-relation-value":{"@@tag":"task-relation-value","SA_Task":"0DE21D900A274C938B72
77C719EE94A4","sActivityInTemplate":"end1","sActivityName":"","sLastModifyTime":"2018-01-09T13:09:58.212Z","sLock":"342E7B1C244147CDA2160F62046C4796","sProcess"
:"/jimay/order/process/orderReview/orderReviewProcess","sProcessName":"订单评审管理","sProcessTemplateID2":"","sTypeName":"订单评审管理"},"template":"","unit":
"end1"}]}},"task":"7FEEBACD906040FAADB09F474154B660"},"process":"/jimay/order/process/orderReview/orderReviewProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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(UnknownSource)
        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: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor264.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)

        at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)
        ... 26 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.doFinishPIAction(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.advance(Unknown Source)
        at ProcessProcedure.advanceProcess(ProcessProcedure.java:354)
        ... 36 more
Caused by: java.lang.RuntimeException: java.sql.DataTruncation: Data truncation
        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.java:147)
        ... 48 more
Caused by: java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
        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:633)
        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.execute(JtdsPreparedStatement.java:478)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.java:144)
        ... 48 more
2018-01-09 13:10:16 excute stream action, params:{"actions":[{"accept":"application/json","action":"externalAdvanceProcessAction","actionFlag":"__action_0__","a
ctivity":"businessActivity1","contentType":"application/json","executeContext":"","executor":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/3koISC06WlYLBUHF5TP@iscnjSQ2kbc
goaSQ68l.psm","parameters":{"control":{"class":"com.justep.system.process.ProcessControl","object":{"@@tag":"process-control","customized-enabled":"false","dial
og-enabled":"true","jump-enabled":"false","message":"","notice":[{"@activity-id":"9AFB531EB1124E6F9F32E35F4EF04E8C","@id":"9AFB531EB1124E6F9F32E35F4EF04E8C","@i
s-end":"false","@readonly":"false","@selected":"true","executor-kinds":"","executor-range":[{"@@tag":"org-unit","fid":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/Qjy2nl
5D9cPyeYaX5Xu.dpt/SrrPLr6pCzLKijIs8Wf@Qjy2nl5D9cPyeYaX5Xu.psm","fname":"/杭州集美/业务部/九部(六)/楼红燕","responsible":"false"}],"executors":[{"@@tag":"org-un
it","fid":"/ORG01.ogn/iscnjSQ2kbcgoaSQ68l.dpt/Qjy2nl5D9cPyeYaX5Xu.dpt/SrrPLr6pCzLKijIs8Wf@Qjy2nl5D9cPyeYaX5Xu.psm","fname":"/杭州集美/业务部/九部(六)/楼红燕","r
esponsible":false}],"process":"/jimay/order/process/orderReview/orderReviewProcess","task-assign-mode":"singleness","task-relation-value":{"@@tag":"task-relatio
n-value","SA_Task":"D1F19026033E4D179E1B5FDD3D1D3405","sActivityInTemplate":"end1","sActivityName":"","sCURL":"/jimay/order/process/orderReview/businessActivity
1.a","sCatalogID":"tsTask","sEURL":"/jimay/order/process/orderReview/businessActivity0.a","sExecuteMode":"temPreempt","sExecuteMode2":"finishWhenOpen","sKindID"
:"tkNotice","sLastModifyTime":"2018-01-09T13:10:15.019Z","sLock":"01379BB57A1A4253B8E4931C0895140C","sName":"【通知】订单评审完毕，生成《购销合同》：D1801-0222"
,"sPreemptMode":"tpmOpen","sProcess":"/jimay/order/process/orderReview/orderReviewProcess","sProcessName":"订单评审管理","sTypeName":"订单评审管理"},"template":
"","unit":"end1"}],"postscript":"","save-history":"true","status":"none","task-join":"false","task-join-mode":"tjmMultiple","to":[{"@activity-id":"8FD7879A6A594
5A0B3E3AF06694E55FC","@id":"8FD7879A6A5945A0B3E3AF06694E55FC","@is-end":"true","@readonly":"true","@selected":"true","executor-kinds":"","executor-range":[],"ex
ecutors":[],"process":"/jimay/order/process/orderReview/orderReviewProcess","task-relation-value":{"@@tag":"task-relation-value","SA_Task":"AB6520527A1D45339BD5
592EE94D2EF6","sActivityInTemplate":"end1","sActivityName":"","sLastModifyTime":"2018-01-09T13:10:15.016Z","sLock":"DA8AA5AB4B914C42BC3C3F207731D401","sProcess"
:"/jimay/order/process/orderReview/orderReviewProcess","sProcessName":"订单评审管理","sProcessTemplateID2":"","sTypeName":"订单评审管理"},"template":"","unit":
"end1"}]}},"task":"CF551D913E8F4865BCB7BA92692DA955"},"process":"/jimay/order/process/orderReview/orderReviewProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        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(UnknownSource)
        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: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor264.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.ProcessUtils.advanceProcess(Unknown Source)
        at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30)
        ... 26 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.doFinishPIAction(Unknown Source)
        at com.justep.system.process.AdvanceProcessEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.advance(Unknown Source)
        at ProcessProcedure.advanceProcess(ProcessProcedure.java:354)
        ... 36 more
Caused by: java.lang.RuntimeException: java.sql.DataTruncation: Data truncation
        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.java:147)
        ... 48 more
Caused by: java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
        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:633)
        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.execute(JtdsPreparedStatement.java:478)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at OrderReviewProcess.orderReviewProcessAfterFinish(OrderReviewProcess.java:144)
        ... 48 more

jishuang

http://docs.wex5.com/bex5-server-question-list-10005/

gzcyp2000

的确是这个原因，修改数据库表字段长度即解决。谢谢！结帖吧