OBIEE 12c: Some AD Users Cannot Login To Analytics Due To Authentication Failure. (Doc ID 2237904.1)

Last updated on FEBRUARY 26, 2017

Applies to:

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

Symptoms

On :  12.2.1.2.0 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:


ERROR
-----------------------
[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.
 (08004)
State: HY000.  Code: 43113.  [nQSError: 43113] Message returned from OBIS.
 (HY000)
State: HY000.  Code: 43126.  [nQSError: 43126] Authentication failed: invalid user/password. (HY000)[[


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open OBIEE URL
2. Login as an AD user.


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