RSS

Tag Archives: Cron job to Purge the cache

A very helpful OBIEE Cache Purge/Seed utility – download it for free here!!!

We all know how to purge OBI Server Cache to see the reports with the most up-to date data from recent ETL. The most common job we do for this is “Cache Purge”. There are several ways to Purge OBI Server Cache: for e.g.: with ibots/Agents bursting, Dynamic repository variables or with our own nqcmd command. Either that, or it means we can script the process and run it periodically. However, to execute these commands in any automated process, you have to depend on another app/skillset and you need to be compromised at security to access OBIEE Server. Because some of the OBIEE command line statements can’t be executed external to the Server. To do this either you need be compromised at OS security level or you need to setup the sshpass (password-less login). But many organizations will not support this in ther Production environments due to various reasons of password sharing or bypassing limitations. And this has been a must have attempt in 90% of OBIEE implementations that we have seen till now (At least in my case).

So to address this issue, I am very excited to tell you guys that I have developed a simple handy tool. This is completely free for you for the benefit of OBIEE Community…. Using this, you can simply Purge or seed the OBIEE Server Cache remotely. Yes, you don’t need to login to OBIEE server or Application. You can simply do that from your own system. Only thing that you need is that you should be able to ping the OBIEE hostname/ipaddress on BI Server port (e.g: 9703). That’s it, you are done.

Instructions to Install:

  1. Pre requisite: Make sure you have Jdk 1.6+ installed in your system.
  2. I have created two versions of BICachePurge v1.0 utility for both Windows and LINUX/UNIX Operating Systems.
  3. You can just download the version of your choice for free from here

  4. Unzip the downloaded file into a directory of your choice.
  5. Now, navigate to the BICachePurge_v1.0 folder.
  6. In the BICachePurge_v1.0 root folder, Open the BIS_Param (BIS_Params.bat for WINDOWS and BIS_Params.sh for Linux/Unix) in a text editor.
  7. And now, edit the following variables to reflect the OBIEE server where you would like to purge the cache.
    1. BI_SERVER
    2. BIS_PORT
    3. BI_USER
    4. BI_PASWD
    5. OBI_QUERY

    Note: All the variables are mandatory and so make sure to setup all of them. And if you have any spaces in the values, then add that in quotes (). For eg. call SAPurgeAllCache() and DON’T FORGET TO SAVE.

    Sample BIS_Params.bat file configuration:


  8. Now you all set. To purge cache from your terminal:
    1. On windows: open a DOS command prompt and navigate to <install drive>/BICachePurge_V1.0 and execute Purge_Cache.bat command.
    2. On Linux/Unix: on command line, Go to <install drive>\BICachePurge_V1.0 and execute ./Purge_Cache.sh command.

    Sample output of Purge_Cache.bat command:


OK, Now how it helps to automate the Cache Purge/Seed process?

Hmm, you can use this code in different ways.

  1. You can purge the OBIEE Server cache from your own system without logging into OBIEE online RPD or Presentation Services.
  2. You can use this in crone job on server to do this on regular interval of time if you wish to.
  3. You can execute this from your own ETL servers (for e.g.: from DAC server to execute it as POST Task).
  4. And in many ways wherever you want to run without depending on OBIEE Server…

Enjoy guys!!!.. And feel free to give your feedback and do let me know if you have any issues in installing this.

Thanks,
Shiva Molabanti

 

Tags: , , , , , ,