Persistence Cache - Cache is getting Deleted

[Former Member]

Hi,

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).

Pls suggest.

Thanks

Anand

[Former Member · Accepted solution]

Hello Anand,

Cache is invalidated (deleted) when there is a data load or the query is re-genrated. You might be having data loads at night. Alternatively, check the query generation time in table RSRREPDIR and see if it has any co-relation ot the time the query cache is deleted.

You can check in the cache monitor also to see if cache is available.

Cheers

Aneesh

[Former Member]

Thanks Aneesh. I will look into the persistence mode setting to Cluster.

[Former Member]

Hi Anand,

Activate the persistence mode.

Cheers

Aneesh