My Oracle Support Banner

LDAP User Login Successfully but Will Be Recorded to Auth_failed Table (Doc ID 2308726.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


Actual Behavior
When LDAP user logins successfully to Web Client, below it will always be recorded in AUTH_FAILED table.

AUTH_FAILED.REASON column has the following message inserted.

This issue occurs only on LDAP user and for non-ldap user such as admin user, it will not be reproduced.

Expected Behavior
When LDAP user logins successfully to Web Client, no new record should be inserted to AUTH_FAILED table


  1. Configure active directory LDAP setting on Java Client and WebLogic admin console
  2. Restart Application Server
  3. Sync LDAP user and change to active for ldap user : user1
  4. Log into Web client with ldap user : user1. Could login without any error message in the UI.
  5. Run the following SQL in agile database.

    select * from Auth_Failed where username = 'user1' order by created desc;

    ID          USERNAME    REASON                                                                                          FAILURE_DT
    6018627 user1           com.agile.resources.PCMessagesI18N::APDM_INVALIDPASSWORD[[]]    23-AUG-17


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

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