Kbase P12441: 1127 messages appear in db log file after a IDXBUILD.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2010 |
|
Status: Verified
SYMPTOM(s):
IDXBUILD of table reports (1127) errors.
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database
CAUSE:
There are duplicate records on unique index keys.
FIX:
Use the proutil dbname -C idxfix utility to delete the duplicate records.
This utility checks the Progress database records and indexes to determine whether an index is corrupt or a record has a missing or an incorrect index. You can specify whether to scan the database, or the indexes, or both. You can run IDXFIX online or offline.
Option 6 is called "Delete one record and it's index entries."
This option prompts you to specify the recid of the record you want to delete. It deletes one record and all its indexes from the database.