Author
ADBC_TEST_CONNECTION failed due to "Couldn't load library" error While testing HANA DB connection from Solman to managed system.
B Thu Mar 17 16:48:52:454 2022
B Loading DB library '/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so' ...
M *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so") FAILED
"libSQLDBCHDB.so: cannot open shared object file: No such file or directory" [dlux.c 550]
M {root-id=0050569B3EBD1EDCA6DFAC01A71270F8}_{conn-id=6220EF4CCF0B5E29E10000000ACCE034}_1
B *** ERROR => Couldn't load library '/usr/sap/<SID>/SYS/exe/run/dbhdbslib.so'
[dbcon.c 7086]
B ***LOG BYG=> could not load library for database connection ABP [dbds 972]
B ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 2063]
B *** ERROR => Unexpected RC when calling dsql_connect
[dbacds.c 2064]
B
B Thu Mar 17 16:48:55:896 2022
B dbsync[db_syexe]: wait=0, call_no=79848, current_ts=20220303082355, last_counter=2022-03-03-14.19.16.321299
Solution:
Add an equation mark between the OS variable and its value, and restart the application server to take it effect.
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/sap/<SID>/hdbclient
export PATH=${PATH}:/usr/sap/<SID>/hdbclient