使用 sqlAction 多租户主从报表查询 报错

jishuang

如果没有执行java，那就是action就没调用到，确认excel中设置的是否都正确

southpine

打印报错：

使用ksqlAction

2016-04-11 11:05:18 开始-WINDOW生成中间文件: /UI2/SMS/sell/process/sell/printActivity.w
2016-04-11 11:05:19 结束-WINDOW生成中间文件: /UI2/SMS/sell/process/sell/printActivity.w
2016-04-11 11:05:19 开始-中间文件生成缓存文件: /UI2/SMS/sell/process/sell/printActivity.w
2016-04-11 11:05:19 结束-中间文件生成缓存文件: /UI2/SMS/sell/process/sell/printActivity.w
java.lang.NullPointerException
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.CompiledTable.calculateXPathValue(Unknown Source)
        at com.justep.report.CompiledCell.getCellValueByRef(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledSheet.compile(Unknown Source)
        at com.justep.report.CompiledTable.compile(Unknown Source)
        at com.justep.report.Table.transform(Unknown Source)
        at com.justep.report.Content.transform(Unknown Source)
        at com.justep.report.ContentSet.transform(Unknown Source)
        at com.justep.report.Report.a(Unknown Source)
        at com.justep.report.ReportDocument.transform(Unknown Source)
        at com.justep.report.ReportTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        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)
java.lang.NullPointerException
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.CompiledTable.calculateXPathValue(Unknown Source)
        at com.justep.report.CompiledCell.getCellValueByRef(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledSheet.compile(Unknown Source)
        at com.justep.report.CompiledTable.compile(Unknown Source)
        at com.justep.report.Table.transform(Unknown Source)
        at com.justep.report.Content.transform(Unknown Source)
        at com.justep.report.ContentSet.transform(Unknown Source)
        at com.justep.report.Report.a(Unknown Source)
        at com.justep.report.ReportDocument.transform(Unknown Source)
        at com.justep.report.ReportTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        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)
java.lang.NullPointerException
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.TransformContext.a(Unknown Source)
        at com.justep.report.CompiledTable.calculateXPathValue(Unknown Source)
        at com.justep.report.CompiledCell.getCellValueByRef(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledCell.compile(Unknown Source)
        at com.justep.report.CompiledSheet.compile(Unknown Source)
        at com.justep.report.CompiledTable.compile(Unknown Source)
        at com.justep.report.Table.transform(Unknown Source)
        at com.justep.report.Content.transform(Unknown Source)
        at com.justep.report.ContentSet.transform(Unknown Source)
        at com.justep.report.Report.a(Unknown Source)
        at com.justep.report.ReportDocument.transform(Unknown Source)
        at com.justep.report.ReportTransformer.transform(Unknown Source)
        at com.justep.report.core.XReportHelper.executeXReport(Unknown Source)
        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)

jishuang

平台默认的案例报错吗？
确认报表中的数据是否有特殊的字符

southpine

平台案例不报错。数据没有特殊字符。

jishuang

这个错误应该就是数据中或者excel中问题

看看excel中设置的批注，是否有特殊的