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.


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