nick_keay

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.

Hi Elizam, Thanks for the prompt reply. I'm reading the JasperReports Server Security Guide 6.4. Chapter 4 User Security, 4.2.3 Allowing Users to Change their Passwords. I was hoping that our users would be able to manage their Active Directory user passwords via LDAP from JRS. But it sounds like what your saying is no, JRS can only do the Authentication of an External Users via LDAP, but isn't setup to facilitate the "changing" of passwords through LDAP?

We've successfully implemented Jasper Server Community edition 6.4.2. We've also successfully implemented LDAP External User Authentication. However when I read the JasperReports Server Security Guide, it advises against enabling allowing users to change their passwords. Is this because it's unsupported and or because we're using the Community edition?