My Oracle Support Banner

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 NOVEMBER 14, 2019

Applies to:

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


In OBIEE 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.

After tried the following - 

  1. Re-starting system in the correct order
  2. Refreshing GUIDs
  3. Restart OBIEE with default SampleAppLite.rpd and web catalog. Still, the error persists.
Getting error:
Unable to Sign in. invalid username or password was entered

Oracle BI Presentation Services started successfully, but users cannot login.

The messages found in sawlog:

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)[[



Changed repository, deleted BISystemuser, added the user back


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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