页面保存出错

honeyscj

保存数据出错
http://bbs.wex5.com/forum.php?mod=viewthread&tid=213387
(出处: 起步软件技术论坛)

honeyscj

process下的sal_outstock_new文件

jishuang

先把process的动作设置中设置的保存前事件去掉看看

honeyscj

我注释了，还是报这个错，报这个错之前我也一直在用这个事件。

jishuang

把process组件上的autoStart先设置为false，只做保存看看，确认data的事件中是不是做了什么操作
看action定义应该没问题

honeyscj

还是报这个错

jishuang

确认data的事件中是不是做了什么操作
新建一个简单的列表页面bizData关联这个概念去操作看看报错吗?

honeyscj

使用表体的标准动作创建一个简单的列表页面打开会报错，
报错信息如下
2019-08-16 19:50:09 excute stream action, params:{"accept":"application/json","action":"querySal_outstock_entryAction","actionFlag":"__action_0__","activity":"test","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"Sal_outstock_entry,faddress_from,faddress_to,famount_stock_link,famount_tax,farea_from,farea_to,fcontact_from,fcontact_to,fdiscount,fentry_no,flocation_from,flocation_to,fmaster_id,fmaterial_id,fnote1,fnote2,fnote3,fnote4,forder_bill_no,forder_entry_id,fqty,fqty_order,fqty_pending,fqty_settle,fqty_ship_link,fqty_stock,fqty_stock_link,ftax,ftax_rate,ftel_from,ftel_to,funit_id,funitprice_tax,version","limit":20,"offset":0,"variables":{}},"process":"/ERP/sale/process/sal_outstock_new/sal_outstock_newProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"Sal_outstock_entry","sequence":"Sal_outstock_entry,calcCheckBox,faddress_from,faddress_to,famount_stock_link,famount_tax,farea_from,farea_to,fcontact_from,fcontact_to,fdiscount,fentry_no,flocation_from,flocation_to,fmaster_id,fmaterial_id,fnote1,fnote2,fnote3,fnote4,forder_bill_no,forder_entry_id,fqty,fqty_order,fqty_pending,fqty_settle,fqty_ship_link,fqty_stock,fqty_stock_link,ftax,ftax_rate,ftel_from,ftel_to,funit_id,funitprice_tax,version"},"transformIdcolumn":true,"useNamespace":true}}

honeyscj

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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        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 Sal_outstock_entry.*  FROM Sal_outstock_entry Sal_outstock_entry LIMIT 0, 20
--> sql:
--> 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)
        ... 30 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQL语法错误, columns中的列fdiscount必须包含在select查出列中
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
        at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
        ... 35 more

honeyscj

这个fdiscount字段是我后来在数据库中增加的，
w文件中的数据源中显示已经查到了这个字段，但是还报错说在select中没有查出来