OBIEE 11g Error: "Unable to Sign in. invalid username or password was entered" After Changing Repository, Deleting BISystem User, Adding it Back (Doc ID 1308389.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308] [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 17-Jan-2013***

Symptoms

In OBIEE 11.1.1.3.0 using default authenticator, it is not possible to log in to OBIEE after changing repository. To troubleshoot, BIsystemuser was removed from global roles and added back again.

Getting error:
Unable to Sign in. invalid username or password was entered

Oracle BI Presentation Services starts successfully, but users cannot log in

extract from sawlog
[tid: 1106614592] Authentication error. Details: An error occurred during authentication.
Try again later or contact your system administrator.
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: 13037] Cannot connect to FMW Security Services, please make sure this is running in EM. (08004)[[

Changes

Changed repository, deleted BISystemuser, added the user back

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