Jasper Server is not refreshing the data on change in database for both OLAP and ADHOC View. The result remains the same even if the data in the database is changed.The schema needs to be reloaded in order to refresh the new changes.Can you please help me a way out in which I dont need to update schema again and again.
Sorry for the bump, but for the record:
Solution for earlier versions: http://community.jaspersoft.com/wiki/how-modify-caching-values-if-your-d...
Solution for version 6.3:
Edit C:\Jaspersoft\jasperreports-server-6.3.0\apache-tomcat\webapps\jasperserver-pro\WEB-INF\adhoc-ehcache.xml line 26:
where "5400" is the default seconds for cached items (i.e. the data source content). Decrease this timeout value.