Purge cache remotely - OBIEE

To see reports with the most up-to-date data from the latest extract-transform-load (ETL) process, we typically purge the Oracle BI Server Cache using a common job called, "Cache Purge."

There are several ways to purge Oracle BI Server Cache:

• iBots/Agents bursting
• Dynamic repository variables 
• A nqcmd command

In today's article, we will see nqcmd command line features.

1. Create a text file purgecache.txt. Put the below BI SQL in it.

    call SAPurgeAllCache();

2. Create one batch file containing following batch operations, say Purge.bat

cd C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client Tools\oraclebi\orahome\bifoundation\server\bin

nqcmd -d DemoEnv -u weblogic -p ******* -s D:\CacheTest\purgecache.txt

3. Following is the description of the nqcmd command line arguments for BIServer (nqsserver):

-d = Datasource / ODBC DSN.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).

3. Open command prompt and run the Purge.bat file to purge the BI Server cache.

4. Press Enter to run the batch file.

5. You can see the log over here, how many entries you have purged and rest of the details.

Happy BI..!!