报表报错

鬼画符

报表报错，报表执行错误：报表数据获取失败

select d.fSupplierID,d.fSupplierName,'' as BGhj,'' as BGsj,'' as BGbh,'' as WJhj,'' as WJsj,'' as WJbh,'' as QJhj,'' as QJsj,'' as QJbh,'' as CYhj,'' as CYsj,'' as CYbh from SJ_ProcureInStorD d where d.fSupplierID is not null and d.fCreateTime > '2017-06-01 00:00:01' and d.fCreateTime < '2017-06-19 23:59:59' and ( d.fmatOrgPath like '%8B66371CB6C64D9D8E70387EDBADF34E%' ) group by d.fSupplierID,d.fSupplierName
-----select sum(d.fInMoney) as fInStoreCount ,(sum(d.fInMoney)/(1+1.00*s.fSL/100)*(1.0*s.fSL/100)) as fSJ , (sum(d.fInMoney)-(sum(d.fInMoney)/(1+1.00*s.fSL/100)*(1.0*s.fSL/100))) as fBHSJ from SJ_ProcureInStorD d join SJ_SupplierInfo s on  d.fSupplierID = '' and d.fMaterialCode like 'A-%' and d.fCreateTime > '2017-06-01 00:00:01' and d.fCreateTime < '2017-06-19 23:59:59' and s = d.fSupplierID  and (d.fInStoreState = '已入库' or d.fInStoreState = '已结算') and  ( d.fmatOrgPath like '%8B66371CB6C64D9D8E70387EDBADF34E%' ) group by s.fSL
0
-----select sum(d.fInMoney) as fInStoreCount ,(sum(d.fInMoney)/(1+1.00*s.fSL/100)*(1.0*s.fSL/100)) as fSJ , (sum(d.fInMoney)-(sum(d.fInMoney)/(1+1.00*s.fSL/100)*(1.0*s.fSL/100))) as fBHSJ from SJ_ProcureInStorD d join SJ_SupplierInfo s on  d.fSupplierID = '31A029BA596D4CE9B329C21CF262F51B' and d.fMaterialCode like 'A-%' and d.fCreateTime > '2017-06-01 00:00:01' and d.fCreateTime < '2017-06-19 23:59:59' and s = d.fSupplierID  and (d.fInStoreState = '已入库' or d.fInStoreState = '已结算') and  ( d.fmatOrgPath like '%8B66371CB6C64D9D8E70387EDBADF34E%' ) group by s.fSL
2017-06-19 10:55:40 action:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="true" process="/SJMIS/officeSupplyConsumables/process/WZHZ/wZHZProcess" activity="rkhzActivity" action-flag="__action_0__" executor="A0E7BAB0EA3745A6815ADCB6ED0DDAE3" execute-context="" name="rkmxhz"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="sID"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="time"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">2017-06-01</xbiz:simple></parameter><parameter name="time1"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">2017-06-19</xbiz:simple></parameter><parameter name="fmatOrgID"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">8B66371CB6C64D9D8E70387EDBADF34E</xbiz:simple></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        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 com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:40)
        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 OfficeSupplyConsumables.returnNum(OfficeSupplyConsumables.java:1484)
        at OfficeSupplyConsumables.rkmxhz(OfficeSupplyConsumables.java:1409)
        ... 28 more
[ERROR] 2017-06-19 10:55:40,633 com.justep.report.controller.DataController - 报表数据获取失败
null
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 com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:40)
        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: null
        at com.justep.report.controller.DataController.a(Unknown Source)
        at com.justep.report.controller.DataController.a(Unknown Source)
        ... 21 more
Caused by: java.lang.Exception
        ... 23 more

jishuang

Caused by: java.lang.NullPointerException
        at OfficeSupplyConsumables.returnNum(OfficeSupplyConsumables.java:1484)
        at OfficeSupplyConsumables.rkmxhz(OfficeSupplyConsumables.java:1409)

java代码调试跟一下

鬼画符

后台跟了下，没问题，别的页面的报表也用到了这个方法，别的页面没有报错

jishuang

java中就已经报空指针异常了肯定有问题，看看为什么会报空指针
确认是不是有空的情况没有进行判断

鬼画符

我看下