Kbase P60282: Error 2699 when trying to update / delete a specific record
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/27/2005 |
|
Status: Verified
SYMPTOM(s):
SYSTEM ERROR: proixdel failed for word indexing of array (2699)
Word index corruption
Error 2699 when trying to update / delete a specific record.
Error 2699 after creating records and assigning values in multiple subtransactions.
Stack trace from _progres reads:
kmwkyact
kmWordsAct
kmwkdel
kmkdel
Occasionally records are skipped by FIND, FOR EACH or QUERY with a CONTAINS clause.
CAUSE:
Bug# 20020626-005
CAUSE:
Error 2699 is the consequence of a Progress bug occurring some time earlier and corrupting the word index.
In this case the actual bug occurs when in the same transaction changes to a word-indexed field are undone and further changes to that field are committed.
Any new index keys that should be generated as a result of the second change will not be created.
The error 2699 will occur when one of the words for which the relevant word-index key was not created is modified or removed from the field, as at this time an attempt is made to delete a non-existing index key.
FIX:
Upgrade to 9.1D08, 10.0A or later release
This will fix the bug, and thus will prevent further corruption of the index.
Any existing corruption will still need to be fixed using the IDXBUILD or IDXFIX tools.