OBIEE 11g: Error: "Unable to Sign In An invalid User Name or Password was entered." when Using LDAP Authentication with OBIEE after Applying OBIEE Patches 11.1.1.6.6, 11.1.1.6.7 or 11.1.1.6.8 (Doc ID 1529523.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.6 to 11.1.1.6.8 [Release 11g]
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.6 to 11.1.1.6.8 [Release 11g]
Information in this document applies to any platform.

Symptoms

OBIEE configured with external LDAP, Authentication Fails for OBIEE Anlytics after applying OBIEE Patches 11.1.1.6.6, 11.1.1.6.7 or 11.1.1.6.8.

Weblogic user can connect to EM and console but gets following error with the weblogic user with OBIEE analytics:

Unable to Sign In
An invalid User Name or Password was entered.

When using LDAP user:

An error occurred during authentication.Try again later or contact your system administrator

 

  1. The users and their passwords are valid. - the user ID and password is valid. Even if you create a new user in console, you are unable to log in with that user.
  2. All Web Logic Server components were started up properly: as shown in the logs, all the components are started properly without any issues.
  3. The RDBMS database where the repository for the Oracle Fusion Middleware resides, is up and running. You are able to connect to the database using SQL Plus.
  4. The RDBMS schema passwords created using the Repository Creation Utility (RCU) are not expired. you are able to connect to the database using SQL Plus and query the BIPLATFORM schema.



You see the following error in Bifoundation_domain.log:

oracle.bi.security.service.SecurityServiceException: SecurityService::authenticateUserWithLanguage [OBI-SEC-00020] Authenticated user has an invalid GUID



You see the following error in the bi_server1-diagnostic.log:

+ [2013-02-06T10:45:11.434+02:00] [bi_server1] [ERROR] [OBI-SEC-00003] [oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: FIVAN.ADSI_B_ADMIN] [ecid: 004pGdNSVSwEkJ1pJss1yf0007Bb000003,0:1:2:13:1] [WEBSERVICE_PORT.name: SecurityServicePort] [APP: bimiddleware#11.1.1] [J2EE_MODULE.name: bimiddleware/security] [WEBSERVICE.name: SecurityService] [J2EE_APP.name: bimiddleware_11.1.1] Error during initialization[[
oracle.bi.security.service.SecurityServiceException: SecurityService::validateSystemUserSystem user could not be authenticated

Caused by: oracle.bi.security.service.SecurityServiceException: SecurityService::authenticateUserWithLanguage [OBI-SEC-00020] Authenticated user has an invalid GUID
at oracle.bi.security.service.URServiceBean.authenticateUserWithLanguage(URServiceBean.java:154)
at oracle.bi.security.service.SecurityServiceBean.validateSystemUser(SecurityServiceBean.java:958)
... 59 more

Changes

 After applying OBIEE patches 11.1.1.6.6, 11.1.1.6.7 or 11.1.1.6.8 on top of OBIEE 11.1.1.6.5.

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