Kbase 21554: Error 893 using Dynamic Queries.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/06/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
SYSTEM ERROR: strent request for more than 32K. (893)
Using Dynamic Queries
Stack trace from error 893 shows:
qrGetQuery()
qrOpen()
dbqry()
proqry()
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 you are done. When you open a query, 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.