SAP Knowledge Base Article - Preview

3672343 - SQL Execution Error due to 'Maximum Number of Characters for Multiple Statement Execution' in HANA Studio

Symptom

  • When executing a large number of SQL statements in HANA Studio's SQL console window, the following error occurred:

===========================================

Could not split statements; SQL console content is too large

Could not execute 'INSERT INTO ...'

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "INSERT": line x col x 

===========================================

  • The issue did not occur during execution of the SQL separately.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA Studio (Eclipse) Admin Tooling
  • SAP HANA, platform edition

Product

SAP HANA studio all versions ; SAP HANA, platform edition all versions

Keywords

sql execution error, hana studio, maximum number of characters, multiple statement execution, sql console, sap dbtech jdbc, syntax error, insert statement, parsing error, hana studio settings, out-of-memory error, sap hana cockpit, sap business application studio, supportability tools , KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , HAN-DB , SAP HANA Database , 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.