Kbase P124158: Why doesn't idxfix option #8 "Validate Index Blocks" not detect a 1422 error found in a database log
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/30/2007 |
|
Status: Unverified
GOAL:
Why doesn't idxfix option #8 "Validate Index Blocks" not detect a 1422 error found in a database log file?
FIX:
Idxfix Option 8 will detect if the indices reporting to a specific table have any index corruption. In the case where this is not reporting an error, that is idxfix #8 runs clean, the error in the database log file is probably one of the 1422 errors caused by a failed backout operation. In this case, you should be able to identify this record, remove it via idxfix and recreate it. This 1422 error should be detected by running idxfix #3 " Both 1 and 2 above" which does a scan of records for missing index entries as well as a scan of indexes for invalid index entries.