Verification of Schema failed due to connection issues

[Former Member]

Hi

we are trying to connect HANA server for SLT replication. we are following below steps.

1. execute t-code ltr

2. login with userid

3. we got "Configuration and Monitoring Dashboard for HANA" windows in browser.

4. here we clicked on New button.

here system is asking for below details and we entered as follows;

General Data:

              Schema Name: SYSTEM

               Applicaton: (blank)

               Number of Replay jobs: 02

Connection to Source System:

     RFC destination: SIDCLNT100

Connection to HANA system:

     system user name: SYSTEM

     password: password

     Host name: hostname of hana

     Instance Number: nn

after we enter the above details we are getting below error in the same screen;

   Errors in setting connections

  Verification of Schema failed due to connection issues

and we can see the below error in SM21 in source system;

   No shared library found for the database with ID TMPUSERID2

   Unexpected return value 8192 when calling up DBDS

we did some research for "no shared library error". according to research we have downloaded db library file of hana (for linux platform) and copied it in to source system DIR_LIBRARY folder. also we set DIR_LIBRARY environment variable, restarted the application server. still getting the same issue.

please help us to resolve this issue.

regards,

saperrors.com

[shauking]

Hi, please follow the steps in the SAP Note 1597627 - SAP HANA connection to configure the DB connection to the HANA system.  The trick is that after adding the HANA client software path to the <sid>adm PATH environment, you will need to restart the LT system to make it effective.  It works perfectly for me.

Good luck,

Jerry

[Former Member]

Hi saperrors.com,

Just a small suggestion from my side.

Please crosscheck your environmental variables.

Just type "env" from putty by switching to <SID>adm user.

Then crosscheck the below three important parameters :

1. dbms_type=HDB

2.SAPSYSTEMNAME=<SID>

3. LD_LIBRARY_PATH=/usr/sap/<SID>/DVEBMGS00/exe:/usr/sap/<SID>/SYS/exe/hdbclient:/usr/sap/<SID>/SYS/exe/run

Also please check the DB and CI connection by using R3trans -d and look in "trans.log" under /usr/sap/<SID>/home for error logs.

With Regards,

Hari Kiran P

[former_member182277]

Hello,

Please check your RFC connection between ECC system and SLT.

Please check the role of the user in SU01 transaction.

Check the SAP_SLOP_USER under PFCG transaction. User and authorization tab should be in gree.

Please find the following link for more details.

http://help.sap.com/hana/hana_slt_tom_en.pdf

Hope it is helpful.

Regards,Neha

[Former Member]

Hi Neha,

we have assigned SAP_SLOP_USER role. then also we are getting same error.

regards,

saperrors.com

[former_member182277]

Hello,

Please check your RFC connection bcecause when connection setup then by default DD02L and DD02T will replicate to SAP HANA.

Regards,Neha

[Former Member]

Hi,

Have you installed the HDB client in your SLT system?(If yes,which revision?)

Is your RFC connection between Source and SLT and DB connection between HANA and SLT working fine?

HANA-->SLT connection check: In SLT system,transaction DBCO, create a new(temporary) connection  for your target HANA system and test the same with program 'ADBC_TEST_CONNECTION' (tx: SE38)

Let us know the result of above tests to proceed further..I assume you are using HANA SP03 with DMIS SP05 with all additional notes applied.

Regards, Rahul

[Former Member]

Hi Rahul,

we have installed HDB client.not sure about version. i found HDB_CLIENT:10xxx in label.asc file.

we have created temporary  hana connection using DBCO t-code. when we test using ADBC_TEST_CONNECTION we found below error in dev_w0 file (test was not successful)

Loading DB library 'D:\usr\sap\SID\DVEBMGS00\exe\dbhdbslib.dll' ...

M  *** ERROR => DlLoadLib()==DLENOACCESS - LoadLibrary("D:\usr\sap\SID\DVEBMGS00\exe\dbhdbslib.dll")

  Error 126 = "The specified module could not be found." [dlnt.c       255]

M  {root-id=00270E0DFC601ED1A292EEFBC4E94F37}_{conn-id=00270E0DFC601ED1A292EF4FCFCB6F37}_1

B  *** ERROR => Couldn't load library 'D:\usr\sap\SID\DVEBMGS00\exe\dbhdbslib.dll'

[dbcon.c      5646]

B  {root-id=00270E0DFC601ED1A292EEFBC4E94F37}_{conn-id=00270E0DFC601ED1A292EF4FCFCB6F37}_1

B  ***LOG BYG=> could not load library for database connection TMPUSERID2 [dbds         862]

B  ***LOG BZY=> unexpected return code 8192       calling DBDS       [dbacds       1536]

i think if we can resolve the issue the connection will work.

please help us to resolve this issue.

regards,

saperrors.com

[Former Member]

HI,

Is your SAP HANA DBSL (i.e. hdhdbslib.dll) existing at the specified location?

Try this:

1. add hdbclient path(eg:D:\usr\sap\<SID>\hdbclient) to PATH environment variable with <sid>adm user.

2.  If it does not help copy this 'dbhdbslib.dll' and libSQLDBCHDB.dll to 'D:\usr\sap\SID\DVEBMGS00\exe\' and set PATH variable to this location.

After setting the parameter restart your instance once and then try...

Regards, Rahul

[Former Member]

Hi Rahul,

we downloaded dbsl file (hdhdbslib.dll) of linux version and windows version (x64) and copied it in to kernel folder.

the hdbclient location is C:\Program Files (x86)\SAP\hdbclient. we set this path to environment variable path;

we copied hdhdbslib.dll and libSQLDBCHDB.dll files to D:\usr\sap\SID\DVEBMGS00\exe location and restarted the server.

still getting same issue. Please help.

regards,

saperrors.com

[Former Member]

Hi,

You do not need the linux dbsl file as your SLT is on windows.

There can be 2 reasons for this issue:

Either the HANA DBSL has not been installed properly( refer to note 1597627 for details)

Or it could be related to HDB client installation issue, and proper setting of PATH environment variable.

You can try upgrading the kernel to a higher version and if it doesnt help please raise a message with SAP, as it will need system access to find the root cause.The above mentioned were generic solutions which usually work.

Regards, Rahul