1. Installation and Configuration Troubleshooting Guide
  2. Using EPM System Logs
  3. Essbase Logs

Essbase Logs

Table 3-14 Essbase ODL Component Logs

Component Default Log Location Log File Name and Contents
Oracle Essbase Server EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0, where 0 is an instance number

  • ESSBASE.LOG—Essbase Server activities and errors

  • ESSBASE_ODL.log—Essbase Server activities and errors

  • dataload_ODL.err—Data load and dimension build errors

  • log0000x.xcp—Errors that result when Essbase Server stops abnormally

  • leasemanager_server_HOSTNAME.log—Essbase Server Lease Manager information

  • leasemanager_essbase_HOSTNAME.log—Essbase Agent Lease Manager information

  • log00001.xcp—Errors that result when the agent stops unexpectedly

Note:

ESSBASE.LOG and ESSBASE_ODL.log contain the same information in different formats.

Specified through an essbase.cfg setting, which you can change through Essbase Administration Console or with a text editor. dbname_ODL.atx and dbname_ODL.alg, where dbname is specified through an essbase.cfg setting—Successfully completed spreadsheet update transactions

These are SSAUDIT log files. See "Monitoring Data, Applications, and Databases" in the Oracle Essbase Database Administrator's Guide and the Oracle Essbase Technical Reference.

EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase_0/application name

  • application name.LOG—Essbase application activities and errors

  • application name_ODL.log—Essbase application activities and errors

  • log00001.xcp—Errors that result when the application server stops unexpectedly

Oracle Essbase Administration Services

Note:

To enable console logging, in MIDDLEWARE_HOME/EPMSystem11R1/products/Essbase/eas/console/bin/admincon.bat, set the Java option parameter –DEAS_ CONSOLE_LOG to True.

MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/EssbaseAdminServices0/logs

  • easserver.log—Administration Services Server activity

  • EssbaseAdminServices0.log—Administration Services Java web application activity

Oracle Hyperion Provider Services MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/AnalyticProviderServices0/logs

  • AnalyticProviderServices0.log—Provider Services Java web application activity

  • apsserver.log—Provider Services activity

Essbase Security Client EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/essbase SharedServices_Security_Client.log—Tracking of Oracle Enterprise Performance Management System component and CSS communications with native provider

Also records the JDBC configuration from registry in this log file for any binds with native providers.
Oracle Process Manager and Notification Server EPM_ORACLE_INSTANCE/diagnostics/logs/OPMN/opmn

  • opmn.log—Information about when Essbase starts, stops, and how many stop and start retry attempts are made

  • console~ESSBASE_CLUSTER_NAME~ESSBASE_PROCESS_TYPE~AGENT~1.LOG—All console messages are directed to a file that is called the "console" output file for a managed process, in this case, Essbase.

.

.

 EssbasePing.log— OPMN Forward Ping information
Essbase Plugin EPM_ORACLE_INSTANCE/diagnostics/logs/essbase/lcm essbaseplugin.log— Information about artifacts listing, migration (import/export) of Essbase artifacts, time taken for artifact listing and artifact migration