OBIEE11g: Not able to view the physical query

Question

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

Eric Min-Oracle · Answer

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"

Felipe_Idalgo · Answer

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