Essbase 11.1.2.x - Changing Essbase ODL Logging Levels

ODL (Oracle Diagnostic Logging) information is recorded for both the Essbase agent and the Essbase application server. The level of the logging that is recorded can be amended if required.

These are the 2 ODL logs for Essbase:

  • EssbaseAgentODLLogger is for the Essbase agent. This writes to the ESSBASE_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase
  • DefSvrLogger is for the Essbase application server (ESSSVR). This writes to the <appname>_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase/app/<appname>

The level of logging for these Essbase ODL logs is controlled by the logging.xml file.

The logging.xml for Essbase is stored here:

EPM_ORACLE_INSTANCE/EssbaseServer/essbaseserver1/bin/logging.xml

The log level can be changed from the default of ‘TRACE:1’ to another setting e.g. ‘ERROR:1’. The lower the log level, the less information will be recorded. The higher the log level, the more information will be recorded. The log levels, and information about what is recorded at each level, are here:

http://docs.oracle.com/cd/E40248_01/epm.1112/epm_troubleshooting/ch03s04s01.html

To change the logging levels, edit the logging.xml file, and find the “<loggers>” section.

This is an example of a default logging.xml file.

<loggers>

<logger name='EssbaseAgentODLLogger' level='TRACE:1' useParentHandlers='false'>

<handler name='agenthandler'/>

</logger>

<logger name='DefSvrLogger' level='TRACE:1' useParentHandlers='false'>

<handler name='serverhandler'/>

</logger>

To change the logging level, change the ‘TRACE:1’ setting to the required setting (e.g. ‘ERROR:1’).

After changing the logging.xml, restart the Essbase service for the configuration change to take effect.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today