Purge Global and Local Cache - OBIEE 11g

If you have clustered node environment using a Global folder to store cache or is a one node environment with Cache stored locally following process will be able to help purge cache both locally and in a global folder. This post is specific to a Linux environment and for a multi node environment this process needs to be repeated in each node.

1) Create a text file with below text. This is the same code you would use to clear cache from presentation (Administration > Issue SQL >)

Call sapurgeallcache()

Save this file at path - /instance/instance1/bifoundation/OracleBIApplication/coreapplication/setup

-- for second node it will be /instance/instance2......


2) Create a .sh file (How to create .sh file - http://www.linfo.org/create_shell_1.html) with below code and you can probably name it as cachepurge.sh

/<OBIEE_HOME>//instance/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh

/<OBIEE_HOME>/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb1 -u <Admin Username> -p <password> -s /<OBIEE_HOME>//instance/instance1/bifoundation/OracleBIApplication/coreapplication/setup/<file from step 1>

**Replace values in <> with your environment specific values**

3) You can setup a crontab on .sh file so that it is scheduled and executed at intended time. If you want to run it manually then use below in each node

./cachepurge.sh

Setting up job in crontab - http://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/

This process should clear local cache and global cache, Global Cache will be cleared based on the frequency interval you have setup


Hope this Helps!