Symptom
- 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"
""> Read more...
Environment
- SAP HANA Platform 1.0
- SAP HANA Platform 2.0
Product
Keywords
KBA , HAN-DB-MON , SAP HANA Monitoring , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.