SAP Knowledge Base Article - Preview

3690844 - "Query execution failed. Invalid query string." occurred in ADT SQL Console

Symptom

The same SQL statements execute successfully in SAP GUI (DBACOCKPIT > SQL Editor) but fail with errors in ADT (SQL Console).

For example, select * from "SAPHANADB"."/BA1/HFSPD" (this table is only an example)

In ADT, below error is reported:

  • "INTO" is invalid here (due to grammar)
  • Query execution failed
    Invalid query string. Only SELECT statement is allowed.


Read more...

Environment

  • ABAP system
  • ADT (ABAP Development tool)

Product

SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023 ; SAP S/4HANA 2025

Keywords

SQL Console, schema, due to grammar, Query execution failed, Invalid query string, Only SELECT statement is allowed. , KBA , BC-DWB-AIE-DP , Data Preview in ABAP Development Tools in Eclipse , 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.