Kbase P152095: Records with LONG columns were being read with exclusive lock and then receiving 1444 upon UPDATE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Records with LONG columns were being read with exclusive lock and then receiving 1444 upon UPDATE
A mandatory field did not get value. (1444)
FACT(s) (Environment):
Happens to only to records that have a LONG column larger than the default size of the bind buffer.
All Supported Operating Systems
OpenEdge 10.1x
Oracle DataServer
CAUSE:
Bug# OE00190509
CAUSE:
Records with LONG columns were being read with exclusive lock and then receiving 1444 upon UPDATE.
The bug happens when fetching the record having a LONG column larger than the default size of the bind buffer. While re-binding the long column because the data can't fit in the buffer, the rebind call incorrectly sends the wrong field position of long column.
Wrong field position to a re-bind OCI call, cause the flag in the adjacent column and the ICB get the corrupted UPDATE flag and that this would fool the UPDATE into thinking it had an update value for a column that was not being updated.
FIX:
Upgrade to OE10.2A03 or higher