版本号：

1.4.32

问题描述：

1.更新版本后，sql查询报错null，sql解析成功可以查询到数据，然后报错

错误日志&截图：

2022-03-09 09:56:35.751 INFO 14940 --- [nio-8030-exec-8] o.j.m.jmreport.desreport.service.a.e : ------报表【ris】，查询的sql: select study.ACCESSION_NUMBER,
study.PATIENT_NAME,
study.Patient_Gender,
study.Patient_Age,
study.Patient_Age_Unit,
study.Patient_Type,
study.Inpatient_Id,
study.Outpatient_Id,
study.devices,
study.CRITICAL_USER_ID,
study.CRITICAL_USER_NAME,
study.CRITICAL_OPERATE_TIME,
study.CRITICAL_VALUE,
apply.APPLY_DOCTOR_ID,
apply.APPLY_DOCTOR_NAME,
apply.apply_department_id,
apply.apply_department_name
from ris_studyinfo study
left join reg_apply apply
on apply.studyinfo_uid = study.studyinfo_uid
where study.disable_flag != 1
and study.CRITICAL_FLAG = 1
and ((apply.apply_source = 'sys') or
(apply.apply_source is null or apply.apply_source = ''))
-- 时间段
and study.STUDY_TIME >= to_date('2020-03-16 00:00:00', 'yyyy-MM-dd HH24:mi:ss')
and study.STUDY_TIME <= to_date('2022-03-09 09:56:29', 'yyyy-MM-dd HH24:mi:ss')
-- 基本参数

2022-03-09 09:56:35.752 INFO 14940 --- [nio-8030-exec-8] o.j.m.jmreport.desreport.service.a.e : ------数据源 dbSourceKey:【640033111493246976】
2022-03-09 09:56:36.620 ERROR 14940 --- [nio-8030-exec-8] o.jeecg.modules.jmreport.desreport.a.a : null

java.lang.NumberFormatException: null
at java.math.BigDecimal.(BigDecimal.java:497) ~[na:1.8.0_251]
at java.math.BigDecimal.(BigDecimal.java:383) ~[na:1.8.0_251]
at java.math.BigDecimal.(BigDecimal.java:809) ~[na:1.8.0_251]
at org.jeecg.modules.jmreport.desreport.express.a.b(ExpressHandler.java:156) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at org.jeecg.modules.jmreport.desreport.express.a.c(ExpressHandler.java:124) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at org.jeecg.modules.jmreport.desreport.express.a.(ExpressHandler.java:76) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at org.jeecg.modules.jmreport.desreport.express.ExpressUtil.a(ExpressUtil.java:253) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at org.jeecg.modules.jmreport.desreport.service.a.e.show(JimuReportServiceImpl.java:3691) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at org.jeecg.modules.jmreport.desreport.a.a.a(DesignReportController.java:341) ~[jimureport-spring-boot-starter-1.4.32.jar:2.0.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:888) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.2.RELEASE.jar:5.2.2.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1591) [tomcat-embed-core-9.0.29.jar:9.0.29]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.29.jar:9.0.29]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_251]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_251]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.29.jar:9.0.29]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_251]

重现步骤：

在线创建无法重现，清理jar包重新更新后 也有该问题
https://bootapi.jeecg.com/jmreport/index/661351871965122560?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE2NDY3OTczNzYsInVzZXJuYW1lIjoiMTU3NzY1NDg1NzQifQ.CGrQyVdnpw95kp_rL2Q_yWirUEhInMOBL1wX7Lgy0ag

友情提示（为了提高issue处理效率）：

• 积木报表是一款免费报表产品，功能免费源码不开放;
• 未按格式要求发帖，会被直接删掉;
• 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
• 针对不好重现的问题，请录制操作视频或详细的重现步骤；