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

Last updated on AUGUST 23, 2016

Applies to:

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

Symptoms

On: OBIEE Analytics, version 12.2.1.1.0

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

EXPECTED BEHAVIOR
-----------------------
Need to be able to see the groups in EM.

STEPS
-----------------------
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.

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