Following error occurs when we are executing a HANA catalog import at HANA Revision 1.00.69 or lower, import ... from '<import_path>',
Could not execute 'import all from ...' ... .
SAP DBTech JDBC: : general error: SBOCOMMON.ETL_S <SCHEMA>:<TABLE> not found in the import directory.
You are getting this error due to code defect, foreign key relationships are missing in the export file.
To resolve this issue kindly apply HANA Revision 69.1 or higher.
Please use the following workaround:
Perform a catalog export to a Linux directory <export_dir> on the source host.
Execute the repair script sap_1981315_fix_dependencies.sh in the Linux directory <export_dir>.
If the exported data are imported to a target host, zip the directory <export_dir>, move it to the target host, and unzip it to a Linux directory <import_dir>.
Perform a catalog import from the directory <import_dir> if the archive is copied from the source host to a target host, or from the <export_dir> if the data are re-imported on the source host.
Do not execute the shell script sap_1981315_fix_dependencies.sh after zipping the directory on a Windows host because lowercase and uppercase characters will be changed.