Hi Community,
I've just upgraded our JasperServer from 6.4.2 to 8.0. When I open a report via the Server with default date parameters everything works, but when I change the date parameter I get an error and the following message in the catalina.out log file:
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:158 - driver is Oracle JDBC driver version 12.2.0.1.0 (12/2)
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:162 - jdbc 4/2
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:164 - connection URL is jdbc:oracle:thin:@gbmk-p-scvdb01.uis.scv:1521:minimi
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:206 - system timezone is sun.util.calendar.ZoneInfo[id="Europe/London",offset=0,dstSavings=3600000,useDaylight=true,transitions=242,lastRule=java.util.SimpleTimeZone[id=Europe/London,offset=0,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]]
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:207 - report timezone is null
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:208 - JDBC timezone parameter is null
2022-04-12T11:48:57,927 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:209 - JDBC timezone property is null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:215 - JDBC parameters timezone parameter is null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:227 - JDBC parameters timezone property is null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:234 - parameters timezone null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:240 - JDBC fields timezone parameter is null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:252 - JDBC fields timezone property is null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:259 - fields timezone null
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:382 - SQL query string: select distinct business_date from <table name> order by business_date desc
2022-04-12T11:48:57,928 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:307 - Executing query
2022-04-12T11:48:57,934 DEBUG JRJdbcQueryExecuter,pool-9-thread-8:322 - Query execution done
2022-04-12T11:48:57,948 ERROR SecureExceptionHandlerImpl,pool-9-thread-7:125 - There was an error on the server. Try again or contact site administrators. (Error UID: a334e818-805b-43c1-921d-21b164cac0c3) com.jaspersoft.jasperserver.api.ErrorDescriptorException: Input controls validation failure
at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173)
at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:496)
at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
If you want any other info please let me know.
Nick.
try turning off sql validation in /WEB-INF/esapi/secuirty-config.properties or log the EngineServiceImpl class to see if that is what is cuasing your issue.
Thanks.