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

Last updated on MAY 23, 2017

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.1.1 and later
Information in this document applies to any platform.

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

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