Kbase P43812: Receiving Lock table overflow when running programs in versi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/25/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Receiving Lock table overflow when running programs in version 9.1D that ran fine in version 8.3A
Lock table overflow, increase -L on server (915)
CAUSE:
The main program did a FIND FIRST ... NO-ERROR (which causes a share lock) followed by other code the updated the table (which caused an upgrade to exclusive lock). After the upgrade was started several subprograms were executed which made massive modifications to the database.
FIX:
Modify the main program so that the record which is scoped to the entire procedure has its transaction scope reduced by causing several transactions to be initiated and terminated rather than creating a transaction which spans the entire procedure.