This post explains you how to purge cache in OBIEE 11g from the command prompt. Please follow the steps.
1. Create a purgecache.txt file with with the following line and save it in the “BI_Home\Oracle_BI1\bifoundation\server\bin” path.
2. Open a command prompt window and then navigate to “BI_Home\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup” and then execute bi-init.cmd. it will launch a command prompt window that is initialized to Oracle instance.
3. Then navigate to “BI_Home\Oracle_BI1\bifoundation\server\bin” and then execute the following command. After execution, you should see the similar results as the below screen.
nqcmd –d my_dsn –u my_username [-p my_password] –s sql_input_file
Example: OBIEE 11g
nqcmd -d coreapplication_OH417411576 -u weblogic -p Admin123 -s purgecache.txt
Example: OBIEE 10g
nqcmd -d AnalyticsWeb -u weblogic -p Admin123 -s purgecache.txt
Till Next Time