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 for Me (Login required).

Search for additional results

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