Kbase P164144: 4GL/ABL: SYSTEM ERROR: This server has too many open cursors
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/15/2011 |
|
Status: Verified
SYMPTOM(s):
4GL/ABL: SYSTEM ERROR: This server has too many open cursors
SYSTEM ERROR: This server has too many open cursors so the cursor creation attempt by user <NUM> at line <NUM> in <NUM>, msgcode <NUM>, ROWID <NUM>, table <num>, index <NUM>. (15093)
SYSTEM ERROR: This server has too many open cursors so the cursor creation attempt by user 122 at line 783 in Z:/vobs_rkt/src/glue
sadb.c, msgcode 50, ROWID 0, table 31, index 74.
Error appears in the database log after code that is creating lots of dynamic queries without properly closing them
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.2B
CAUSE:
A high number of dynamic queries were being opened in the application and never closed.
FIX:
Ensure that all dynamic queries are closed when they are no longer needed.