SAP Knowledge Base Article - Preview

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

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.