Kbase P10441: Remote server get error 893 because of too many left open queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/15/2006 |
|
Status: Verified
SYMPTOM(s):
Client session dies
Client server connection to a database
SYSTEM ERROR: Strent request for more than 32K (893)
Error message only in log file of the Database
Stack trace from _mprosrv reads: strentd strent qrGetQuery qrOpen
CAUSE:
Too many queries are left open on the remote server, because they are not closed properly on the client side. Then the mproserve process crashes.
FIX:
Find out in the code the queries that are left opened and manage to close them. Using the new Debugger (9.1D06 or later version) with Dynamic Object Tracking can help to identify the offending queries.
Note that investigations are easier since OpenEdge 10. See Progress Solution P100791 It is easier to investigate a dynamic query leak situation since OpenEdge 10