My Oracle Support Banner

OBIEE 12c Unable To Retrieve BISQLGroupProvider Groups In EM (Doc ID 2174146.1)

Last updated on OCTOBER 31, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Oracle Exalytics Software - Version and later
Information in this document applies to any platform.


On: OBIEE Analytics, version

-Configured the BISQLGroupProvider in the WLS Console.
-Groups from the database can be seen in the WLS Console.
-Groups cannot be seen in EM.

Need to be able to see the groups in EM.

The issue can be reproduced at will with the following steps:

1.  cp $ORACLE_HOME/bi/plugins/security/bi-sql-group-provider.jar $ORACLE_HOME/wlserver/server/lib/mbeantypes
2.  Restart WLS.
3.  Configure Identity Store Virtualization Using Fusion Middleware Control:

EM: WebLogic Domain> bi> Security> Security Provider Configuration> Security Store Provider> Identity Store Provider> Configure virtualize=true; OPTIMIZE_SEARCH=true

4.  Configure database adaptor to retrieve group information.


To view full details, 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 a vibrant support community of peers and Oracle experts.