Kbase 20628: Solutions to Bulk Load a Table into a DB More than Once
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/06/2003 |
|
Status: Unverified
SYMPTOM(s):
Fix RECID <recid>, <file-name> already exists with <field value>. (1127)
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
FIX:
Approaches to resolve the issue of bulk loading a table more than once into a database. When a table is bulk loaded into a database more than once, an index rebuild of the table issues the following error for each duplicate record it finds:
Fix RECID recid, file-name already exits with field-name value (1127).
You must remove the duplicate records but there are no indexes associated with them. You can recover the tables without recreating the database database with one of the following solutions:
- You can delete the records already loaded. Then perform an
index rebuild against the remaining records.
- You have the RECIDs that are duplicates. Use idxfix Option 6 to
enter the RECID of a duplicate that you want deleted.
(This is useful if you only need to remove a couple of
records rather than an entire table).
- Delete the table and reload it from scratch.