DevOps, CI/CD and Automation

Hi,

we're running reports 11g under WLS.
As our data changes only a few times per year we have TOLERANCE set quite high in our cgicmd.dat.
That means that after delivery of new data the cache needs to be cleared.

So the simple question is just how to clear the cache?

I've found evidence of a tool called Reports Queue Manager. An impressive name that in Linux turns out to be a script that can show the queue.
As we already have the queue tables set up in the database that was of little value.
I've also found the actual cache directory, were the generated html/pdf is saved. Removing the pdf by hand gives the user an error when refreshing the reports (instead of rerunning it from start).
Clearing the tables RW_JOBS and RW_SERVER_JOB_QUEUE by hand or by RW_SERVER.CLEAN_UP_QUEUE; will still deliver the cached document on refresh.
In enterprise manager I've only seen a few cache settings, nothing on clearing it.


Kind regards

Tomas