OBIEE 11g: Groups do not Appear in WebLogic Server Console after Configuring External LDAP with Groups in Database (Doc ID 1603055.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

You have configred OBIEE 11g with an external LDAP.  Your groups come from a database and you have followed the steps as given in Section 3.4.4 - Configuring LDAP as the Authentication Provider and Storing Groups in a Database - of the Oracle® Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) Part Number E10543-07.  But you do not see the groups in WebLogic Server console.

You see the following errors in AdminServer.log:

####<Nov 15, 2013 10:24:21 AM EST> <Error> <Console> <AMRNDHW3549> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <534cf857356cad33:-74a84a67:1425c582a77:-8000-000000000000007e> <1384529061098> <BEA-240003> <Console encountered the following error oracle.bi.security.provider.wls.authentication.dbms.SQLGroupProviderDelegateException: Error listing groups: *
Caused by: java.sql.SQLException: Connection pool not usable.

and AdminServer-diagnostic.log:

[5:2013-11-15T10:24:12.205-000] [AdminServer] [NOTIFICATION] [] [oracle.bi.security.provider] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 534cf857356cad33:-74a84a67:1425c582a77:-8000-0000000000000078,0] [APP: consoleapp] SQLGroupDatabaseConnectionPool.getDataSource()
[2013-11-15T10:24:12.221-05:00] [AdminServer] [WARNING] [] [oracle.bi.security.provider] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 534cf857356cad33:-74a84a67:1425c582a77:-8000-0000000000000078,0] [APP: consoleapp] Configuration validation connection exception[[java.sql.SQLException: Connection pool not usable. ]].

 

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