js启动流程出错

RomynFang

TASK表字段长度问题，调整后就行了

按照帖子http://bbs.wex5.com/forum.php?mo ... tra=page%3D1&page=1的方式，用按钮控制流程启动，process设置：



按钮事件：
this.comp("process1").start(null, null, this.comp("mainData").getCurrentRowID(), null);
this.comp("process1").advanceQuery();




点击按钮后报错：
2016-05-27 12:41:02 excute stream action, params:{"actions":[{"accept":"application/json","action":"externalStartProcessAction","actionFlag":"__action_0__","activity":"rukudan_list1","contentType":"application/json","executeContext":"","executor":"","parameters":{"attributes":{"sData1":"0CBA01D2-FC8A-42F3-B156-F4B0E4FCCC2C"},"executor":"","process":"/JYFY/KuGuan/process/rukudan/rukudanProcess"},"process":"/JYFY/KuGuan/process/rukudan/rukudanProcess"}]}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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(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: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        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.ProcessUtils.startProcess(Unknown Source)
        at ExternalProcessProcedure.startProcess(ExternalProcessProcedure.java:21)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: insert into SA_Task i (i, i.sActivityNames, i.sLock, i.sExpectStartTime, i.sCreatorFID, i.sProcess, i.sStatusID, i.sActualStartTime, i.sCreatorPersonName, i.sCreateTime, i.sFlowID, i.sProcessName, i.sKindID, i.sStatusName, i.sCreatorFName, i.sCreatorPersonID, i.sName, i.sCreatorOgnName, i.sCreatorPosID, i.sLastModifyTime, i.sCatalogID, i.sCreatorDeptID, i.sData1, i.sTypeName, i.sCreatorOgnID, i.sExecutorNames, i.version) values ('1E4632688EC74374B3D47B6281822C27', :sActivityNames, :sLock, :sExpectStartTime, :sCreatorFID, :sProcess, :sStatusID, :sActualStartTime, :sCreatorPersonName, :sCreateTime, :sFlowID, :sProcessName, :sKindID, :sStatusName, :sCreatorFName, :sCreatorPersonID, :sName, :sCreatorOgnName, :sCreatorPosID, :sLastModifyTime, :sCatalogID, :sCreatorDeptID, :sData1, :sTypeName, :sCreatorOgnID, :sExecutorNames, 0)
        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.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.process.Task.doNew(Unknown Source)
        at com.justep.system.process.Individual.doSave(Unknown Source)
        at com.justep.system.process.Individual.save(Unknown Source)
        at com.justep.system.process.Task.save(Unknown Source)
        at com.justep.system.process.TaskEngine.commit(Unknown Source)
        at com.justep.system.process.ProcessEngine.commit(Unknown Source)
        at ProcessProcedure.startProcess(ProcessProcedure.java:192)
        ... 38 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_Task (SA_Task.sID, SA_Task.SACTIVITYNAMES, SA_Task.SLOCK, SA_Task.SEXPECTSTARTTIME, SA_Task.SCREATORFID, SA_Task.SPROCESS, SA_Task.SSTATUSID, SA_Task.SACTUALSTARTTIME, SA_Task.SCREATORPERSONNAME, SA_Task.SCREATETIME, SA_Task.SFLOWID, SA_Task.SPROCESSNAME, SA_Task.SKINDID, SA_Task.SSTATUSNAME, SA_Task.SCREATORFNAME, SA_Task.SCREATORPERSONID, SA_Task.SNAME, SA_Task.SCREATOROGNNAME, SA_Task.SCREATORPOSID, SA_Task.SLASTMODIFYTIME, SA_Task.SCATALOGID, SA_Task.SCREATORDEPTID, SA_Task.SDATA1, SA_Task.STYPENAME, SA_Task.SCREATOROGNID, SA_Task.SEXECUTORNAMES, SA_Task.VERSION) VALUES (?,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? , ?), binds: [1E4632688EC74374B3D47B6281822C27, 编辑入库单, 910086522A9C4CCEAED142785CD21DEE, 2016-05-27 12:41:02.582, /ORG01.ogn/PSN01@ORG01.psm, /JYFY/KuGuan/process/rukudan/rukudanProcess, tesExecuting, 2016-05-27 12:41:02.582, system, 2016-05-27 12:41:02.582, 1E4632688EC74374B3D47B6281822C27, 入库单, tkProcessInstance, 正在处理, /起步软件/system, PSN01, 入库单, 起步软件, , 2016-05-27 12:41:02.584, tsProcess, , 0CBA01D2-FC8A-42F3-B156-F4B0E4FCCC2C, 入库单, ORG01, system, 0]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 50 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: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)
        ... 51 more