OBIEE 11g - Unable to find the physical query issued

Question

Im logged in as the adminstrator -with a log level set to 5.

I try going into Administration -> Manage Sessions -> Locate the query I want and click on "View Log"

I was expecting to see the physical query, but I only see the logical query.

I try to search for the string "Send" as usually that precedes the phsyical query but I dont see anything, just the logical query.

Is there another setting I am missing some where that is not letting me see the physical query generated?

Thanks in advance

[Deleted User] · Answer

chillychin wrote:*smacks forehead*Thanks for pointing out the cache Christian

;-)

I think you'll find that we pretty much aren't big cache fans around here because of just these issues.

chillychin · Answer

*smacks forehead*

Thanks for pointing out the cache Christian

When I ran the report/query in Answers I had gone into [Administration -> Manage Sessions] and clicked on "Cancel Running Requests" and "Close All Cursors".

I then re-ran the report/query and noticed I was only getting the logical query. At the end of the log it also mentioned [Created by: XYZ] (this should have been my first hint).

I forgot to ALSO go into the RPD cache manager to clear it.

After clearing the RPD cache manager THEN I could see the physical query.

Silly me I thought by clearing the "Manage Sessions" area was sufficient. Forgot to also clear the RPD cache of queries.

Thanks so very much - was really scratching my head for a bit on that one.

rmoff · Answer

You should only need log level 2 to see physical query. Have you checked the nqquery.log file directly on disk?