OBIEE 11G and 10G Logs

The log files for OBIEE Individual components are under INSTANCE_HOME/instances/instance1/diagnostics/logs. 

11G has neatly compartmentalised logs for each individual components of OBIEE, Below are the location for each of thos components.

Installation log    -->  OBIEE_HOME/logs

nqquery log   -->     OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

nqserver log   -->     OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSAdminTool log   -->  OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSUDMLExec log  -->  OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_obieerpdmigrateutil log (Migration log)  -->   OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

sawlog0 log (presentation)      -->     OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

jh log (Java Host)     -->     OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIJavaHostComponent\coreapplication_obijh

webcatupgrade log (Web Catalog Upgrade)     -->    OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

nqscheduler log (Agents)        --> OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1

nqcluster log    -->   OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1

ODBC log      -->     OBIEE_HOME/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1

opmn log      -->      OBIEE_HOME/instances/instance1/diagnostics/logs/OPMN/opmn

Also Logs can be accessed via the EM Console http://server.domain:7001/em

navigate to: Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics-> Log Messages

It is also possible to set individual component level logging from the EM console or rather manage logging for the whole system:

Farm_bifoundation --> application deployment. Select the component and right click to get the options, select logs --> log configuration or view log

OBIEE 10G:

The main logs in OBIEE 10G are as below.

1. BI Presentation Server log can be located from BI_HOME\OracleBIData\web\log\sawlog0.log

This log is useful for Presentation Server login issues and answers/dashboard related issues.

To increase the logging on this server to get a detailed logging to troubleshoot the SSO and integration issues by modifying the logconfig.xml file present in C:\OracleBIData\web\config folder

2. BI Server logs are NQServer.log and NQQuery.log present in BI_HOME\OracleBI\server\Log folder

 NQServer.log consists of BI Server Start up issues and Subject areas loaded and the datasources connected from within the RPD. If the NQSConfig.ini has errors or if RPD has version issues or if proper RPD is not loaded, the BI Server fails to start and this will be recorded in the NQServer.log

NQQuery.log consits of BI Server query operations. We can also check if the result is coming from cache or straight from database. We can get the actual time to execute the query. We can get the physical and logical query from this log.

3. BI Cluster Controller log can located from BI_HOME\OracleBI\server\Log folder. When the cluster is setup with OBIEE server nodes, the NQCluster.log file would provide the cluster nodes connectivity and status information. Along with the NQServer.log , NQCluster.log would be very useful for cluster related issues.

4. BI Javahost can be located from BI_HOME\OracleBIData\web\log\javahost\jhost0.log. This is used for identifying the issues with the charts and graphs generated by Java from Answers/Dashboard reports.

5. BI Scheduler can be located from BI_HOME\OracleBI\server\Log\NQScheduler.log. This is used for identifying the issues related to delivers/scheduler. To increase the logging on scheduler, set the debug flag to true in the scheduler job manager configuration window.