OBIEE 12c Warning message found in the log files -> 'Warning: BISQLGroupsProvider: Connection pool not usable' (Doc ID 2505258.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Goal

After attempting to configure the bisqlgroups and receive the error that the provider is unavailable -> 'Warning: BISQLGroupsProvider: Connection pool not usable'.
Used the following docs here :

https://docs.oracle.com/middleware/12212/biee/BIESC/GUID-30F09EE4-A2DE-443D-BF24-CC401B6E13FD.htm#BIESC6128

and https://blogs.perficient.com/2018/10/03/obiee-12c-security-ldap-authentication-and-db-authorization/

Have verified the JNDI connection and also that the data source is available to the admin server and bi_server, though nothing helps.

Can you point me in the right direction?

BIEE 12.2.1.4.0 (Build BIPS-20180409020153 64-bit).
All BI Functionality seem to have no issue. Users from MSAD are able to login and do all expected activities
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.