Kbase P22405: Lock wait timeout error with batch job - error 8812
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
SYMPTOM(s):
Lock wait timeout of seconds expired (8812)
Error 8812 running batch process
FACT(s) (Environment):
All Supported Operating Systems
CAUSE:
The error will occur with a batch job if there is a lock conflict and it is a batch mode job. Because the job is being run in batch mode, there is no way to clean up or cancel the wait for the specific resource. Therefore the job will wait until the lock wait timeout has been exceeded and will then terminate with the 8812 error.
FIX:
Change the code being executed by the batch job so that it performs a no-lock, no-wait option to the 4GL statement being issued. Please keep in mind that this change can result in reading dirty data (data which is in the process of being modified).