OBIEE 11g: How to Recover the BI System Role if it has Been Accidentally Deleted?

(Doc ID 1540154.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

After enabling LDAP and SSL, the BI Server is unable to start.

The following error occurs:

bi_server1.out022613

oracle.bi.security.service.SecurityServiceException: SecurityService::checkSystemUserPermissionsSystem user has not been granted required permission oracle.bi.server.impersonateUser
at oracle.bi.security.service.SecurityServiceBean.checkSystemUserPermissions(SecurityServiceBean.java:985)
at oracle.bi.security.service.SecurityServiceBean.validateSystemUser(SecurityServiceBean.java:950)
at oracle.bi.security.service.SecurityServiceBean.(SecurityServiceBean.java:130)
at oracle.bi.security.service.URServiceBean.(URServiceBean.java:45)
at oracle.bi.security.service.SecurityServiceFactory.getSecurityServiceBean(SecurityServiceFactory.java:26)
at oracle.bi.security.service.SecurityWebService$1InitialiseServiceAction.run(SecurityWebService.java:104)
at oracle.bi.security.service.SecurityWebService$1InitialiseServiceAction.run(SecurityWebService.java:98)
at java.security.AccessController.doPrivileged(Native Method)


sawlog:

[2013-02-25T10:09:23.000-08:00] [OBIPS] [NOTIFICATION:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: d145fd27a3b36ec4:7b67edcd:13d1286d7ce:-8000-0000000000000ec6,0:1:1] [tid: 1091537216] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password. (08004)[[
File:checkauthentication.cpp
Line:1293


Due to this issue, users cannot start the services and log into Analytics.

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