Kbase P3374: Random authorization problems when connected to the AS/400 d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
OS/400 V4R5
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Random authorization problems when connected to the AS/400 database
The DataServer version 8.0C60
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
The problem may occur randomly and if the client session is restarted it may work correctly.The issue does not appear when using version 9.1C of the DataServer
CAUSE:
Bug# 19980429-003
CAUSE:
Problem happens when the table accessed has two identical unique indexes, that is two (or more) indexes with the same fields in it but in different order
FIX:
Upgrade to 9.1C of the DataServer