2012年2月21日星期二

Unable to View Log File in OBIEE 11.1.1.5.0 + BI APPS 7.9.6.3

After Install OBIEE 11.1.1.5 + BI APPS 7.9.6.3 , Useing Setting user log level with this site:
http://prasadmadhasi.wordpress.com/2011/12/01/unable-to-view-log-file-in-obiee-11-1-1-5-0/

but when i clicking link "view log" in manager session, obtain this message:  No log found.

check the user session in RPD(Admin tools menu -->manager -->session), the variable:loglevel value is zero, change this variable value set to 2,the log can view.

logging levels Description


Logging Levels Logging Level Information That Is Logged
Level 0  No logging
Level 1  Logs the SQL statement issued from the client application
Logs elapsed times for query compilation, query execution, query cache processing, and back-end database processing
Logs the query status (success, failure, termination, or timeout). Logs the user ID, session ID, and request ID for each query
Level 2  Logs everything logged in Level 1
Additionally, for each query, logs the repository name, business model name, presentation catalog (called Subject Area in Answers) name, SQLfor the queries issued against physical databases, queries issued against the cache, number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application
Level 3  Logs everything logged in Level 2
Additionally, adds a log entry for the logical query plan, when a query  that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to update the exact match hit detector fails  
Level 4  Logs everything logged in Level 3
Additionally, logs the query execution plan.
Level 5  Logs everything logged in Level 4
Additionally, logs intermediate row counts at various points in the execution plan. 




2 条评论:

  1. Always Session Variable will have high priority

    回复删除
  2. Hi Prasad mandhasi, i'm new in OBIEE, thanks for your reply.

    回复删除