报表执行失败 什么原因

阿拉伯梳子

2017-08-22 11:54:44 [SQL Time]sql 执行时间：6ms, exec sql:{DEFAULT=select count(a.GH) dpsl,a.zzmm  from  t_tzb_dwrs a  group by a.zzmm}
--> binds:[]
[ERROR] 2017-08-22 11:54:44,736 com.justep.report.controller.ReportController - 报表执行失败
null
com.justep.report.exception.ReportServerException
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        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: java.lang.NullPointerException
        at com.justep.chart.JustepChartHelper.executeChart(Unknown Source)
        at com.justep.report.core.XReportChartHelper.executeChart(Unknown Source)
        at com.justep.report.core.XReportHelper.a(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more
2017-08-22 11:54:45 [SQL Time]sql 执行时间：4ms, exec sql:{DEFAULT=select count(a.GH) xbsl,a.xb  from  t_tzb_dwrs a  group by a.xb}
--> binds:[]
[ERROR] 2017-08-22 11:54:45,861 com.justep.report.controller.ReportController - 报表执行失败
null
com.justep.report.exception.ReportServerException
        at com.justep.report.controller.ReportController.execute(Unknown Source)
        at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
        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: java.lang.NullPointerException
        at com.justep.chart.JustepChartHelper.executeChart(Unknown Source)
        at com.justep.report.core.XReportChartHelper.executeChart(Unknown Source)
        at com.justep.report.core.XReportHelper.a(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        ... 22 more

阿拉伯梳子

图表有2个，2个图表的 autoload =false，长度，宽度都指定为px模式，不是100%；

jishuang

图标要设置的有数据轴、分类轴、分组条件3个，你的sql中只有两个字段

阿拉伯梳子

jishuang 发表于 2017-8-22 13:54
图标要设置的有数据轴、分类轴、分组条件3个，你的sql中只有两个字段

demo 里面的饼图  也是这样做的，只有2个子段的。没问题呀

jishuang

你用的是饼图吗？
在java中加输出看看执行了吗？

阿拉伯梳子

jishuang 发表于 2017-8-22 14:43
你用的是饼图吗？
在java中加输出看看执行了吗？

是的啊。我看action 都执行的没问题了。

jishuang

参考http://bbs.wex5.com/forum.php?mo ... 6&pid=165049439在table返回前把table的内容输出看看

把.w发一下

阿拉伯梳子

OK。我把demo的例子拿过来处理了一下，可以用了。