Kbase P99818: Index corruption may occur if records are updated within a FOR EACH with BREAK-BY clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/2008 |
|
Status: Verified
SYMPTOM(s):
Updating record within a FOR EACH block
FOR EACH has a BREAK-BY clause
Indexed fields are being updated
WRITE trigger is executed as a result of record update
WRITE trigger returns error condition
FACT(s) (Environment):
Progress 9.1D
All Supported Operating Systems
CAUSE:
Bug# OE00122294
CAUSE:
The bug causes the record and it's index keys to go out of sync.
This will be reported by IDXFIX utility, or by an error "SYSTEM ERROR: Index in for recid could not be deleted. (1422)" the next time the record is updated.
FIX:
Upgrade to Progress 9.1E02 or later
Upgrade to OpenEdge 10.0B03 or later
Workaround:
Add a VALIDATE statement before the end of the FOR EACH block.