OBIEE Clearing the log

Even if you have limited the maximum size of the log file (http://obiee101.blogspot.com/2008/01/obiee-optimizing-nqquerylog-for.html) you sometimes want a Q&D cleanup. For that I create an empty log file in the log directory called NQQuerylogEmpty.log. I made a small batfile on the desktop of the development server:

net stop "Oracle BI Server"
Copy E:\OracleBI\server\Log\NQQueryEmpty.log
E:\OracleBI\server\Log\NQQuery.log
net start "Oracle BI Server"

That way I can do a Q&D reset and now that the next entry is my query.

Till Next Time