My Oracle Support Banner

Intermittent Login Issues In the OBIEE 11g Environment With AD LDAP Authenticator (Doc ID 1556461.1)

Last updated on JANUARY 10, 2019

Applies to:

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

Symptoms

Using WLS (Web Logic Server) and  MSAD (Microsoft Active Directory) authentication.

Intermittently,  AD users fail to log into analytics, getting invalid username/password error.


Sawlog0.log shows the following error:

[2013-03-13T21:49:58.000-03:00] [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 00026bLgnamBT8IqyoBh6G0002qA000000,0:1812] [tid:
 106] 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.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password. (08004)[[
File:odbcuserpoploaderimpl.cpp
Line:995
Location:
  saw.security.odbcuserpopulationimpl.getbisystemconnection
  saw.security.odbcuserpopulationimpl.getroles
  saw.security.userpopulationcache.populateapproleshierarchy
  saw.RoleHierarchyCache.cache.cleanup
  saw.taskScheduler.processJob
  saw.threadpool.taskscheduler
  saw.threads
ecid: 00026bLgnamBT8IqyoBh6G0002qA000000,0:1812
ThreadID: 106
task: Cache/RoleHierarchyCache



Everything was working perfectly for native users prior  integration with MSAD.


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
References


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