com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error evaluating expression :

[sagarnikam123]

I am using Windows platform,iReport-4.7 & Jasperserver-5

my report works fine on iReport,but gets exception on Jasperserver as below

to solve I added rt.jar (which contains java.text.SimpleDateFormat Class) into JasperServer directory--> /apache-tomcat/webapps/jasperserver/WEB-INF/lib/rt.jar

& restarted all services ,even though below error remains same

 

Error Message

com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error evaluating expression : Source text : ( Math.abs( new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{start_year}.toString()               + "-"+$P{start_month}.toString()+"-01").getTime()               - new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{end_year}.toString()               + "-"+$P{end_month}.toString()+"-01" ).getTime())/(1000*60*60*24)/30 )

Error Trace

com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :Source text : ( Math.abs( new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{start_year}.toString()               + "-"+$P{start_month}.toString()+"-01").getTime()               - new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{end_year}.toString()               + "-"+$P{end_month}.toString()+"-01" ).getTime())/(1000*60*60*24)/30 )   at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203)   at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591)   at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559)   at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:972)   at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:629)   at net.sf.jasperreports.engine.fill.JRParameterDefaultValuesEvaluator.evaluateParameterDefaultValues(JRParameterDefaultValuesEvaluator.java:87)   at net.sf.jasperreports.engine.fill.JRParameterDefaultValuesEvaluator.evaluateParameterDefaultValues(JRParameterDefaultValuesEvaluator.java:59)   at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2382)   at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2340)   at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2230)   at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getControlsInformation(ReportParametersAction.java:523)   at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getReportParameterValuesFromRequest(ReportParametersAction.java:361)   at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:487)   at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:366)   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)   at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)   at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)   at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)   at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77)   at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)   at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)   at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)   at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101)   at org.springframework.webflow.engine.State.enter(State.java:194)   at org.springframework.webflow.engine.Transition.execute(Transition.java:227)   at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393)   at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)   at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)   at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)   at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388)   at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)   at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232)   at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)   at org.springframework.webflow.engine.Flow.resume(Flow.java:545)   at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261)   at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169)   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597)   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)   at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)   at $Proxy97.resumeExecution(Unknown Source)   at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)   at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)   at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)   at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)   at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)   at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:101)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)   at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)   at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)   at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)   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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)   at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)   at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)   at java.lang.Thread.run(Thread.java:619)

Caused by: java.text.ParseException: Unparseable date: "null-null-01"   at java.text.DateFormat.parse(DateFormat.java:337)   at java_text_DateFormat$parse.call(Unknown Source)   at outside_use_report_comp_1361539043955_612190.evaluate(calculator_outside_use_report_comp_1361539043955_612190:153)   at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) ... 126 more

[marianol]

 

Check the parameters you are feeding to the report... Because the cause of the erros is actually an Unparseable date:

 

Caused by: java.text.ParseException: Unparseable date: "null-null-01" at java.text.DateFormat.parse(DateFormat.java:337) at java_text_DateFormat

 

So it looks like: $P{start_year}.toString() and $P{start_month}.toString() are rendering NULL and that is causing the parse error.