Initialization Block: Test succeeds, no results at login
NeavesSep 9 2011 — edited Sep 15 2011Hello all,
I'm trying to make some non-system session variables, within the "Oracle BI Administration Tool". An initialization block has been created, to fetch initial values (using a query based on nq_session.USER). The initialization block passes all tests: connection pool is fine, initialization SQL runs perfectly, and variable names match the result set.
Unfortunately, the initialization block doesn't appear to run at login. Inspecting via the Oracle BI Administration -> Manage -> Sessions interface shows default values assigned to all related session variables. I've even simplified the initialization block to a static value (select 'static text'; ), with no change.
For reference...The connection pool uses shared authentication, and functions fine within presentation services/reports/answers/etc; the relevant initialization block is enabled; and the non-system session variables are also enabled. A complete log out/in has no effect, nor does logging in as a separate/fresh user.
Any ideas why a Session Variable Initialization Block would "Test..." successfully, but have no impact following login?
Edited by: 884357 on Sep 9, 2011 2:51 PM (removed inadvertent smiley)