流程列表获取不到bizData的数据

波斯大香蕉

新建了一个流程，流程列表页获取不到bizData的数据，但是数据库里面是有数据的。绑定好了表autoLoad也设置了true。

jishuang

process组件的autoFilter设置为false

波斯大香蕉

jishuang 发表于 2017-3-13 16:29
process组件的autoFilter设置为false

设置了之后就报错了
2017-03-13 21:14:49 excute stream action, params:{"accept":"application/json","action":"queryAP_YPSQZBAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"AP_YPSQZB,FBZ,FCJR,FCJSJ,FDJZT,FFYX,FKH,FKHID,FSDF,FSPR,FSPSJ,FSQDH,FSQR,FSQSJ,FYQDHRQ,version","limit":20,"offset":0,"variables":{}},"process":"/apply/apply/process/apply/applyProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"AP_YPSQZB","sequence":"AP_YPSQZB,FBZ,FCJR,FCJSJ,FDJZT,FFYX,FKH,FKHID,FSDF,FSPR,FSPSJ,FSQDH,FSQR,FSQSJ,FYQDHRQ,version"},"transformIdcolumn":true,"useNamespace":true}}
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: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT AP_YPSQZB.*  FROM AP_YPSQZB AP_YPSQZB LIMIT 0, 20
--> sql: SELECT  AP_YPSQZB.fID AS AP_YPSQZB, AP_YPSQZB.FBZ AS FBZ, AP_YPSQZB.FCJR AS FCJR, AP_YPSQZB.FCJSJ AS FCJSJ, AP_YPSQZB.FDJZT AS FDJZT, AP_YPSQZB.FFYX AS FFYX, AP_YPSQZB.FKH AS FKH, AP_YPSQZB.FKHID AS FKHID, AP_YPSQZB.FSDF AS FSDF, AP_YPSQZB.FSPR AS FSPR, AP_YPSQZB.FSPSJ AS FSPSJ, AP_YPSQZB.FSQDH AS FSQDH, AP_YPSQZB.FSQR AS FSQR, AP_YPSQZB.FSQSJ AS FSQSJ, AP_YPSQZB.FYQDHRQ AS FYQDHRQ, AP_YPSQZB.VERSION AS version FROM AP_YPSQZB AP_YPSQZB
--> binds: []
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 27 more
Caused by: java.lang.IllegalArgumentException
        at java.sql.Date.valueOf(Date.java:143)
        at oracle.jdbc.driver.CharCommonAccessor.getDate(CharCommonAccessor.java:410)
        at oracle.jdbc.driver.OracleResultSetImpl.getDate(OracleResultSetImpl.java:737)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
        at com.justep.system.data.impl.TableUtilsImplement.fillRow(Unknown Source)
        ... 32 more

jishuang

用的是标准的queryAction吗？
到数据库中执行
SELECT  AP_YPSQZB.fID AS AP_YPSQZB, AP_YPSQZB.FBZ AS FBZ, AP_YPSQZB.FCJR AS FCJR, AP_YPSQZB.FCJSJ AS FCJSJ, AP_YPSQZB.FDJZT AS FDJZT, AP_YPSQZB.FFYX AS FFYX, AP_YPSQZB.FKH AS FKH, AP_YPSQZB.FKHID AS FKHID, AP_YPSQZB.FSDF AS FSDF, AP_YPSQZB.FSPR AS FSPR, AP_YPSQZB.FSPSJ AS FSPSJ, AP_YPSQZB.FSQDH AS FSQDH, AP_YPSQZB.FSQR AS FSQR, AP_YPSQZB.FSQSJ AS FSQSJ, AP_YPSQZB.FYQDHRQ AS FYQDHRQ, AP_YPSQZB.VERSION AS version FROM AP_YPSQZB AP_YPSQZB
报错吗？

波斯大香蕉

jishuang 发表于 2017-3-14 11:07
用的是标准的queryAction吗？
到数据库中执行
SELECT  AP_YPSQZB.fID AS AP_YPSQZB, AP_YPSQZB.FBZ AS FBZ, ...

对，用标准的，可是开始的时候就执行吗？我是写在了流程申请的那个地方onAfterAdvance。

波斯大香蕉

jishuang 发表于 2017-3-14 11:07
用的是标准的queryAction吗？
到数据库中执行
SELECT  AP_YPSQZB.fID AS AP_YPSQZB, AP_YPSQZB.FBZ AS FBZ, ...

是一开始用到这个表了，就开始启用这个方法？

波斯大香蕉

jishuang 发表于 2017-3-14 11:07
用的是标准的queryAction吗？
到数据库中执行
SELECT  AP_YPSQZB.fID AS AP_YPSQZB, AP_YPSQZB.FBZ AS FBZ, ...

流程的每个页面不一样，不影响吧？

jishuang

不影响

写在了流程申请的那个地方onAfterAdvance什么意思？

波斯大香蕉

jishuang 发表于 2017-3-14 13:33
不影响

写在了流程申请的那个地方onAfterAdvance什么意思？

// 单据状态
        public static void businessActivity1AfterAdvance() {
                String key = ProcessUtils.getProcessData1();
                String ksql = "update AP_YPSQZB sq set sq.FDJZT = '待审批' where sq = '" + key + "'";
                KSQL.executeUpdate(ksql, null, "/apply/apply/data", null);
        }

jishuang

报错的是select不是update

把这段去掉就不报错了？