ReportServer Forum

hlynch

Member

Registered: 2014-10-08

Problem with running reports on new server

I'm trying to move up to the latest version of reportserver, we are currently still on 3.0.3.
I setup a new server (version 4.2.0) and loaded all of our existing reports (all jasper) onto the new server.
We execute all of our reports by URL calls.

Most of the reports fail to run, and I find the exception below in the catalina.out log.
The reports run fine from the URL on the old server.

What could be the problem here?

[2022-08-16 16:38:11] [info] java.lang.IllegalArgumentException: Could not parse date: 07-16-2022
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.base.service.parameters.datetime.DateTimeParameterInstance.doParseStringValue(DateTimeParameterInstance.java:153)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.service.parameters.entities.ParameterInstance.parseStringValue(ParameterInstance.java:202)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.service.reportmanager.hookers.ConfigureBaseReportViaRequestHooker.adjustReport(ConfigureBaseReportViaRequestHooker.java:36)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.service.reportmanager.hooks.ConfigureReportViaRequestAndLocationImpl.adjustReport(ConfigureReportViaRequestAndLocationImpl.java:22)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.lambda$4(ReportExportServlet.java:652)
[2022-08-16 16:38:11] [info] #011at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.getReportFromRequest(ReportExportServlet.java:652)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportById(ReportExportServlet.java:285)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.exportReportByIdViaRequest(ReportExportServlet.java:279)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.core.server.reportexport.ReportExportServlet.doGet(ReportExportServlet.java:159)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet.doGet(HttpAuthExecuteServlet.java:72)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e.CGLIB$doGet$0(<generated>)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e$$FastClassByGuice$$8d1fa09f.invoke(<generated>)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
[2022-08-16 16:38:11] [info] #011at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e.doGet(<generated>)
[2022-08-16 16:38:11] [info] #011at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
[2022-08-16 16:38:11] [info] #011at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e.CGLIB$service$15(<generated>)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e$$FastClassByGuice$$8d1fa09f.invoke(<generated>)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:76)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:78)
[2022-08-16 16:38:11] [info] #011at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:54)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.incubator.server.httpauthexecute.HttpAuthExecuteServlet$$EnhancerByGuice$$1c9a1a9e.service(<generated>)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
[2022-08-16 16:38:11] [info] #011at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)
[2022-08-16 16:38:11] [info] #011at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
[2022-08-16 16:38:11] [info] #011at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
[2022-08-16 16:38:11] [info] #011at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
[2022-08-16 16:38:11] [info] #011at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
[2022-08-16 16:38:11] [info] #011at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887)
[2022-08-16 16:38:11] [info] #011at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684)
[2022-08-16 16:38:11] [info] #011at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
[2022-08-16 16:38:11] [info] #011at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[2022-08-16 16:38:11] [info] #011at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[2022-08-16 16:38:11] [info] #011at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[2022-08-16 16:38:11] [info] #011at java.base/java.lang.Thread.run(Thread.java:829)
[2022-08-16 16:38:11] [info] Caused by: java.text.ParseException: Cannot parse date "07-16-2022": not compatible with any of standard forms ("yyyy-MM-dd'T'HH:mm:ss.SSSX", "yyyy-MM-dd'T'HH:mm:ss.SSS", "EEE, dd MMM yyyy HH:mm:ss zzz", "yyyy-MM-dd")
[2022-08-16 16:38:11] [info] #011at com.fasterxml.jackson.databind.util.StdDateFormat.parse(StdDateFormat.java:383)
[2022-08-16 16:38:11] [info] #011at net.datenwerke.rs.base.service.parameters.datetime.DateTimeParameterInstance.doParseStringValue(DateTimeParameterInstance.java:148)
[2022-08-16 16:38:11] [info] #011... 58 common frames omitted

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with running reports on new server

Hi hlynch,

you seem to try to parse "07-16-2022" into a date, the error is:
Cannot parse date "07-16-2022": not compatible with any of standard forms ("yyyy-MM-dd'T'HH:mm:ss.SSSX", "yyyy-MM-dd'T'HH:mm:ss.SSS", "EEE, dd MMM yyyy HH:mm:ss zzz", "yyyy-MM-dd")

You can try to change the format in your report / in your query to yyyy-MM-dd

Regards,
Eduardo

hlynch

Member

Registered: 2014-10-08

Re: Problem with running reports on new server

We have over a hundred reports that get generated by URL.
The calls to the old version of reportserver work fine.

Changing the date format for all the reports will be alot of work.

Why does it work correctly on the older server (3.0.2), but not on the newer server?

Is there anything in the configuration, etc of the newer server to alter this behavior?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with running reports on new server

Hi hlynch,

"07-16-2022" is not a standard form, as you see in the error message. Why did this work in old versions? probably because old versions of the libraries parsing the dates did not care about these standards. Newer versions seem to be more strict with this, so they need a correct, standard form.

If the date is inside the URL you are calling, you probably only have to change the URL, not all reports.

Regards,
Eduardo