Consultor Eletrônico



Kbase P15918: Progress 9.1D no patch: The SQL engine Statement Manager statement cache overflowed
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2008
Status: Verified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

The SQL engine Statement Manager statement cache overflowed. <number> statements are currently in use ( <type of cache> cache). (9799)

Error occurs when certain SQL92 statements, specifically blob manipulation or stored procedures, encounter an error during execution

Progress 9.1D only

Same Program was working with no errors in previous versions of Progress

CAUSE:

Bug# 20020206-016

CAUSE:

If certain SQL92 statements, specifically blob manipulation or stored
procedures, encounter an error during execution, that statement will reside
in the statement cache. This leads to a statement cache overflow error.

FIX:

9.1D01 fixes the problem. This fix will evict the offending statement from the
statement cache when this type of error occurs and overflow will not occur.