Kbase P21524: Authorization error 4296 with AS/400.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
OS/400 V4R5 and above
SYMPTOM(s):
Random authorization problems when connected to the AS/400 database
The DataServer version 8.0C60 and above
Authorization error attempting to <update> <Customer-Table> (4296)
CPF5027:Record <recno> in use by job <jobid>/<username>/PROSERVER
CPF5032:Record <recid> member <table> already locked to this job
When trying to lock the same physical record on the AS/400 via two buffers the 4296 error can occur.
CAUSE:
Problem happens when the table accessed has two identical unique indexes, that is two (or more) indexes with the same fields but in different order. One of the indexes already has a lock on the record and so the error appears.
FIX:
Workaround is to specify the same index with USE-INDEX when trying to lock the record.