Kbase P124048: IDXBUILD generates 1644 errors.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/11/2008 |
|
Status: Verified
SYMPTOM(s):
IDXBUILD generates 1644 errors.
Index rebuild complete. <number> error(s) encountered. (1644)
SYSTEM ERROR: RECID <recid> in <file-name> could not be found. (1645)
Database consistency tools such as dbscan, dbrpr (scan), idxfix and idxcheck does not detect the record corruption.
Using idxfix / idxcheck to scan and fix will not fix the corruption.
FACT(s) (Environment):
Progress 9.1E04 Service Pack
Windows NT 32 Intel/Windows 2000
FIX:
1) Find out the dbkey number from the error messages.
2) Find out what indexes are used by a index report in Database Dictionary
or via the dbanalys.
3) Truncate the database (proutil <db name> -C truncate -G 0)
4) Use dbrpr (proutil <db name> -C dbrpr) alternative 3 (Remove Bad Record
Fragment) in the database repair menu of dbrpr to remove the fragmented
record, specify the dbkey.
5) Remove the correlating indexes by using option 3 (Both 1 and 2 above)
and the some option in idxfix, mention the table and indexes and dbkey as
range.