Kbase P15248: A call from session write trigger overflows lock table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/08/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
A call from session write trigger overflows lock table
Lock table overflow, increase -L on server (915)
Internal procedure alone works ok
CAUSE:
All the records locked inside the trigger code directly or indirectly by calling a external/internal procedure will remain locked until the end of the trigger block.
FIX:
Call the external/internal procedure which creates or locks records outside the trigger block.