OBIEE 12c: Some AD Users Cannot Login To Analytics Due To Authentication Failure.
(Doc ID 2237904.1)
Last updated on NOVEMBER 01, 2024
Applies to:
Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and laterBusiness 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 |