OBIEE 11g On Searching For Groups In An Application Role Receive Errors "Failed To Retrieve Roles" "Operations Error: entity=op=search mesg=Operations Error LDAP Error 1:"
Last updated on SEPTEMBER 28, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.140114 and later
Information in this document applies to any platform.
OBIEE has been upgraded from OBIEE 126.96.36.199.10 to OBIEE 188.8.131.52.1401. These are the Security Provider: one Active Directory (AD) and several BISQLGroupProvider (to keep the groups).
After upgrade to OBIEE 184.108.40.206.1401 from OBIEE 220.127.116.11.10, the groups which normally were retrieved from an External Table using two BISQLGroupProvider are not shown in EM when trying to add them to an application role.
right click, Security-Application Roles
When you edit an application role and click to add a new group.
It displays the error message:
Failed to retrieve roles.
Operations error: entity=op=search mesg=Operations Error LDAP Error 1:
- Hide Additional Trace Information
If you use 'Display Name', it does not fail but it does not display the groups from the BISQLGroupProvider.
Furthermore, it is not a good workaround because there are groups in AD without Display Name.
As workaround,you are using the 'Advanced Option', which finds the BISQLGroupProvider group. However, it deletes all previous users and groups in the application role (checked in the 'system-jazn-data.xml').
Upgraded from OBIEE 18.104.22.168.10 to OBIEE 22.214.171.124.1401
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