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:
Oracle Process Manufacturing Process Planning - Version 12.1.1 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |