Kbase P8690: Running an Index utility reports a 210 error on a specific Index entry.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
Progress/OpenEdge Versions
SYMPTOM(s):
Error 210 occurs while compressing one specific index.
SYSTEM ERROR: attempt to read block <number> which does not exist (210).
SYSTEM ERROR: Attempt to read block 202443009 which does not exist. (210)
Ran Index compression on all the indexes in a specific area.
Proutil dbname -C idxcompact
PROGRESS stack trace Command line arguments are
/usr/opt/91b/bin/_proutil /database/dbname -C idxcompact
uttrace()
utcore()
drexit()
msgout()
msgnCB()
msgCB()
dsmFatalMsgnCallBack()
bmLockBuffer()
cxGetIndexBlock()
cxGetIndexBlock()
cxCompactIndex()
dsmIndexCompact()
upixcomp()
drprutil()
main()
_start()
CAUSE:
Index Corruption.
FIX:
1. Ensure the Database is shutdown.
2. Perform a Database Backup.
3. Rebuild all the indexes or the specific index that reported the error message.
syntax: proutil <dbname> -C idxbuild
When the index rebuild completes the bad index should be cleared.
4. Verify the corrupt index has been removed by re-running the program that prompted to the error.