dja248 Posted July 22, 2013 Share Posted July 22, 2013 We are seeing an issue with date filters in the Ad Hoc editor in Jasper Server 5.1.0. We had a need to change the default date format to MM/dd/yyyy so we did that by modifying jasperserver_config.properties. Now, when an absolute date is provided in a filter an Exception is thrown and the filter ends up not being applied. This only happens if the date is an absolute date, ie: 07/22/2013. Relative values like MONTH and YEAR work fine in the date filter. Here is a sample stack trace. Caused by: net.sf.jasperreports.types.date.InvalidDateRangeExpressionException: Invalid date range expression: 10/01/2012 at net.sf.jasperreports.types.date.RelativeDateRange.validateExpression(RelativeDateRange.java:82) at net.sf.jasperreports.types.date.RelativeDateRange.<init>(RelativeDateRange.java:68) at net.sf.jasperreports.types.date.DateRangeBuilder.toDateRange(DateRangeBuilder.java:223) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:72) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:58) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:42) at com.jaspersoft.commons.dataset.expr.ExpressionJSONConverter.getDateExpression(ExpressionJSONConverter.java:519) at com.jaspersoft.commons.dataset.expr.ExpressionJSONConverter.createExpressionObject(ExpressionJSONConverter.java:197) ... 105 more Any thoughts on what may be going wrong? Thanks! Link to comment Share on other sites More sharing options...
pssp25 Posted July 23, 2013 Share Posted July 23, 2013 Hi dja248,Have you restarted the jaspersoft service?Kind regards,Paulo Link to comment Share on other sites More sharing options...
dja248 Posted July 23, 2013 Author Share Posted July 23, 2013 Paulo, thanks for replying. Yes, the Jasper Server webapp has been restarted. Link to comment Share on other sites More sharing options...
sjeffrey Posted September 12, 2013 Share Posted September 12, 2013 Hi, I am seeing this issue as well, have you managed to get this resolved? Thanks,Stephen Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now