Last updated on OCTOBER 19, 2015
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
When a cell is clicked in result table of Direct Database Request(DDR) after the presentation server cache has expired or been cleared,
the Physical SQL is fired off to the database again, even if the column Properties has had interaction set to "None" and the results of browser not refreshed.
Steps to reproduce the issue.
- Ensure that you have a connection pool that connects to an Oracle database.
- Set logging for your user to level 2 and connect to OBIEE.
- Create a direct database request from the following SQL:
SELECT 'X' from DUAL UNION SELECT 'Y' from DUAL;
- Run the request.
- Open the nqquery.log file and verify that the sql has been logged in there.
- Either allow the Presentation Cache to expire, or in a separate browser
Window go to Administration -> Manage Sessions and click "Close all cursors".
- Reload the nqquery.log file, and note the last line in the log.
- Return to the browser window that contains the DDR results, and click on one of the cells in the table (either 'x' or 'y')
- Reload the nqquery.log file and see that there are messages added to the log file showing that the query has been run again.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms