OID 11g Erroneous "LDAP: error code 19 - Attribute Uniqueness Constraint Violation" When Trying to Re-Add an Entry After bulkdelete (Doc ID 2420157.1)

Last updated on JULY 28, 2020

Applies to:

Symptoms

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:

Changes

Cause

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