You want to import a csv file into HANA database. The import is interrupted due to below error,
Could not execute 'IMPORT FROM CSV FILE '/FolderA/itsiti.csv' INTO ITSITI."TableA" WITH RECORD DELIMITED ...'
SAP DBTech JDBC: [2]: general error: Cannot load table from the specified path - /FolderA.
Please check configuration: csv_import_path_filter.
Solution
The workaround taken from SAP Note 2338738,
The ‘/usr/sap/XXX/HDB00/work’ should belong to list of path filters by default for instance XXX. Check path filter is updated without any other configurations and any mistakes like importing at another instance except XXX or the permission of issued path has updated.
You can execute below command to get rid of the error,
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'system') set ('import_export', 'enable_csv_import_path_filter') = 'false' with reconfigure;
Alternatively, you can update the parameter in the Configuration tab from SAP HANA Studio. Use the keyword “csv” to filter the search.
SAP Note
- 2338738 – Cannot load table from the specified path
- 2109565 – Potential information disclosure relating to IMPORT FROM statement in SAP HANA.
