Using Essbase Logs

This topic describes the logs that Essbase Server creates to record information about server, application, and database activities. Table 139 briefly describes each log.

Essbase also uses the Oracle Diagnostic Logging framework (ODL) for logging purposes. For information on the Essbase implementation of ODL, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.

Table 139. Summary of Logs

Log Type

Log Location

Information Included

Essbase Server log

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/ESSBASE.LOG

Server activities and errors

Application log

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname/appname.LOG

Application activities and errors

Query log

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname/dbname/dbname00001.qlg

Query patterns of Essbase database retrievals

Outline change log

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname/dbname/dbname.olg

Changes to the outline

Exception log

One of these locations:

ARBORPATH/log00001.xcp

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/log00001.xcp

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname/log00001.xcp

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/app/appname/dbname/log00001.xcp

Errors that result when Essbase Server stops abnormally

Dimension build and data load error logs

One of these locations (see Table 149, Location of Dimension Build and Data Load Error Logs):

EAS_HOME/client/dataload.err

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/app/appname/appname.log

Errors from a dimension build or a data load

The following topics describe the information written to a log and explains how you can use that information to maintain, tune, or troubleshoot Essbase Server.

For information about Administration Services logs, see “About the Administration Server Log” in Oracle Essbase Administration Services Online Help.