Kbase P18810: Idxfix reports inconsistency in record amount.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/16/2009 |
|
Status: Unverified
SYMPTOM(s):
Idxfix produces error and record inconsistency.
SYSTEM ERROR: RECID <recid> in <file-name> could not be found. (1645)
Idxbuild completed successfully.
IDXfix ran against database.
SYSTEM ERROR: Index <index-num> (<owner-name>.<table-name>, <index-name>) contains <entry-count> entries, but <record-count> records found. (8779)
SYSTEM ERROR: Index 466 (PUB.movement-s, movement-s) contains 6097552 entries,
but 6097553 records found. (8779)
Dumped table that reported the inconsistency and it contained 6097552 records and not 6097553.
Load of table into new database unable to reproduce the problem.
Deleted table in production , reloaded the table, and problem still appears.
Run proutil dbname -C DBRPR to scan database for fragmented records.
DBRPR reports:
ERROR: Bad File Number: 0 Len:0 Scan @ dbkey 22282240
CAUSE:
Record Corruption.
FIX:
Run Idxfix and choose option 6 to delete the record and its index entry.