Kbase P2898: Error 893 when using dynamic queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Error 893 when using dynamic queries
SYSTEM ERROR: strent request for more than 32K. (893)
Using dynamic queries
Using dynamic widgets
Stack trace from _progres shows:
qrGetQuery
qrOpen
dbqry
proqry
Dynamic widgets are not released from memory with the DELETE statement after they have been used
CAUSE:
Dynamic objects are not being released from memory causing the available memory to be consumed. This eventually leads to error 893 because there is no more memory available.
FIX:
The best programming approach is always to free unneeded resources once they are not used any more. When a query is left opened, some resources are allocated to process the query. Freeing these resources that are no longer needed is a good practice and it helps to avoid errors.
Use the QUERY-CLOSE() method and the DELETE OBJECT statement to release the resources when they are no longer needed.
You can use the -debugalert Startup Parameter in way to narrow down to the problem.