Kbase P66804: SYSTEM ERROR: Ixundo failed in ixdel because it was unable t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/14/2004 |
|
Status: Unverified
SYMPTOM(s):
Crash recovery fails with error (5022)
SYSTEM ERROR: Ixundo failed in ixdel because it was unable to find the key to delete in index number <index number>. This Index may have an incorrect key. (5022)
CAUSE:
An attempt to back out an addition with a deletion failed due to the fact that the key to be backed out could not be found in the index. This may indicate that there is index corruption and this can be corrected by rebuilding the index. However, execution can continue.
D
FIX:
To get the table name that corresponds to the index number execute the following 4GL command on the DB:
FOR EACH _index WHERE _index._idx-num = <index number>: DISPLAY _index.
Example:
FOR EACH _index WHERE _index._idx-num = 9: DISPLAY _index.
Once you got the name of the index you can rebuilt it by running either
proutil <your DB> -C idxfix -TB 24 -TM 32
or
proutil <Your DB> -B 2000 -C idxbuild -TB 24 -TM 32