Kbase P6709: Getting error 9799 in database log file after SQL client application runs fine for a while
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/16/2008 |
|
Status: Verified
SYMPTOM(s):
Using SQL client application
Getting error 9799 in database log file after application runs fine for a while
[JDBC Progress Driver]:SQL engine Statement Mgr statement cache overflowed. 100 statements currently in use (uid cache). (9799)
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Not properly closing open cursors after using them.
FIX:
Option #1
Increase the number of cached statements and open cursors when database broker is started using the -SQLStmtCache and -SQLCursors parameters:
proserve <database> -S <port> -H <hostname> -SQLStmtCache 500 -SQLCursors 400
Please be aware that the number of open cursors can never exceed the number of cached statements.
Option #2
Review the code and make sure the cursors are properly closed by calling <cursor>.close() method.