Kbase P24193: Cache Overflowed (9799) error on exceeding prepared statements limit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/02/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
SQL Engine Statement Mgr Statement Cache Overflowed. (9799)
CAUSE:
The number of SQL-92 prepared statements exceeded the default number allowed by the Progress SQL-92 engine Statement Manager of 100.
FIX:
The change the default number of prepared statements allowed by the Progress SQL-92 engine, set the environment variable, CACHED_STATEMENTS on the SQL-92 Server machine to increase this default limit:
CACHED_STATEMENTS=500
The maximum limit to the number of prepared statements is 1000 at this time. The actual number is subject to the available resources on the machine involved.