Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Brian Hall
    Clear presentation server cache
    Topic posted August 7, 2019 by Brian HallSilver Medal: 2,000+ Points, last edited September 11, 2019, tagged Analysis 
    83 Views, 5 Comments
    Title:
    Clear presentation server cache
    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

    Comment

     

    • Brian Hall

      More info,

      My numbers did not change in my DVD reports. 

       

      I did F5 (browser refresh), but they stayed on yesterday’s numbers.  

      After Data-Sync ran I opened DVD and still saw the same numbers from yesterday so first I tried F-5.  no luck

      I then went to the Data section of DVD and did a data update on my dataset.  This should call down to the ADW and get fresh data and reload.  That worked and my numbers change.

      So really, I am at the same issue.  Leave my datasets set to live, they run very slow, or set them to catch and instruct the user that on their first run of the day they must go thru refresh steps.

    • Gianni Ceresa

      Interesting situation: either slow but running queries on your database live or fast but cache side effects.

      Could "Refresh Data" be a solution? I don't really use cached sources, so never tested it, but in classical OBIEE it's the way to force the system sending a query to the BI server instead of just using the front-end cache like F5 does.

      In general in OBIEE when cache is enabled to make queries faster storing their result there is a cache management strategy defined which consist of adding a step to the ETL process, once everything has been refreshed/loaded, to call a procedure in OBIEE to purge the cache. This force the first person of the day to wait a bit longer their figures because the queries go to the DB, but will then be stored in cache.

      https://support.oracle.com/knowledge/Oracle%20Cloud/2436095_1.html would make me think it's just the same process, ideally you would need a process purging the cache once the load has been done.

      An alternative could be a job scheduled to purge cache at a fixed interval (another possible strategy in OBIEE), but jobs in OAC DV don't seem to do that for now (or at least I couldn't find an option on the dataset to schedule that).

      • Brian Hall

        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.

    • Christian Berg

      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.

    • Prasanna Thota

      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