We have 4 queries thatw e want to cache up at nights. They are created as Web Templates and scheduled in RA to run at Nights.
In RSRT, each of these queries, are set to use Option 4 for the Cache (Persistence Cache accross APp Servers) and Cluster Table.
The queries get cached and run for some time properly. But soon the Cache gets deleted. I can see this as the Cache size changes from > 1MB to around 450 KB.
Following settings I noticed on the Cache Parameters
1 Local Cache 48 MB
2) GLobal Cache 48 MB
3) Persistence Mode: Inactive (Could this be the reason that cache is getting deleted).