3 Replies Latest reply on Feb 11, 2013 11:07 AM by 603257

    Location of query log files in OBIEE 11g (version 11.1.1.5)

    913367
      Hi,
      I wish to know the Location of query log files in OBIEE 11g (version 11.1.1.5)??
        • 1. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
          Amith Y
          Hi There,

          If you are asking for the log files where the logical and physical queires of the analysis queries are stored, then it is called nqquery.log and the location path's are below:

          10g: BI_ORACLE_HOME/server/Log
          11g: ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

          Regards,
          -Amith.
          • 2. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
            MuRam
            Hi,

            Log Files in OBIEE 11g

            Login to the URL http://server.domain:7001/em and navigate to:
            Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics-> Log Messages

            You will find the available files:

            Presentation Services Log

            Server Log

            Scheduler Log

            JavaHost Log

            Cluster Controller Log

            Action Services Log

            Security Services Log

            Administrator Services Log

            However, you can also review them directly on the hard disk.

            The log files for OBIEE components are under <OBIEE_HOME>/instances/instance1/diagnostics/logs.

            Specific log files and their location is defined in the following table:
            Log Location
            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/logsOracleBISchedulerComponent/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

            debug log                                    <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

            logquery log                               <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

            service log                                    <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

            opmn out                              <OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

            Upgrade Assistant log                         <OBIEE_HOME>Oracle_BI1/upgrade/logs

            Regards
            MuRam
            • 3. Re: Location of query log files in OBIEE 11g (version 11.1.1.5)
              603257
              Hi,
              Are these log files also applicable to 11.1.1.6.2?
              Also, do you know the best place to find further information on each of these log files, what they are used for, purge/rotation cycles etc?

              Thanks