Clear presentation server cache

Question

Summary

How-To Clear presentation server cache

Content

There are two types of caches in OAC.  The internal BI cache, which we clear from Data Sync.  But there is also a presentation server cache, which we do not know how to clear.  Can you help?

Version

18 , Cloud

Prasanna Thota · Answer

Hi Brian,

You can also clear you cache in OAC through the Menu (on your left) -> Console -> Issue SQL. And executing the below commands, depending on what you are trying to clear:

call SApurgeallcache();

call NQS_GetAllCacheEntries();

call SAPurgeCacheByQuery();

call SAPurgeCacheByTable();

call SAPurgeCacheByDatabase();

call SAPurgeCacheBySubjectArea();

call SAPurgeCacheEntryByIDVector();

Hope this helps!

-Prasanna

[Deleted User] · Answer

runcat.cmd command line does that for on-premises. I doubt there is an equivalent in OAC. If there is it's not documented or exposed right now.

Brian666H · Answer

See thread "data sync question"   We are already clearing via the Data-Sync ETL  however, that does not fix the issue within DVD.  Question;  When you run "Refresh Data" within the project does that have the dataset call the ADW or does it just refresh with the local dataset?   We need the local datasets that are set to cache to refresh once a day.