Kbase P161203: Error 9799 occurs when executing SQL queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 9799 occurs when executing SQL queries
The SQL engine Statement Manager statement cache overflowed. <number> statements are currently in use ( <type of cache> cache). (9799)
The SQL engine Statement Manager statement cache overflowed. 0 statements are currently in use ( chst free_lru cache). (9799)
SQL logging shows error code -210048 when a SQL query fails
Database log file shows multiple 9799 entries
_SQLSRV2 process eventually crashes
Stack trace from _SQLSRV2 reads:
lkrestore
dsmObjectUnlock
do_ix_scan_fetch
ix_scan_fetch
Database remains running and a new _SQLSRV2 process is spawned
FACT(s) (Environment):
Setting -SQLStmtCache and -SQLCursors parameters has no effect
Running 10.1B01
OpenEdge 10.1B
All Supported Operating Systems
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Upgrade to 10.1B03