OBIEE 11G - Log Files (Oracle Diagnostic Logging - ODL)


Access and configuration of the log files is centralized on the diagnostics tab of the BI coreapplication in the FMW Control web interface with the help of ODL (Oracle Diagnostic Logging is a centralized framework for logging).


Log Viewer

To access the Log Viewer, click on the log viewer link. This viewer is the viewer of WLDF. See WebLogic - Diagnostics Framework (WLDF)

Execution Context ID (ECID)

When log entries for error messages and warnings are generated across multiple log files, they can be difficult to trace. However, it is possible to view logging information for specific user transactions across multiple log files. Transaction level logging associates a unique transaction ID, which is called the Execution Context ID (ECID)

Diagnostic log files

Diagnostic log files are files used to store message information that is generated by Oracle Business Intelligence servers.

These log files are stored in the following location:


where component type is one of the following:

The following diagnostic log files are used in Oracle Business Intelligence:

Where <n> = date and timestamp for example 20101209-2135

Component Log Files Description Searchable in Log Viewer
Presentation Services \CatalogCrawler\sawcatalogcrawlerlogsysn.log The catalog crawler log file No
Presentation Services sawlogn.log The Presentation Services log file that represents the latest part of diagnostic log output Yes
Oracle BI Server nqquery<n>.log The Oracle BI Server query log No
Oracle BI Server nqserver<n>.log The Oracle BI Server main diagnostic log Yes
Oracle BI Administration Tool nqsadmintool.log The log for the Oracle BI Administration Tool ?
JavaHost jh-n.log The JavaHost Server main diagnostic log Yes
Oracle BI Scheduler nqscheduler-<n>.log and Agent-<n>.log The Oracle BI Scheduler log file Yes
Cluster Controller nqcluster-yyyyMMdd-hhmm.log The Oracle BI Cluster Controller diagnostic file Yes
Action Services and Security Services AdminServer-diagnostic.log BI JEE log Yes
Action Services and Security Services bi_server1-diagnostic.log BI JEE log Yes

Oracle BI Server utilities - For example, biserverxmlexec and equalizerpds, also generate their own logs when they are run.

NQSUDMLExec.log ORACLE_INSTANCE\diagnostics\logs\OracleBIServerComponent/coreapplication_obis1
obieerpdmigrateutil.log (Migration log) ORACLE_INSTANCE\diagnostics/logs/OracleBIServerComponent/coreapplication_obis1
webcatupgrade.log (Web Catalog Upgrade) ORACLE_INSTANCE\diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1
ODBC.log ORACLE_INSTANCE\diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1
Upgrade Assistant log FMW_HOME\Oracle_BI1/upgrade/logs

Opmn generate also its own log files in the instance.

Documentation / Reference

Powered by ComboStrap