To purge BI server cache in OBIEE 11g

Post date: 25-Feb-2011 11:18:36

Reference : http://shivabizint.wordpress.com/2010/12/22/purge-bi-server-cache-in-obiee11g/

Nice blog on Purging BI Server Cache  in OBIEE 11g

 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 bi-init.sh on UNIX) to launch a command prompt or shell window that is initialized to your Oracle instance. You can find this utility in:

<MW_HOME>/ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

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

More at : http://shivabizint.wordpress.com/2010/12/22/purge-bi-server-cache-in-obiee11g/