My Oracle Support Banner

Create Index CSF_PHONETIC_VALUES_U3 Fails As The Table Has Duplicate Keys (Doc ID 987878.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Field Service - Version 12.1.1 and later
Information 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




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


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