Kbase P135958: Undo of delete in subtransaction leaves corrupt index if the record is created and deleted in the sa
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/25/2010 |
|
Status: Verified
SYMPTOM(s):
Undo of delete in subtransaction leaves corrupt index if the record is created and deleted in the same transaction
An ABL client performs the following steps within the same transaction:
A record is created and key values are assigned in a WRITE trigger in one subtransaction
Record is modified in second subtransaction
Record is deleted in third subtransaction
The third subtransaction is undone
Error 1422 happens in the next attempt to update the record
SYSTEM ERROR: Index in for recid could not be deleted. (1422)
FACT(s) (Environment):
After the transaction is committed IDXFIX will report and fix errors on the index
All Supported Operating Systems
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
OpenEdge 10.1C
CAUSE:
Bug# OE00176259
FIX:
Upgrade to OpenEdge 10.1C03 or later release
Upgrade to OpenEdge 10.2A01 or later release
Workaround:
For OpenEdge 10.1A or later, start the client with the -nosavepoint parameter.