Purge BI Server Cache in OBIEE11g

22 Dec

To purge BI server cache in OBIEE 11g we need to go through the below process:

Create a text file with a name e.g: say purgecache.txt with below code in it

Call SAPurgeAllCache() and save the file in /<MW_HOME>/Oracle_BI1/bifoundation/server/bin directory.

Before running nqcmd, you must first run bi-init.cmd (or on UNIX) to launch a command prompt or shell window that is initialized to your Oracle instance. You can find this utility in:


Then, run nqcmd from the resulting shell window with the desired options.

For example:

nqcmd –d my_dsn –u my_username [-p my_password] –s sql_input_file –o my_result_file

You can pass a text file with SQL statements to the utility (script mode), or you can enter SQL at the command line (interactive mode). Queries are run against the default subject area, unless the object names used in the query are fully qualified.

For example to purge BI Server cache run below command

In windows:

nqcmd -d AnalyticsWeb -u <weblogic_admin user> -p <weblogic_admin password>-s purgecache.txt

In Unix:

./nqcmd -d AnalyticsWeb -u <weblogic_admin user> -p <weblogic_admin password>-s purgecache.txt






Posted by on December 22, 2010 in OBI EE, OBIEE 11g


11 responses to “Purge BI Server Cache in OBIEE11g

  1. Manohar

    May 31, 2011 at 12:15 pm

    Hi Shiva,
    Thanks a Ton for sharing knowledge..

    • Nir

      December 28, 2011 at 2:10 pm

      I have session variable for custom display name, displayed in prompt label.
      After I modify the value in the DB, OBIEE sign out and relogin, an initialization init block is updating the session variable value with the new DB value.
      This value modification is not reflected in GUI, unless I stop the presentaiton service and restart it.
      I tried using your cache clean script, after modifing the DB value, but it didn’t solve the problem.
      Any ideas?

  2. Nir

    December 28, 2011 at 2:14 pm

    This blog talk about Purge BI *Server* Cache in OBIEE11g.
    Is there a way to purge presentation cache?

    • sandeep maturi

      September 5, 2012 at 9:36 am

      logout and relogin again automatically all the cache will be purged for presentation cache

      • sandeep maturi

        September 5, 2012 at 9:38 am

        in every report you will have advance tab option in that check the check box to by pass presentation cache so it will never show the results from cache of presentation.

    • sandeep maturi

      September 5, 2012 at 9:40 am

      You can override the maximum amount of time, in minutes, that an entry in the cache can exist before it is removed. The internal default is 60 (one hour). Depending on (the number of requests being run, an entry may be removed before the time limit expires.
      The following entry is an example:

    • sandeep maturi

      September 5, 2012 at 9:41 am

      The expiry of this entry can be governed by following instance-config.xml file in <>\web\config directory

  3. sandeep maturi

    August 23, 2012 at 8:58 am

    i want to purge all the queries related to current date in bi server my data in db goes on changing for every 15 min so i need fresh data for current day.we are generating reports on oltp

  4. Multiverse

    November 20, 2012 at 2:08 am

    The does not start a new command prompt. I am simply left in the original Bash shell in which I started. The environment has not changed. Looking in the script, there is nothing that would start a new shell, except the script itself, which is a Bourne shell script that simply runs and then exits.

  5. iswarya

    October 9, 2015 at 7:32 am

    I am not getting any new command prompt and also i get an error saying Unable to find library’ .Can anyone help

    • burglarone

      April 21, 2016 at 2:20 pm

      export LD_LIBRARY_PATH=$ORACLE_HOME/bifoundation/server/bin:$LD_LIBRARY_PATH


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: