cacher server

[JanS]

I am having problems with reports being held in cache and not presenting the correct data. Data in the database has changed but the report is not bieng re-executed.

The only way to force the report to run correctly is to stop and start the cache server.

How can I stop the report from being held in cache? Or at least clear the cache say every 30 seconds?

 

[RoughingIT]

In the CMC - accessable from the launchpad - is a properties page for all servers. Check out the settings of your cache server. You may want to reduce the setting "Minutes Between Refreshes from Database" and check on the "Viewer Refresh Always Hits Database".
To cover all bases, be aware that scheduling just provides you with data-snapshot, so I hope you are trying all with with on-demand viewing or pre-viewing a report.

 

[JanS]

Thanks for the advice.

I have tried playing with the settings of "Minutes Between Refreshes from Database" - is there a minimum setting for this? If I set the value to 0 (ie I always want the data to come from the database) and restart the cache server, it wont restart. Is 1 minute the minimum?

 

[RoughingIT]

I guess so. If you use 0 as setting, the cache server would do nothing but hitting your database. It would not be able to actually serve any pages to your clients.
Keep in mind that your cache server is going to a real busy-body. How often does your database content get updated - do you really need such a high refresh rate?

 

[JanS]

unfortunately yes - one part of my application has users selecting items from a list and adding them to a program. They then want to run a report and see these items. If I dont set a high refresh rate, they see items from 5 minutes (or whatever) ago and think there is something wrong with the database.

I am trying to prevent constant phone calls to the helpdesk "my data isnt right" when its really there, just cant be seen because the report being run is a cached report not a "data-at-present" report. If i can put it that way!

So, as it stands, they'll have to wait at least 60 seconds to get accurate data - I cant see any other way.

 

[lyanch]

Sure you can. Make sure the "refresh button always hits the database" is checked. Then for them to get "fresh" data they only need to hit the refresh button in the viewer.

Lisa

 

[JanS]

Initially, I didnt give users access to the refresh button as I didnt know how to get around the report prompting for parameters. Ive now worked that one out but users still want data to be correct when they run the report the first time - they dont want to have to use the refresh button to get correct data.

 

[RoughingIT]

if you are not using the eportfolio but your own custom application to call the reports via URL, you can use a parameter called :connect
That forces a database hit (by-passing the cache server) everytime the URL is requested...
Check the web developer guide on the launchpad...