OBIEE Online Training

Wednesday, September 21, 2011

Unable To Create Session Variable Using Obiee 11.1.1.5 Admin Tool issue

Hi,
   
An interesting thing happen, when I was trying to choose a connection pool for creating a Session variable Init Block , connection pool Select button was disabled. This functionality worked in 11.1.1.3. Just to avoid any doubt I restarted admin tool, followed by machine restart, but end result didn’t change. After looking around, I remembered that in one of the metalink they talked about “Allow First Connection for init block”. I tried that option and it work . Below are the details ::
Issue :
Select button is disabled when trying to choose a connection pool for creating a Session variable Init Block

Solution:
Check “Allow First Connection for init block” to true
For setting “Allow First Connection for init block”  follow below steps :
  1. In the Administration Tool, select Tools, then select Options to display the Options dialog.
  2. On the General tab, select ”Allow First Connection for init block. (this option is not a best practice and might cause performance issues.)
THanks

DEva

1 comment:

  1. Checking "Allow First Connection for init block is not a good practice, which may lead to performance, instead of checking create another new connection pool

    ReplyDelete