4 Replies Latest reply on Mar 29, 2013 3:52 AM by Turbokat

    No BI query logs

      I was working on a production issue, unfortunately query logging is disabled in production. Technically query might be same as from dev, but i need to confirm prod query. What should be the right approach to solve the issue here?
        • 1. Re: No BI query logs
          Srini VEERAVALLI
          Use SET VARIABLE LOGLEVEL=2; in Answers->Advanced tab Prefix

          as in

          If helps mark as correct

          Edited by: Srini VEERAVALLI on Mar 28, 2013 5:22 PM
          • 2. Re: No BI query logs
            Since its production, you may not have much choice in modifying the RPD. You best bet might be to take xml from production, apply it in answers in dev, and get the query from development.
            1 person found this helpful
            • 3. Re: No BI query logs
              Also, if you still concerned about dev RPD not being the same in dev compared to prod, then deploy copy of production RPD on your local machine or a sandbox if you have OBIEE installed there, and get query from there (after setting the right log level).
              • 4. Re: No BI query logs
                Take the logical query from analysis which would be shown from 'Manage Sessions' and run this in 'Issue SQL' under Administration and enable whatever logging you want to starting with 4 is recommended. Now you can click view log to get the physical query.!

                Run this in your DB.

                Mark if helps.