JasperServer not refreshing data on change in Database

0

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.

uzi.vyper's picture
Joined: Dec 17 2012 - 10:52pm
Last seen: 6 years 8 months ago

3 Answers:

0

I done this many time but my reports reflect change in data. Check for database connection from jasperserver enviroment. May be that connection takes data from older database.

ajinkya_c's picture
976
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 5 months ago

I dont think so that the issue is with the database connection because when i flush the OLAP cache from the server setting the the changes are being reflected although I have already disabled the cache option.Are there any specific settings for Jasperserver enviroment as I am just configuring the datasource with the connection url?

uzi.vyper - 6 years 8 months ago

I come accross the same problem as uzi when creating adhoc reports. When the data are changed in the database, this appears late on the reports.
I had no problem for the last 10 months and now it is getting more and more time before I can get the proper results when creating new adhoc reports. I had first 5 mn delays and it is getting worse, now I have to wait more than an hour before I can create a report and have the updated data.
I guess there is a kind of cache that is used until the database is contacted again for fresh data. Maybe there is something wrong when requesting the database.
I investigated on the server side but could not find anything strange.
Any help about how this part of the software works will be appreciated.

eric.flaux - 6 years 2 months ago
0

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:
timeToLiveSeconds="5400",
where "5400" is the default seconds for cached items (i.e. the data source content). Decrease this timeout value.

lovabill's picture
Joined: Aug 5 2016 - 8:58am
Last seen: 10 months 1 week ago
0

Thanks a lot!!!

joanpaz's picture
Joined: Feb 27 2017 - 7:57pm
Last seen: 4 months 2 days ago
Feedback
randomness