OBIEE11g: Not able to view the physical query — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE11g: Not able to view the physical query

Received Response
1
Views
2
Comments
3218183
3218183 Rank 2 - Community Beginner

I have set the default Log Level as 2 in my RPD.

Still not able to see the physical query in both nqquery.log as well as in Managed sessions

I am using OBIEE 11.1.1.7

I see the patch 10125516 will resolve the issue. But from the description of the patch this needs to be applied over 11.1.1.3

Please advice

Answers

  • Felipe_Idalgo
    Felipe_Idalgo Rank 5 - Community Champion

    Hi,

    Please post here your sesion log.

    If you have physical cache implemented on your system, You can be quering cache files instead of your physical datasource.

    Try that:

    1 - Purge your cache files;

    2 - Execute your report once again

    3 - Go to Session and take a look on your file

    Felipe Idalgo

  • Eric Min-Oracle
    Eric Min-Oracle Rank 2 - Community Beginner

    Have you tried the following?

    -Open the report you are troubleshooting in Answers
    -Go to the "Advanced" tab
    Enter
    SET VARIABLE DISABLE_CACHE_HIT=1, DISABLE_CACHE_SEED=1,LOGLEVEL=5;
    in the "prefix" form box (note that the ; is required)
    - Navigate to the Results tab
    - Go to Administration tab > Manage session and extract the "View Log" file of your session then search for "Physical Request"