Error "The index cannot be created as the table has duplicate keys" Trying to Apply Patch 23256716 (Doc ID 2269349.1)

Last updated on MARCH 17, 2021

Applies to:

Symptoms

Error on application of the <patch 23256716>:

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.


Use the following SQL statement to identify the duplicate keys:

SELECT EQUIPMENT_ITEM_ID, EQP_SERIAL_NUMBER, count(*)
 FROM GMP.GMP_RESOURCE_INSTANCES
GROUP BY EQUIPMENT_ITEM_ID, EQP_SERIAL_NUMBER
  HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys
  because of the error above

The query above return the line :
EQUIPMENT_ITEM_ID EQP_SERIAL_NUMBER COUNT(*)
1234                        56789                3

Cause

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