Consultor Eletrônico



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