Kbase P76963: Getting error 3736 in Database log file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/09/2009 |
|
Status: Verified
SYMPTOM(s):
Getting error 3736 in Database log file
bad lkclrels call: pusr->uc_qwait2 is NULL (3736)
FACT(s) (Environment):
All Supported Operating Systems
CAUSE:
A client is executing a FOR EACH against a Virtual Systems Table(s) (VST) without specifying the NO-LOCK option.
The following is an example of code that produces this error:
FOR EACH _connect BY _Connect-Time DESCENDING:
DISPLAY _connect-ID
_connect-Device
_connect-Time.
END.
The modified code which does not result in the error follows:
FOR EACH _connect NO-LOCK BY _Connect-Time DESCENDING:
DISPLAY _connect-ID
_connect-Device
_connect-Time.
END.
FIX:
Add NO-LOCK to all queries on VST tables