OID 11g Erroneous "LDAP: error code 19 - Attribute Uniqueness Constraint Violation" When Trying to Re-Add an Entry After bulkdelete
Last updated on JULY 09, 2018
Applies to:Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g bulkdelete tool is not removing all the records from OID Database (DB) related tables when an entry having an unique attribute defined is processed.
Once a unique attribute is defined in OID and an entry is added, a record is also added in OID uniqueness related table for that particular entry. If that entry is then deleted using bulkdelete tool, the entry from the table is not deleted.
Later on, if the same initial entry is added again in OID using ldapadd, Oracle Directory Services Manager (ODSM) or another ldap method, an LDAP 19 error then occurs.
Steps to Reproduce:
1. Create an uid_unique - Attribute Uniqueness Constraint, with Unique Attribute Subtree - cn=Users, dc=example,dc=com.
2. Create a test user in ODSM.
3. Use bulkdelete command such as below to delete this particular user:
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