Problem with caching of SQL data in Input Control

[jme14]

I have created an input control to select a specific error-code for an error-report. This input control selects also the error-messages and the number of times a specific error occurs (with count(*)).

select vme.id
,      left(vme.code,3) as code
,      concat(vme.ernst
             ,lpad(vme.id,3,'0')
             ,' - '
             ,vme.message
             ,' ('
             ,count(*)
             ,')'
             ) as message
from hls_verwerking_melding vme
     join hls_verwerking_verslag vve
       on vve.id_vme = vme.id
and (vme.ernst = $P{p_error_code} or $P{p_error_code} = '0')
group by vme.id

This works fine, but.... Jasperserver does not (always) refresh the selected data. When I use the input control, I get the same data as yesterday. (Yes, I am sure the data has been modified in the database)

How can I instruct JasperServer not to cache the data in this input control?

I use JasperServer CE 3.7.0

Regards,

Jan

[tmatyashovsky]

Hi Jan,

 

Have you tried to clear cache using Manage -> Adhoc Cache?

 

Best regards,

Taras Matyashovsky

[rjback]

We are seeing this behaviour too- our input controls cache from the previous day's data. In fact, if you rerun the report, on the third time the cache is abandoned and it starts working.

But then, when you choose the report from the list of reports subsequently, it goes back to the previous day's cache despite having abandoned it earlier!

Why would clearing the ad-hoc cache have any effect? This is not an ad-hoc report, it is an iReport with an input control.

If we have to clear the ad-hoc cache every day then this is not a solution.

[vytautas]

 Good afternoon,

we are facing the same issue and I was wondering if somebody managed to find the way how to disable data caching for input controls in jasperserver?

Regards,

Vytautas

[rpu]

Is this solved in JasperServer 4.0.0 ?

We also have the problem of the cached inputcontrols.
It looks like this is a user - dependent cache. For one user the list is cashed and not refreshed and for another user everything works fine.

Is there a solution or work-around for this in 3.7.0?

[vytautas]

 Hi rpu,

we solved it by disabling mondarian cache in jasper server as this was unnecessary for, but this is still workaround rather than solution.

We also noticed the same issue in 4.x.

Check: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=107&topicid=76237

Thanks.