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
echo Starting work > $LOGFILE
/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 .
What is in purgecache.txt file?
Make sure you have the below