Kbase P14682: Workaround: Errors when delta.df has multiple indexes of the same table with duplicate INDEX-NUM
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.1x
SYMPTOM(s):
Errors 132 and 185 occur when loading the delta.df to the schema holder
** <file-name> already exists with <field/value...>. (132)
** Field <field-name> is a component of an Index. (185)
Duplicate INDEX-NUM in delta.df
Multiple indexes of the same table have the same INDEX-NUM
Multiple indexes of the same table are being added to existing tables in delta.df
Cannot install Progress 9.1D05
CAUSE:
Bug# 20030106-040
CAUSE:
The duplicate numbers are being caused when new indexes are being added to an existing table. If only one index is added, it is fine but any more than one will result in duplicate numbers.
FIX:
Remove duplicate INDEX-NUMs.
1. Dump the definition for the table.
2. Modify, within <table>.df, INDEX-NUM so that there is no duplicate
3. Drop the table from the Data Dictionary
4. Load the modified <table>.df
5. Recompile the programs which access the table