|
报表页面reportdata获取数据失败,文件已添附在附件里,报错如下
com.justep.report.exception.ReportServerException: 报表数据获取失败
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
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.report.exception.ReportServerException: 执行KSQL出错, KSQL: SELECT f.fileName,l.syear,l.mont1,l.mont2,l.mont3,l.mont4,l.mont5,l.mont6,l.mont7,l.mont8,l.mont9,l.mont10,l.mont11,l.mont12 FROM (select t.fileName, t.fileCode from t_files t join t_file_detail t2 on t.fileCode = t2.fileCode where t.fileType = 1 AND t2.unitId = '010000' AND t2.delFlag = 0 ) f join (select licenseCode, licenseClass, year(t_license.applyDatetime) as syear, case when month(t_license.applyDatetime) = '1' then 1 else 0 end as mont1, case when month(t_license.applyDatetime) = '2' then 1 else 0 end as mont2, case when month(t_license.applyDatetime) = '3' then 1 else 0 end as mont3, case when month(t_license.applyDatetime) = '4' then 1 else 0 end as mont4, case when month(t_license.applyDatetime) = '5' then 1 else 0 end as mont5, case when month(t_license.applyDatetime) = '6' then 1 else 0 end as mont6, case when month(t_license.applyDatetime) = '7' then 1 else 0 end as mont7, case when month(t_license.applyDatetime) = '8' then 1 else 0 end as mont8, case when month(t_license.applyDatetime) = '9' then 1 else 0 end as mont9, case when month(t_license.applyDatetime) = '10' then 1 else 0 end as mont10, case when month(t_license.applyDatetime) = '11' then 1 else 0 end as mont11, case when month(t_license.applyDatetime) = '12' then 1 else 0 end as mont12 from t_license_detail t_license_detail join t_license t_license on t_license_detail.applyIdkey = t_license.idkey where year(t_license.applyDatetime) = '2016' order by licenseCode asc, licenseClass asc) l on f.fileCode = l.licenseCode WHERE ((l.syear= '2016')) LIMIT 0, -1
--> sql:
--> binds: []
at com.justep.report.controller.DataController.a(Unknown Source)
at com.justep.report.controller.DataController.a(Unknown Source)
... 20 more
Caused by: java.lang.Exception
... 22 more
|
|