Intermittent Login Issues In the OBIEE 11g Environment With AD LDAP Authenticator

(Doc ID 1556461.1)

Last updated on MAY 14, 2017

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

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