编码: JUSTEP150210; 提示: 执行KSQL出错

一诺佳人

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select sContent as sContent from SA_Task where SA_Task='E9342ACC1AE041C9BF75E5E124FDD22D'
--> sql:
--> binds: []
[url=]隐藏详细[/url]
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.advanceProcess(Unknown Source) at ExternalProcessProcedure.advanceProcess(ExternalProcessProcedure.java:30) ... 27 more Caused by: java.lang.RuntimeException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select sContent as sContent from SA_Task where SA_Task='E9342ACC1AE041C9BF75E5E124FDD22D' --> sql:  --> binds: [] at InboundProcess.applyAfterAdvance(InboundProcess.java:45) ... 38 more


请问，这个怎么解释？
源码
//申请环节结束时 ，把采购计划的意见填写到库表中
        public static void applyAfterAdvance() {
        try{
        String taskID=ProcessUtils.getProcessContext().getTask().getId();   //拿到当前流程ID
        String ksql="select sContent as sContent from SA_Task  where SA_Task='"+taskID+"'";
        com.justep.system.data.Table table=KSQL.select(ksql, null, "/DEMOERP/DEMOERP/data", null);//查出当前流程记录
          Iterator<Row> rows=table.iterator();                                                  //拿到操作者意见
          Row row=rows.next();
          String sContent=row.getString("sContent");
        //如果操作者留下了附言，将附言记录到库表中
        if(sContent!=null){
             String key=ProcessUtils.getProcessData1();
             String ksql1="UPDATE articleMove articleMove SET articleMove.fReportAdvice ='"+sContent+"' where articleMove='"+key+"'";
             KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中
             }
                }catch(Exception e){
                throw new RuntimeException(e.getMessage());
                }
        }

一诺佳人

        public static void applyAfterAdvance() {
        try{
        String taskID=ProcessUtils.getProcessContext().getTask().getId();   //拿到当前流程ID
        String ksql = "select SA_Task.sContent as sContent from SA_Task SA_Task where SA_Task='"+taskID+"'";
        //String ksql = "select SA_Task.sContent as sContent from SA_Task SA_Task where SA_Task='"+taskID+"'";
        com.justep.system.data.Table table=KSQL.select(ksql, null, "/DEMOERP/DEMOERP/data", null);//查出当前流程记录
          Iterator<Row> rows=table.iterator();                                                  //拿到操作者意见
          Row row=rows.next();
          String sContent=row.getString("sContent");
        //如果操作者留下了附言，将附言记录到库表中
        if(sContent!=null){
             String key=ProcessUtils.getProcessData1();
             String ksql1="UPDATE articleMove articleMove SET articleMove.fReportAdvice ='"+sContent+"' where articleMove='"+key+"'";
             KSQL.executeUpdate(ksql1, null, "/DEMOERP/DEMOERP/data", null);//将操作者意见存进库表中
             }
                }catch(Exception e){
                throw new RuntimeException(e.getMessage());
                }
        }

我将KSQL里概念加了别名还是报错。
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SA_Task.sContent as sContent from SA_Task SA_Task where SA_Task='8B84C9D00D084E4B8DF35E616F29CD10'

一诺佳人

已经解决了。就是将com.justep.system.data.Table table=KSQL.select(ksql, null, "/DEMOERP/DEMOERP/data", null);//查出当前流程记录  里的"/DEMOERP/DEMOERP/data"换成"/system/data".就好了