How to Clear the query cache in OBIEE11G Presentation Server?

03 May

When users run analyses, Presentation Services can cache the results of those analyses. Presentation Services determines if subsequent analyses can use cached results. If the cache can be shared, then subsequent analyses are not stored.

The files for the Presentation Services cache have names such as nQS_xxxx_x_xxxxxx.TMP. The files are created by the ODBC driver but generally do correspond to ODBC requests that the Presentation Services cache keeps open. The files are stored in the following directory:


The files for the cache are removed whenever Presentation Services shuts down cleanly. If Presentation Services shuts down unexpectedly, then various cache files might be left on disk. You can delete the files when Presentation Services is not running.

The Presentation Services cache is not the same cache that is accessed by the Oracle BI Server.

Sometimes we may need to clear the Presentation server cache also, to clear that follow the below steps:

  • OBIEE 11G has a catalog manager command called “ClearQueryCache” to clear out the PS cache.
  • The syntax of ClearQueryCache command is: 
    runcat.cmd/ -cmd clearQueryCache  -online <OBIPS URL> -credentials <credentials properties file>
  • Create a catalog manager credential properties file. Open a text file and type the following entries.
              Login = <weblogic_admin_Username>
              Pwd = <weblogic_Admin_Userpassword>  
    And save in a directory with the file name as
  • Now open command prompt and navigate to <MW_HOME>instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\
  • And Run the following command to clear OBIPS query cache:
    runcat.cmd -cmd clearQueryCache -online http://shiva-pc:9704/analytics/saw.dll -credentials E:\




Tags: , , , , , , , , , ,

3 responses to “How to Clear the query cache in OBIEE11G Presentation Server?

  1. Sakshi

    October 3, 2013 at 8:22 am

    getting an error- Unable to login to , must specify absolute path.
    The path I’m entering is- http://:/analytics/saw.dll
    However I can logic through web using same URL.
    Please suggest.

  2. kannappan

    November 7, 2013 at 1:05 pm

    Hi Shiva, I believe “call sapurgeallcache” from IssueSQL also clears PS cache. Please let me know If I am wrong.

  3. Alex

    January 24, 2017 at 5:37 pm

    Can you clear the cache via a webservice call in OBIEE if so , any pointers?


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: