Kbase P110363: Unable to suppress error 11599 when attempting to undo a LOB field in a subtransaction
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/05/2010 |
|
Status: Verified
SYMPTOM(s):
Error 11599 when attempting to undo a LOB field in a subtransaction
Undo of sub-transaction modifying a large object. Backing out transaction (11599)
Error 11599 appears despite using NO-ERROR
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
This is expected behavior.
LOBs cannot be undone in sub-transactions. Whilst the 4GL allows LOB operations in sub-transactions, if the user undoes the sub-transaction then the non-suppressible message 11599 is generated and the whole transaction is undone. Starting with OpenEdge 10.1A, savepoints allow sub-transactions containing changes to LOB fields to be undone without undoing the entire transaction.
FIX:
Option #1
Upgrade to OpenEdge 10.1A or later
Option #2
Do not use LOBs in sub-transactions that could be undone