Cache purge not working — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cache purge not working

Received Response
41
Views
8
Comments
Hesh
Hesh Rank 5 - Community Champion
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

Hi,

OBIEE 12c

even though I use the function call SAPurgeAllCache() , my OBIEE dashboards are showing old values.

Once I do the dashboard refresh, I am able to see the updated data.

Can you please help me on this.

Thanks

Mahesh

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    The question is a little vague. Could you please provide the sequence of events you performed when you encountered this behavior ?  Also what is the complete version of OBIEE 12c ?

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    I am certainly no expert on cache and how it works in OBIEE.

    However, I think it might be worth trying this one thing --

    When using the SAPurgeAllCache() command, you could also try this additional step:

    Go to Administration->Manage Sessions

    Click 'Close All Cursors'

    See if that helps.

  • Hesh
    Hesh Rank 5 - Community Champion

    Thank you,

    Full version is 12.2.1.0.0

    After ETL , I am doing the cache refresh using call SAPurgeAllCache() , but the new data is not reflecting until I refresh the Dashboards.

    Regards

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Dasbhoard doesn't automatically refresh.

    If you want it to refresh you have either to refresh the page or to click on the refresh option.

    If you need a periodical refresh have a look at

    https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis

  • Hesh
    Hesh Rank 5 - Community Champion

    Thank you FTislot,

    When I perform the SAPurgeAllCache, there should not be anything to get the result from the cache, then the Dashboard should be getting the results 'fresh' from the DB and this is like refresh in indirect way?

    Regards,

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Hi,

    SAPurgeAllCache is going to delete your BIServer cache entries only. If the analysis results are stored in presentation server cache you'll see old results.

    You can bypass presentation cache by clicking on the appropriate checkbox in the Advanced tab in Analysis Editor as written

    O.B.I.E.E: Step by Step to Bypass All Caches

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Also take a look at your presentation server cache settings. More on this in the following document.

    https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/querycaching.htm#BIESG122

  • Hesh
    Hesh Rank 5 - Community Champion

    Thanks again FTislot,

    But this will bypass the cache every time, I just need only once after ETL.

    This was working fine as per users just recently got issues.

    I was reading somewhere about disable the feature PERF_PREFER_IN_LISTS, but not sure how this was working earlier.

    Regards