Create Index CSF_PHONETIC_VALUES_U3 Fails As The Table Has Duplicate Keys
(Doc ID 987878.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Field Service - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to upgrade 12.1.1 the following error occurs:
The table is missing the index CSF_PHONETIC_VALUES_U3
or index CSF_PHONETIC_VALUES_U3 exists on another table.
Create it with the statement:
CREATE UNIQUE INDEX CSF.CSF_PHONETIC_VALUES_U3 ON CSF.CSF_PHONETIC_VALUES
(LANGUAGE, PHONETIC, CODE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4
) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 LANGUAGE, PHONETIC, CODE, count(*)
FROM CSF.CSF_PHONETIC_VALUES
GROUP BY LANGUAGE, PHONETIC, CODE
HAVING count(*)>1
AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above
or index CSF_PHONETIC_VALUES_U3 exists on another table.
Create it with the statement:
CREATE UNIQUE INDEX CSF.CSF_PHONETIC_VALUES_U3 ON CSF.CSF_PHONETIC_VALUES
(LANGUAGE, PHONETIC, CODE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4
) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE
APPS_TS_SEED
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 LANGUAGE, PHONETIC, CODE, count(*)
FROM CSF.CSF_PHONETIC_VALUES
GROUP BY LANGUAGE, PHONETIC, CODE
HAVING count(*)>1
AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above
Changes
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 |
Changes |
Cause |
Solution |
References |