OBIEE Cache Purge

7688438

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

Ebin

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

mac2

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?

7688438

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

[Deleted User]

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!

7688438

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

[Deleted User]

Yes you should see sth like this:

+++Administrator:fff20000:fff20001:----2015/12/16 09:42:11

-------------------- Cache Purge of query:

7688438

Chris, What is the log file name and path?

[Deleted User]

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

7688438

Chris,

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