Purging Cache on Post ETL Run

Hi Folks,

This is the easier way to purging the cache after ETL run.


In short, we are going to create a simple batch file that calls an NQ Command to clear the cache. This batch file will then be called during the Post Load phase of the ETL run via DAC.

Let’s get started:

1) First we need to navigate to the OracleBI\server\bin directory. In my case: D:\OracleBI\server\bin

2) Now let’s create a text file called PurgeAllCache.txt.

This file will contain the following command: Call SAPurgeAllCache()

 

3) Then we need to create a batch file that will call our text file. Let’s call it PurgeAllCache.bat and give it the following content:

nqcmd -d “AnalyticsWeb” -u RPDUserName -p RPDPassword -s D:\OracleBI\server\Bin\PurgeAllCache.txt

nqcmd invokes the nqcmd executable

-d is the DNS name

-u the user

-p the password

-s the file that contains the command

To make my life a little bit easier I have added a bit of logging to the batch file – just in case

4) You can now test your batch file and verify that it is indeed deleting your cache.


If not, your newly created log file will prove quite handy.

5) Now we need to create a new DAC task to call the file.

6) Then we need to add the task to the “Following Tasks” in our Execution Plan.

7) Build your Execution Plan. The “Clear Cache” task should now show up at the end of your “Ordered Tasks” of your Execution Plan and will be executed the next time the ETL is run.

And that’s it – quick and easy!



Tnx,