DBA cockpit connection test fails - HANA DB to Sybase DB

[satish_kumar166]

We have a solution manager running on HANA DB and managed system running on Sybase - ASE 16. During MSC, the step DB parameter - Set DBA connection fails. When checked in the Solution manager - DBA cockpit - connection test to Sybase DB, the connection test fails with error " ERROR Database connection JP1: ADBC error 'Internal error 16 has occured' . The dev_w* trace shows :

*** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libsybdrvodb8.so") FAILED
libsybdrvodb8.so: cannot open shared object file: No such file or directory" [dlux.c 550]
*** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libsybdrvodb.so") FAILED
libsybdrvodb.so: cannot open shared object file: No such file or directory" [dlux.c 550]
Could not load SYB library libsybdrvodb.so. No database connection possible.
Load of odbc driver for Sybase ASE failed. Connect terminated.
***LOG BYI=> connect failed for connection PA1 [dbds 999]
***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 2054]
*** ERROR => Unexpected RC when calling dsql_connect.

I'm not sure if Sybase DB client is installed in Solution manager (HANA DB).

Would you please tell how to find if the Sybase client is installed in solution manager. If not , provide the steps / wiki to install and what version of Sybase client needs to be downloaded. Our solution manager is on distributed environment. HANA DB and Applications are on different hosts.

Please share your inputs.

Regards,

Satish

[harshita-2605]

Hi Satish, Did you get to know how to connect sybase DB Managed system to HANA DB SolMan?

If yes, Can you please share your views on it.

[victoria_normand]

Hi Satish,

You should have the DBClient AND DBSL installed on your Solman server, both.
The DBSL should be located here: /usr/sap/<SID>/SYS/exe/run ( or <drive>:\usr\sap\<SAPSID>\<Instance>\exe for Windows).

If the DBClient / ODBC driver is installed, the directory should be specified under environment variable PATH (for Windows), LD_LIBRARY_PATH (for Linux), LIBPATH (AIX), SHLIB_PATH (HP-UX).

You'll have all those details in SAP Note 1532253 - SYB: Remote DB Monitoring for SAP Sybase ASE.
Also please take into account that at least one instance of the SAP Solution Manager needs to run on a platform supported by SAP ASE. Details in PAM or SAP Note 1554717.

Best regards,
Victoria.