No connect due to DbSl Load Lib Failure - tp error in SPAM/STMS

[Former Member]

Hi Experts,

We have planned for Support pack upgrade on our SAP ECC Development

System, but unfortunately we have ended up with the tp error under CHECK_REQUIREMENTS phase :

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to SID failed

Environment variables dbms_type, DIR_LIBRARY and LD_LIBRARY_PATH are

properly set for <sid>adm user when I check it from OS level:

HOSTNAME=hnpclecd

SHELL=/bin/bash

TERM=xterm

HISTSIZE=1000

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

USER=ecdadm

LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:

MAIL=/var/spool/mail/ecdadm

PATH=/sybase/ECD/ASE-15_0/jobscheduler/bin:/sybase/ECD/ASE-15_0/bin:/sybase/ECD/ASE-15_0/install:/sybase/ECD/DBISQL/bin:/sybase/ECD/OCS-15_0/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/ecdadm/bin:/usr/sap/ECD/SYS/exe/uc/linuxx86_64:/usr/sap/ECD/SYS/exe/run:/home/ecdadm:.

PWD=/usr/sap/trans/log

LANG=en_US.UTF-8

KDE_IS_PRELINKED=1

KDEDIRS=/usr

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

HISTCONTROL=ignoredups

SHLVL=4

HOME=/home/ecdadm

LOGNAME=ecdadm

QTLIB=/usr/lib64/qt-3.3/lib

LESSOPEN=|/usr/bin/lesspipe.sh %s

DISPLAY=localhost:10.0

G_BROKEN_FILENAMES=1

_=/bin/csh

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

GROUP=sapsys

HOST=hnpclecd

REMOTEHOST=10.66.30.251

SAPSYSTEMNAME=ECD

DIR_LIBRARY=/usr/sap/ECD/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/ECD/SYS/global/security/rsecssfs/data

RSEC_SSFS_KEYPATH=/usr/sap/ECD/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=1

LD_LIBRARY_PATH=/usr/sap/ECD/SYS/global/syb/linuxx86_64/sybodbc:/sybase/ECD/ASE-15_0/lib:/sybase/ECD/OCS-15_0/lib:/sybase/ECD/OCS-15_0/lib3p64:/sybase/ECD/OCS-15_0/lib3p:/usr/sap/ECD/SYS/exe/run:/usr/sap/ECD/SYS/exe/uc/linuxx86_64

SYBASE_JRE7_32=/sybase/ECD/shared/JRE-7_0_7_32BIT

SYBASE_JRE7=/sybase/ECD/shared/JRE-7_0_7_64BIT

SYBASE_JRE7_64=/sybase/ECD/shared/JRE-7_0_7_64BIT

SYBASE_OCS=OCS-15_0

INCLUDE=/sybase/ECD/OCS-15_0/include:

LIB=/sybase/ECD/OCS-15_0/lib:

SYBASE=/sybase/ECD

SYBASE_ASE=ASE-15_0

SYBROOT=/sybase/ECD

SYBASE_JRE_RTDS=/sybase/ECD/shared/JRE-7_0_7_64BIT

SYBASE_WS=WS-15_0

dbms_type=syb

dbs_syb_schema=SAPSR3

dbs_syb_server=hnpclecd

dbs_syb_dbname=ECD

dbs_syb_port=4901

However, when I check the environment variables from R3 end for env the necessary parameters are not set and R3trans -d  end up with error ?????

Absolutely no clue how it is differing from OS level to R3 !!!

Also we have upgraded the kernel, tp and DB Library files from 720 to

721_EXT butstill the same error.

Please advice how to avoid this error.

Regards,

Srikanth

[Reagan · Accepted solution]

HOSTNAME=hnpclecd
SHELL=/bin/bash
TERM=xterm

Any reason why you are using the bash SHELL for the ecdadm user?

Maybe this could be the reason why you having this error.

202227 - Recommended login shells

Use C-Shell (csh) and restart SAP

Regards

RB

[Former Member · Accepted solution]

Hi RB,

We have already resolved the issue changing it to csh shell. Anyways I have awarded full points to you.

Thanks for your help

Regards,

Srikanth G

[Sriram2009]

Hi Srikanth

Could you refer the SAP Note

  1966797 - Errors: connect failed due to DbSL load lib failure

  1817743 - ERROR: No connect due to DbSl Load Lib Failure - With tp version 380.03.89

BR

SS

[former_member188883]

Hi Srikanth,

Can you check the R3trans -d from Operating system level and share relevant logs.

If possible restart the application and database and check the results.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Srikanth,

     As per snap, please set the "dbms_type" variable in OS level..

If your database is Oracle, the value is "ORA"..

And share the trans.log for further analysis..

Regards

Santosh K

[former_member182657]

Hi Srikanth,

First restart the complete system & share the result from STMS --->transport tool ,if possible share the screenshot for same.

Also share trans.log file from OS.

Regards,

Gaurav