Has anyone had any problems with a foccache table not updating after several, consecutive writes? Is it possible for it to timeout?

Background: On an html launch page, we have a summary report that outlines 28 different performance metrics. When a user clicks on the metric name (column 1), the report will load a summary graph of that particular metric into a frame located just to the right of the report, on the same html page.

We accomplished this by calling a procedure that passes a metric_id value to a foccache table whenever the metric name on column1 is clicked. After each time a metric name is clicked, the iframe and graph are reloaded, so that the graph may display the metric that was clicked based on the id written to the foccache table.

It works great when you click on a few metrics, but after a random number of clicks foccache will stop updating and the same graph will keep displaying , no matter which metric you select. If you wait a while, and resume clicking, the foccache table begins to accept updates again and the graph updates as normal.

This message has been edited. Last edited by: Joey Sandoval,

Is it really the foccache table that's not updating, or are you being fooled by the browser's cache?

If that's the case, the general solution is to add a query parameter to the URL so that it's different with each HTTP request, for example a time-stamp.

Wep,
Well I queried the foccache table after every click and I could see that the value was not updating. But perhaps you are right the browser cache is interfering with the update. I'm not sure how I can add a parameter to the URL though..

You can change the report expiration setting in the WebFOCUS Client Console.
1. Select Configuration --> General
2. Change Expire_Reports from 300 to [n]. (n = the number of seconds. 5, 10 orwhatever suits you.).
4. Click save

Thank you Alex, changing that setting to 1 seems to have fixed the issue.