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.
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.