Kbase P9747: Delta.sql fails when generating case insensitive indexes.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
Oracle DataServer
SYMPTOM(s):
Delta.sql fails when generating case insensitive indexes.
ORA-01452 - cannot create unique index - duplicate keys found
CAUSE:
There is a limit to our migration utility and the field is not populated automatically.
FIX:
The u##<columnA> column added in the table <tableB> needs to be valued manually, with UPPER(<columnA>) value.
For example:
UPDATE <tableB> SET u##<columnA> = UPPER(<columnA>);