SAP DBTech JDBC: : internal error: Cannot get remote source objects
Following error is displayed when we are installing database drivers for SAP Smart Data Access in HANA.
"SAP DBTech JDBC: : internal error: Cannot get remote source objects: [unixODBC][Driver Manager]Can't open lib '/usr/local/my_odbc_drivers/instantclient_12_1/libsqora.so.12.1' : file not found"
You are having the above issue because ODBC driver library files must be installed into a location searched by the SAP HANA server.
If these libraries are placed in the SAP HANA "exe" directory, they will be found automatically. However, if they are installed elsewhere, the LD_LIBRARY_PATH environment variable must be altered to specify this location. If this is not done, you may experience messages during SAP HANA smart data access queries stating the "driver could not be loaded".
To resolve this please perform as following:
The LD_LIBRARY_PATH environment variable can be configured by creating or modifying the ".customer.sh" file in the home directory of the SAP HANA administrator user.