Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE11g: Not able to view the physical query

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
-
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
0 -
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"0