Consultor Eletrônico



Kbase P21669: 8812 error for batch job waiting on record or locked resource
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   4/14/2010
Status: Verified

SYMPTOM(s):

Background job gets this error which results in the process being killed.

Lock wait timeout of seconds expired (8812)

Lock wait timeout of 1800 seconds expired (8812)

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Database
OpenEdge Category: Language (4GL/ABL)

CAUSE:

Batch mode - We have no user available to display messages or to cancel the wait. Therefore we terminate after exceeding 30 minutes.

FIX:

Change code to either do a no-lock no-wait call for the function that the client is running or a no-lock no-wait and no-error combination.