RSS

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

17 Jun

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

Advertisements
 

Tags: , , , , , ,

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

  1. rmoff

    June 17, 2014 at 8:47 am

    Hi Shiva,
    This sounds interesting. Are you going to share the source code for it?
    thanks, Robin.

     
    • Shiva Molabanti

      June 18, 2014 at 12:02 am

      Hi Robin,
      yes, I am giving it for free. You can download it from the link in the post.

      Thanks,
      Shiva

       
  2. Avinash

    June 17, 2014 at 6:39 pm

    Hi Shiva,

    while running sh file getting bellow error, i downloaded V0.1

    Exception in thread “main” java.lang.ClassFormatError: ShivaMolabanti.Shiva_BICachePurge (unrecognized class file version)
    at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)
    at java.lang.ClassLoader.defineClass(libgcj.so.7rh)
    at java.security.SecureClassLoader.defineClass(libgcj.so.7rh)
    at java.net.URLClassLoader.findClass(libgcj.so.7rh)
    at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
    at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
    at gnu.java.lang.MainThread.run(libgcj.so.7rh)

    thx,
    Avinash

     
    • Shiva Molabanti

      June 18, 2014 at 12:03 am

      Hey Avinash,
      Did you configure the BIS_Params.bat/sh file? btw, do you have Java installed in your machine.

      Thanks,
      Shiva.

       
      • Avinash

        June 18, 2014 at 8:59 am

        yes, Java also installed.

         
  3. jaimeen

    July 11, 2014 at 6:08 am

    Awesome Shiva..Thanks for sharing this information.

     
  4. Mohamed Darwiash

    November 7, 2014 at 8:38 pm

    Thank you Shiva very much for this wonderful tool. I want to ask you aboutcache seeding. Do I need to put the Analysis or report physical query I want to seed in the OBI_Query parameter?if Yes, what if I want to seed more than 1 report? if No, what command shall I put for this parameter in case of cache seeding

     
  5. Mayur

    April 22, 2015 at 3:41 pm

    How to set it work at regular interval,crone job on the server?.
    As we got requirement. Please hlep us.
    Thanks in advance.

     
  6. Sovitendu

    June 18, 2015 at 5:31 am

    Hi Shiva,
    Iam not able to download Cache Purging/Seeding Tool from the link.

    Could you please check if the link is not broken.

    Thanks in advance.

     
  7. Jer

    August 26, 2015 at 5:28 pm

    Any chance you could repost this tool?

     
    • Shiva Molabanti

      September 28, 2015 at 8:21 am

      Any issues in downloading the Tool?

      Thanks,
      Shiav

       
  8. Bhavin

    January 13, 2016 at 4:23 am

    The link redirect me to your facebook page, could you please help me in downloading the tool ?

     
  9. Vinesh Kumar

    April 16, 2016 at 2:55 am

    Hi Shiva, I clicked on the link above but it is landing on facebook page. Am i doing something wrong here?

     
  10. Vivek Kumar

    February 14, 2017 at 8:38 am

    Hi Shiva,

    Download link is not working, Could you please check.

     
  11. Venu

    February 28, 2017 at 9:05 am

    Hi Shiva, Liked the content but not able to download the from link in the post can you please help on that

     
  12. avatova

    March 2, 2017 at 8:31 am

    Hi, Shiva! I’m not able to download. Your link is not working

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: