主从关系设置后，ksql报错

pipiainiwry

2016-11-01 14:36:34 excute stream action, params:{"accept":"application/json","action":"queryTaobao_trades_ordersAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"Taobao_trades_orders,ZBID,adjust_fee,bind_oid,bind_oids,buyer_nick,buyer_rate,cid,combo_id,consign_time,customization,discount_fee,divide_order_fee,end_time,f_status,f_term,f_type,ftp_filename,iid,inv_type,invoice_no,is_daixiao,is_oversold,is_service_order,is_sh_ship,is_www,item_meal_id,item_meal_name,logistics_company,md_fee,md_qualification,modified,num,num_iid,oid,order_attr,order_from,outer_iid,outer_sku_id,part_mjz_discount,payment,pic_path,price,refund_id,refund_status,seller_nick,seller_rate,seller_type,shipper,shipping_type,sku_id,sku_properties_name,snapshot,snapshot_url,status,store_code,store_id,sub_order_tax_fee,sub_order_tax_rate,ticket_expdate_key,ticket_outer_id,tid,timeout_action_time,title,tmser_spu_code,total_fee,type,xxx,zhengji_status","filter":"(Taobao_trades_orders.ZBID=1)","limit":20,"offset":0,"variables":{}},"process":"/trade/nmtrade/process/tbtrade/tbtradeProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"Taobao_trades_orders","sequence":"Taobao_trades_orders,ZBID,adjust_fee,bind_oid,bind_oids,buyer_nick,buyer_rate,cid,combo_id,consign_time,customization,discount_fee,divide_order_fee,end_time,f_status,f_term,f_type,ftp_filename,iid,inv_type,invoice_no,is_daixiao,is_oversold,is_service_order,is_sh_ship,is_www,item_meal_id,item_meal_name,logistics_company,md_fee,md_qualification,modified,num,num_iid,oid,order_attr,order_from,outer_iid,outer_sku_id,part_mjz_discount,payment,pic_path,price,refund_id,refund_status,seller_nick,seller_rate,seller_type,shipper,shipping_type,sku_id,sku_properties_name,snapshot,snapshot_url,status,store_code,store_id,sub_order_tax_fee,sub_order_tax_rate,ticket_expdate_key,ticket_outer_id,tid,timeout_action_time,title,tmser_spu_code,total_fee,type,xxx,zhengji_status"},"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 Taobao_trades_orders.*  FROM Taobao_trades_orders Taobao_trades_orders WHERE ((Taobao_trades_orders.ZBID=1)) LIMIT 0, 20
--> sql: SELECT  Taobao_trades_orders.id AS Taobao_trades_orders, Taobao_trades_orders.ZBID AS ZBID, Taobao_trades_orders.ADJUST_FEE AS adjust_fee, Taobao_trades_orders.BIND_OID AS bind_oid, Taobao_trades_orders.BIND_OIDS AS bind_oids, Taobao_trades_orders.BUYER_NICK AS buyer_nick, Taobao_trades_orders.BUYER_RATE AS buyer_rate, Taobao_trades_orders.CID AS cid, Taobao_trades_orders.COMBO_ID AS combo_id, Taobao_trades_orders.CONSIGN_TIME AS consign_time, Taobao_trades_orders.CUSTOMIZATION AS customization, Taobao_trades_orders.DISCOUNT_FEE AS discount_fee, Taobao_trades_orders.DIVIDE_ORDER_FEE AS divide_order_fee, Taobao_trades_orders.END_TIME AS end_time, Taobao_trades_orders.F_STATUS AS f_status, Taobao_trades_orders.F_TERM AS f_term, Taobao_trades_orders.F_TYPE AS f_type, Taobao_trades_orders.FTP_FILENAME AS ftp_filename, Taobao_trades_orders.IID AS iid, Taobao_trades_orders.INV_TYPE AS inv_type, Taobao_trades_orders.INVOICE_NO AS invoice_no, Taobao_trades_orders.IS_DAIXIAO AS is_daixiao, Taobao_trades_orders.IS_OVERSOLD AS is_oversold, Taobao_trades_orders.IS_SERVICE_ORDER AS is_service_order, Taobao_trades_orders.IS_SH_SHIP AS is_sh_ship, Taobao_trades_orders.IS_WWW AS is_www, Taobao_trades_orders.ITEM_MEAL_ID AS item_meal_id, Taobao_trades_orders.ITEM_MEAL_NAME AS item_meal_name, Taobao_trades_orders.LOGISTICS_COMPANY AS logistics_company, Taobao_trades_orders.MD_FEE AS md_fee, Taobao_trades_orders.MD_QUALIFICATION AS md_qualification, Taobao_trades_orders.MODIFIED AS modified, Taobao_trades_orders.NUM AS num, Taobao_trades_orders.NUM_IID AS num_iid, Taobao_trades_orders.OID AS oid, Taobao_trades_orders.ORDER_ATTR AS order_attr, Taobao_trades_orders.ORDER_FROM AS order_from, Taobao_trades_orders.OUTER_IID AS outer_iid, Taobao_trades_orders.OUTER_SKU_ID AS outer_sku_id, Taobao_trades_orders.PART_MJZ_DISCOUNT AS part_mjz_discount, Taobao_trades_orders.PAYMENT AS payment, Taobao_trades_orders.PIC_PATH AS pic_path, Taobao_trades_orders.PRICE AS price, Taobao_trades_orders.REFUND_ID AS refund_id, Taobao_trades_orders.REFUND_STATUS AS refund_status, Taobao_trades_orders.SELLER_NICK AS seller_nick, Taobao_trades_orders.SELLER_RATE AS seller_rate, Taobao_trades_orders.SELLER_TYPE AS seller_type, Taobao_trades_orders.SHIPPER AS shipper, Taobao_trades_orders.SHIPPING_TYPE AS shipping_type, Taobao_trades_orders.SKU_ID AS sku_id, Taobao_trades_orders.SKU_PROPERTIES_NAME AS sku_properties_name, Taobao_trades_orders.SNAPSHOT AS snapshot, Taobao_trades_orders.SNAPSHOT_URL AS snapshot_url, Taobao_trades_orders.STATUS AS status, Taobao_trades_orders.STORE_CODE AS store_code, Taobao_trades_orders.STORE_ID AS store_id, Taobao_trades_orders.SUB_ORDER_TAX_FEE AS sub_order_tax_fee, Taobao_trades_orders.SUB_ORDER_TAX_RATE AS sub_order_tax_rate, Taobao_trades_orders.TICKET_EXPDATE_KEY AS ticket_expdate_key, Taobao_trades_orders.TICKET_OUTER_ID AS ticket_outer_id, Taobao_trades_orders.TID AS tid, Taobao_trades_orders.TIMEOUT_ACTION_TIME AS timeout_action_time, Taobao_trades_orders.TITLE AS title, Taobao_trades_orders.TMSER_SPU_CODE AS tmser_spu_code, Taobao_trades_orders.TOTAL_FEE AS total_fee, Taobao_trades_orders.TYPE AS type, Taobao_trades_orders.XXX AS xxx, Taobao_trades_orders.ZHENGJI_STATUS AS zhengji_status FROM taobao_trades_orders Taobao_trades_orders  WHERE Taobao_trades_orders.ZBID = ?
--> binds: [1]
        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 mor

jishuang

主从data的设置先看看http://pan.baidu.com/s/1cxHxro#list/path=%2F第6章6.2

同样的问题请不要重复发帖，方便查看和回复