Tuesday, 25 February 2014

Unable to select Connection pool when creating init block in OBIEE 11g

Problem:
In Administration Tool, when i tried to create an Initialization Block, I found I couldn't select the connection pool option, is disabled.

Note:
By default, the first connection pool under the database object in the Physical layer is not available for selection. This behavior ensures that you cannot use the same connection pool for initialization blocks that you use for queries.

Good Practice:
Make sure that, every time you import new connection, you have duplicated connection pool dedicated to use in initialization block.

Solution:
1. Open Admin Tool,
2. Go to Tool > Options
3. On the General tab, select "Allow First Connection for Init Blocks"
4. Select Ok.
5. Save changes you have made.
6. You are ready to deal with Initialization Blocks.

Happy stay.. :-)
Sagar Tippe

No comments:

Post a Comment