1 Reply Latest reply: Sep 13, 2013 8:49 AM by Srini VEERAVALLI RSS

    Cache Purging everyday after Incremental Load

    raj p

      Hi,

       

      I have scheduled a cron job in linux to perform cache purging everyday after incremental load. When checked the status of cron job it looks fine, the job is successfully completed in given time, but i cant see the cache is refreshed.When i log in to RPD and navigate to Manage-->Cache i have seen cache entries not purged even after running the script.

       

      Can any one please help me in doing it , am i missing something.

       

      Please see below script i have used for cache purging

       

       

       

      [oraobiee@biprod ~]$ cat biserver_cache_purge.sh

      #!/bin/sh

      LOGFILE=/home/oraobiee/logs/PurgeCache_log_`date +%H%M%S`.log

      echo Starting work > $LOGFILE

      . /obiee/OBIEE/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh

      echo $ORACLE_HOME

      /obiee/OBIEE/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u weblogic -p W******389 -s /home/oraobiee/logs/purgecache.txt >> $LOGFILE

       

      Helpful answers will be marked for sure .

       

      Thank You