OBIEE 11g - DDR Re-executes SQL Upon Clicking On a Cell In The Results (Doc ID 2065574.1)

Last updated on OCTOBER 19, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

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.

  1. Ensure that you have a connection pool that connects to an Oracle database.
  2. Set logging for your user to level 2 and connect to OBIEE.
  3. Create a direct database request from the following SQL:
    SELECT 'X' from DUAL UNION SELECT 'Y' from DUAL;
  4. Run the request.
  5. Open the nqquery.log file and verify that the sql has been logged in there.
  6. Either allow the Presentation Cache to expire, or in a separate browser
    Window go to Administration -> Manage Sessions and click "Close all cursors".
  7. Reload the nqquery.log file, and note the last line in the log.
  8. Return to the browser window that contains the DDR results, and click on one of the cells in the table (either 'x' or 'y')
  9. Reload the nqquery.log file and see that there are messages added to the log file showing that the query has been run again.

Cause

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