3031816 - "ERROR [SQL-608] exceed maximum number of prepared statements" and "the number of prepared statements per connection cannot exceed <number>"

• An error similar to the below can be seen in HANA nameserver trace:

[17685]{100109}[20/-1] xxxx-xx-xx 10:27:37.010951 e EmbeddedAPI Connection.cc(07366) : the number of prepared statements per connection cannot exceed 100000.
[17685]{-1}[-1/-1] xxxx-xx-xx 10:27:37.011687 e STATS_WORKER SQLInterfaceEAPI.cpp(00533) : error calling configurable (4, deletion: no): ERROR [SQL-608] exceed maximum number of prepared statements: "_SYS_STATISTICS"."STATISTICS_PREPARE_CALL_TIMER": line 8 col 1 (at pos 382): exceed maximum number of prepared statements: the number of prepared statements per connection cannot exceed the max statements at SQLScript/Executor/Evaluator/SeEvaluator.cpp:457
exception 1: no.71000608 (SQLScript/Executor/Evaluator/SeEvaluator.cpp:457)
"_SYS_STATISTICS"."STATISTICS_PREPARE_CALL_TIMER": line 8 col 1 (at pos 382): exceed maximum number of prepared statements: the number of prepared statements per connection cannot exceed the max statements



• ABAP dump errors may possibly be observed from ST22 of a Netweaver client also :

Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 13.10.2020 16:10:33
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error "SQL code: 608" occurred while accessing table "EDIDC". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| Database error text: "SQL message: exceed maximum number of prepared |
| statements: the number of prepared statements per connection cannot exceed |
| the max statements"

• SAP HANA Platform 1.0
• SAP HANA Platform 2.0

KBA , HAN-DB-MON , SAP HANA Monitoring , Problem