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
2 comments:
Post a Comment