Kbase P7623: Errors 396 and 142 when trying to add/update any record.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/24/2009 |
|
Status: Verified
SYMPTOM(s):
Errors 396 and 142 when trying to add/update any record.
<filename> record has NO-LOCK status, update to field not allowed. (396)
Unable to update <filename> Field. (142)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
-NL startup parameter set on client
FIX:
-NL parameter means NO-LOCK record access. When set, any database operation that doesn't have a locking level specified to get the NO-LOCK default for any procedure instead of a SHARE-LOCK.
If add/update records need to be updated, either don't set this parameter or specify the appropriate locking level in the code.