Kbase P162479: Getting 1127 errors when rebuilding an index for a table.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2010 |
|
Status: Unverified
SYMPTOM(s):
Getting 1127 errors when rebuilding an index for a table.
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
FACT(s) (Environment):
Table does not contain duplicate records.
Progress 9.1D
Windows
CHANGE:
Added a primary unique index to a table in the database.
CAUSE:
A primary unique index was created for a table on a field that did not contain unique information.
FIX:
1. Identify another field to be the primary index.
To do this you need to Go into Tools -> Data Dictionary. Then select Options -> Index Mode. Now select the table that has the wrong index identified as the Primary Unique Index.
Either select another index and make it the Primary index, or Create a new index and make it the Primary index.
2. Once a different index has been identified as the Primary index, the original index that was listed as a Unique index (when it shouldn't have been) can now be deleted.
3. If an index is still desired on the original field, then once the index is deleted as stated in step 2, a new index can be created for that field. This time making it a non-unique index.