Kbase P22575: SQL clients recieve The SQL engine Statement Manager stateme
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/05/2003 |
|
Status: Unverified
SYMPTOM(s):
SQL client reports error.
The SQL engine Statement Manager statement cache overflowed. <number> statements are currently in use ( <type of cache> cache). (9799)
SQL Server is terminated.
Set environment variable CACHED_STATEMENTS=500 and problem still occurred.
CAUSE:
Query that was being run was exceeding the statements allowed in the cache.
The default value for SQLStmtCache is 100.
FIX:
Starting database with SQLStmtCache parameter set to 700