Information

Title	Error 8812 for batch client waiting on a record or locked resource

URL Name	P21669

Article Number	000136827

Environment	Product: Progress Version: 9.x Product: OpenEdge Version: 10.x, 11.x OS: All supported platforms

Question/Problem Description

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

Error 8812 for batch client waiting on a record or locked resource.

Steps to Reproduce

Clarifying Information

Error Message	Lock wait timeout of seconds expired (8812) Lock wait timeout of 1800 seconds expired (8812)

Defect Number

Enhancement Number

Cause

There is no user interface available to display messages or to cancel the wait within batch clients, therefore the session is terminated after exceeding 30 minutes.

Resolution

Change the 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. Please keep in mind that this change can result in dirty reads (data which is in the process of being modified and which has not yet been committed to the database).

Workaround

Notes

References to other documentation:

OpenEdge® Application Server: Developing AppServer Applications, Chapter 4, "Design and Implementation Considerations" > "Transaction and record management considerations" > "Managing conflicts between client and AppServer"

Progress Article(s):
What is the -lkwtmo parameter used for?

Keyword Phrase

Last Modified Date	11/20/2020 7:26 AM