Kbase P159170: Run stored proc with view as buffer does not return records when there are records meeting select cr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/02/2010 |
|
Status: Unverified
SYMPTOM(s):
Run stored proc with view as buffer does not return records when there are records meeting select criteria
Occurs when there is high CPU utilization on the server side
Occurs when the record has lock wait timeout error
FACT(s) (Environment):
Windows
OpenEdge 10.x
MS SQL DataServer
CAUSE:
There are CPU intensive process running on the SQL server side, and the intended records were locked
FIX:
Add check in ABL code for all messages in stored procedure, and deal with lock wait error when the error is caught