Kbase P127745: Error 1127 when consolidating databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
SYMPTOM(s):
Error 1127 when consolidating databases
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
Consolidating 2 databases into one using dump and load.
After the data is loaded into the database the index rebuild fails with error 1127.
CAUSE:
There are duplicate records in the database and the index creation is failing because there is a unique index defined for these records.
FIX:
Recreate the database and then either:
1. Use a 4GL process that connects to both database and deletes duplicate entries before the data is dumped from one database and loaded into the other.
2. Remove the unique attribute from the index that is causing the index rebuild to fail. Load the data, and then use a 4GL process to delete the duplicates. Re-activate the unique attribute on the index.