Cannot iterate over result set rows: SAP DBTech JDBC: [257] (at 197): sql syntax error: incorrect syntax near "WITH": line 1 col7 (at pos 196).

Updated May 18, 2018

Hello SAP Experts,

When starting the script HANA_Configuration_Parameters_1.00.70+ from the SQL statement from SAP Document 1969700 I am getting the following error:

"Cannot iterate over result set rows: SAP DBTech JDBC: [257] (at 197): sql syntax error: incorrect syntax near "WITH": line 1 col7 (at pos 196)"

The error can be regenerated by following steps:

From the SAP Document 1969700 please download the latest Statements.zip
Now please open SAP HANA Studio -> System Information tab.
Now Right click and press "Import SQL Statment".
Now after starting the script HANA_Configuration_Parameters_1.00.70+ the above mentioned error occurs.

Comments

21 Dec 2016 1:19 pm Chandan Singh Parihar Helpful Answer

The error you are facing is a common error. HANA Studio automatically adds "SELECT TOP 99999999" before the relative SQL while executing it from "System Information" Tab.
The SQL mentioned by you begins with "WITH Clause" which is the main cause of this error because select top 99999 (with xxxx) is not the correct SQL.

21 Dec 2016 1:19 pm Jyoti Pandey Helpful Answer

In order to resolve this error instead of opening the script in System Information tab please open it in the SQL Console and execute it as a workaround.