ksql报错

qweasdzxc

2017-05-15 16:03:58 excute stream action, params:{"accept":"application/json","action":"getOutData","actionFlag":"__action_0__","activity":"Top10Activity","contentType":"json","executeContext":"","executor":"","parameters":{},"process":"/SAM/assetManage/process/asset/assetProcess"}
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.RuntimeException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT Count(a.fAssetId) AS flag,MAX(a.fAssetName) AS assetName,a.fAssetId AS assetId FROM SAM_ASSETOUTDETAIL a optional join SAM_ASSETOUTLIST b on a.fAssetOutListID=b where b.fBizState='bsFinished' GROUP BY a.fAssetId ORDER BY flag DESC limit 0,10
--> sql:
--> binds: []
    at AssetManage.getOutData(AssetManage.java:508)
    ... 27 more



public static Table getOutData(){
        try {
            String ksql = "SELECT Count(a.fAssetId) AS flag,MAX(a.fAssetName) AS assetName,a.fAssetId AS assetId FROM SAM_ASSETOUTDETAIL a optional join SAM_ASSETOUTLIST b on a.fAssetOutListID=b where b.fBizState='bsFinished' GROUP BY a.fAssetId ORDER BY flag DESC limit 0,10";
            return KSQL.select(ksql, null, "/SAM/assetManage/data", null);
        } catch (Exception e) {
            throw new RuntimeException(e.getMessage());
        }
    }

qweasdzxc

结贴