Oracle Analytics Cloud and Server

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

OBIEE Cache Purge

Received Response
301
Views
29
Comments
2

Answers

  • Rank 5 - Community Champion

    Hi All, Can anybody give some inputs on this? Thanks R

  • Rank 3 - Community Apprentice

    Is it happening after new data is inserted into the warehouse table ?

  • Rank 4 - Community Specialist

    If someone is saving the RPD in online mode, the BI server cache will automatically get cleared.

    If you open your RPD in online mode, and go to Manage -> Cache, and then go Action -> Show Info, what do you see?

  • Rank 5 - Community Champion

    Mac2, I can see the cache files but the files are purging with out manual or automated purge... I'm trying to find the reason why the cache files are purging....? Thanks R

  • Rank 10 - Analytics Guru

    There's gotta be something. Maybe you have an Agent running which purges the cache through a batch file...rather basic procedure (not very fine grained) but I wouldn't discount it existing!

  • Rank 5 - Community Champion

    Chris, thanks for your response.! I don't see any agents which purges all the cache files. Is there any way or any log file where we can see who is purging the cache? Thanks R

  • Rank 10 - Analytics Guru

    Yes you should see sth like this:

    +++Administrator:fff20000:fff20001:----2015/12/16 09:42:11
    
    -------------------- Cache Purge of query:
    
  • Rank 5 - Community Champion

    Chris, What is the log file name and path?

  • Rank 10 - Analytics Guru

    NQQuery.log normally residing in YOUR_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obisXYZ

  • Rank 5 - Community Champion

    Chris,

    I don't find the cache purge log information in nqquery.log.

    purge.png

Welcome!

It looks like you're new here. Sign in or register to get started.