ADBC_TEST_CONNECTION failed due to "Couldn't load library" error

 

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