Wednesday, October 29, 2008

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

2 comments:

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.