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

Last updated on SEPTEMBER 12, 2019

Applies to:

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

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