My Oracle Support Banner

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

Last updated on OCTOBER 04, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12g]
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.  They get "Unable to sign in" and the following error occurs in the sawlog 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

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
Symptoms
Cause
Solution


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