OBIEE 12c: Some AD Users Cannot Login To Analytics Due To Authentication Failure.

(Doc ID 2237904.1)

Last updated on MARCH 30, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Business Intelligence Suite Enterprise Edition - Version to [Release 12g]
Information in this document applies to any platform.


On : version, Analytics
After deploying repository from DEV  environment to UAT, some (but not all) users are no longer able to login to Analytics.  The following error occurs for some users:

[2017-01-26T15:12:32-06:00] [OBIPS]
[NOTIFICATION:1] [] [saw.securitysubsystem.checkauthentication.runimpl]
[ecid: 89209e8b-0210-47c2-b48a-656e26d5e568-0000036e,0:1:1] [tid:
41965312] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ]
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.
State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.
State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)[[

The issue can be reproduced at will with the following steps:
2. Login as an AD user.


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