Thursday, August 8, 2013

[OBIEE 11g] Clear Presentation Cache Auto Script

 



Clear Presentation Cache Auto Script



  • OBIEE 11G has a catalog manager command called “ClearQueryCache” to clear out the PS cache.
  • The syntax of ClearQueryCache command is:
    runcat.cmd/runcat.sh -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
    catmancredentials.properties.
  • 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://host:9704/analytics/saw.dll -credentials E:\catmancredentials.properties






No comments:

Post a Comment