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:
Then, run nqcmd from the resulting shell window with the desired options.
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
nqcmd -d AnalyticsWeb -u <weblogic_admin user> -p <weblogic_admin password>-s purgecache.txt
./nqcmd -d AnalyticsWeb -u <weblogic_admin user> -p <weblogic_admin password>-s purgecache.txt