R3load testconnect exits with error code 2 in import ABAP installation phase

[Former Member]

Hi All,

I am installing SAP ERP 6.0 SR3 with MaxDB version 7.6 on Linux RHEL 5.9 server. In the import ABAP phase of installation,

installer is giving below error. R3load -testconnect exits with error code 2.

Below is the content of R3load.exe.log file.

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/LPM/SYS/exe/run/R3load: START OF LOG: 20140801085831

/usr/sap/LPM/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

/usr/sap/LPM/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]

Compiled May 25 2013 00:38:46

/usr/sap/LPM/SYS/exe/run/R3load -testconnect

(DB) ERROR: DbSlControl(DBSL_CMD_IMP_FUNS_SET) rc = 20

(DB) ERROR: DbSlErrorMsg rc = 20

/usr/sap/LPM/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/LPM/SYS/exe/run/R3load: END OF LOG: 20140801085831

Can anyone please tell me the solution.

Thank you

[Former Member · Accepted solution]

Hi Divyanshu,

I checked in /usr/sap/LPM/SYS/exe/run/ folder that dbsdbslib.so exist!

-rwxr-xr-x 1 lpmadm sapsys 1764422 May 24  2013 dbsdbslib.so

is there any permission issue?

Thanks,

Swapnil

[divyanshu_srivastava3 · Accepted solution]

What is your OS and DB ?

[divyanshu_srivastava3 · Accepted solution]

Ok:

Please check few thing:

DIR_LIBRARY and dbms_type

Check permission and group assigned.

Use below note- under section 3 to setuo the env for this

817463 - Addtnl info for upgrade to SAP NetWeaver 7.0x ABAP: MaxDB

Divyanshu

[former_member188883 · Accepted solution]

Hi Swapnil,

dlopen("/usr/sap/LPM/SYS/exe/run/dbsdbslib.so") FAILED
4 ETW000                          "libSQLDBC77.so: cannot open shared object file: No such file or directory"
4 ETW000                                                                                                 161  0.011709
4 ETW000  [    dbcon.c ,00000]  *** ERROR => Couldn't load library '/usr/sap/LPM/SYS/exe/run/dbsdbslib.so'
4 ETW000                                                                                                  39  0.011748

It looks lilke MaxDB is not installed correctly and path variable is not set correctly.

Please share the output of echo $PATH

and check DB consistency using sdbregview -l

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

Below is the output of commands you want:

sb7lpar5:lpmadm 6> echo $PATH

/sapdb/programs/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/LPM/SYS/exe/uc/linuxx86_64:/usr/sap/LPM/SYS/exe/run:/home/lpmadm:.

sb7lpar5:lpmadm 7> sdbregview -l

Server Utilities    /sapdb/programs    7.6.03.09     64 bit    valid

DB Analyzer         /sapdb/programs    7.6.03.09     64 bit    valid

PCR 7300            /sapdb/programs    7.3.00.58               valid

PCR 7301            /sapdb/programs    7.3.01.22               valid

PCR 7500            /sapdb/programs    7.5.00.46     64 bit    valid

SAP Utilities       /sapdb/programs    7.6.03.09     64 bit    valid

Redist Python       /sapdb/programs    7.6.03.09     64 bit    valid

Base                /sapdb/programs    7.6.03.09     64 bit    valid

JDBC                /sapdb/programs    7.6.03.03               valid

Messages            /sapdb/programs    MSG 0.5603              valid

ODBC                /sapdb/programs    7.6.03.09     64 bit    valid

Database Kernel     /sapdb/LPM/db      7.6.03.09     64 bit    valid

Loader              /sapdb/programs    7.6.03.09     64 bit    valid

SQLDBC              /sapdb/programs    7.6.03.09     64 bit    valid

Fastload API        /sapdb/programs    7.6.03.09     64 bit    valid

SQLDBC 76           /sapdb/programs    7.6.03.09     64 bit    valid

Thanks,

Swap

[former_member188883 · Accepted solution]

Hi Swapnil,

Please download latest dbsl patch available for 720 kernel and extract it into the kernel directory.

As you are using SWPM , it is expecting MaxDB client 7.7 atleast for installation to work.

Hope this helps.

Regards,

Deepak Kori

[divyanshu_srivastava3 · Accepted solution]

As, asked you before. Please update DBSL patches and R3trans.

Also check above note and variables.

[Former Member · Accepted solution]

Hi Deepak,

I downloaded lib_dbsl patch for the 720 kernel and copied new dbsdbslib.so in the /usr/sap/LPM/SYS/exe/run/ folder, then retried the operation but the same issue occurred.

Do I have to stop the installation first and run again? OR do I have to apply another patch for this?

Thanks,

Swap

[former_member188883 · Accepted solution]

Hi Swapnil,

3 approaches here we have

1) Please stop everything and then update the dbsl patch. Post this check the results.

2) Use MaxDB 7.8 for installation

3) Install MaxDB 7.8 software on some other Linux server and then copy only libSQLDBCC77.so from that setup and place it under kernel directory.

Hope this helps.

Regards,

Deepak Kori

[Reagan · Accepted solution]

did you run the ldd command I have asked ?

[Former Member · Accepted solution]

Hi,

Just now run the ldd command. Below is the output:

sb7lpar5:lpmadm 7> ldd /usr/sap/LPM/SYS/exe/run/dbsdbslib.so

        linux-vdso.so.1 =>  (0x00007fffc6d15000)

        libdl.so.2 => /lib64/libdl.so.2 (0x00002b72a752a000)

        librt.so.1 => /lib64/librt.so.1 (0x00002b72a772f000)

        libSQLDBC77.so => not found

        libc.so.6 => /lib64/libc.so.6 (0x00002b72a7938000)

        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002b72a7c92000)

        libm.so.6 => /lib64/libm.so.6 (0x00002b72a7f92000)

        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b72a8215000)

        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b72a8424000)

        /lib64/ld-linux-x86-64.so.2 (0x00000037b5600000)

[divyanshu_srivastava3 · Accepted solution]

Thjs is not found - libSQLDBC77.

libSQLDBC77.dll is a MaxDB library and it is under the pgm directory.

[Former Member · Accepted solution]

Hi Deepak,

I tried with 1st approach but same issue. Now I will try 3rd one if not then will go for 2nd.

Thanks,

Swapnil

[Reagan · Accepted solution]

Hello

sb7lpar5:lpmadm 7> ldd /usr/sap/LPM/SYS/exe/run/dbsdbslib.so
        linux-vdso.so.1 =>  (0x00007fffc6d15000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00002b72a752a000)
        librt.so.1 => /lib64/librt.so.1 (0x00002b72a772f000)
        libSQLDBC77.so => not found
        libc.so.6 => /lib64/libc.so.6 (0x00002b72a7938000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00002b72a7c92000)
        libm.so.6 => /lib64/libm.so.6 (0x00002b72a7f92000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00002b72a8215000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00002b72a8424000)
        /lib64/ld-linux-x86-64.so.2 (0x00000037b5600000)

So now you know what your problem is.

ls -la /opt/sdb/programs/lib/libSQLDBC77.so

ls -la /opt/sdb/programs/lib

ls -la /opt/sdb/programs

Now check whether there are files present.

Also provide the environment variable of the lpmadm user.

Regards

RB

[Former Member · Accepted solution]

Hi Reagan,

I checked. there is no folder sdb under /opt directory.

Below are the environment variables of lpmadm user

TERM=xterm

HOME=/home/lpmadm

SHELL=/bin/csh

USER=lpmadm

LOGNAME=lpmadm

PATH=/sapdb/programs/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/LPM/SYS/exe/uc/linuxx86_64:/usr/sap/LPM/SYS/exe/run:/home/lpmadm:.

HOSTTYPE=x86_64-linux

VENDOR=unknown

OSTYPE=linux

MACHTYPE=x86_64

SHLVL=1

PWD=/home/lpmadm

GROUP=sapsys

HOST=sb7lpar5

REMOTEHOST=172.17.171.197

MAIL=/var/spool/mail/lpmadm

HOSTNAME=sb7lpar5

INPUTRC=/etc/inputrc

LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

CVS_RSH=ssh

G_BROKEN_FILENAMES=1

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

LANG=en_US.UTF-8

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

SAPSYSTEMNAME=LPM

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

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

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

rsdb_ssfs_connect=0

LD_LIBRARY_PATH=/usr/sap/LPM/SYS/exe/run:/usr/sap/LPM/SYS/exe/uc/linuxx86_64:/sapdb/programs/lib

dbms_type=ADA

Thanks,

Swapnil

[Reagan · Accepted solution]

Alright. In that case are you able to see files under /sapdb/programs/lib ?

ls -la /sdb/programs/lib/libSQLDBC77.so

ls -la /sdb/programs/lib

ls -la /sdb/programs

[Former Member · Accepted solution]

I could see libSQLDBC76.so file instead of libSQLDBC77.so under /sapdb/programs/lib

So, why is it not trying to load libSQLDBC76.so instead of libSQLDBC77.so ??

# ls -al /sapdb/programs/lib

total 45940

dr-xr-xr-x  3 sdb sdba    4096 Jul 30 07:52 .

dr-xr-xr-x 14 sdb sdba    4096 Jul 30 07:52 ..

-r-xr-xr-x  1 sdb sdba 8695692 Oct 25  2007 libicudata.so.30

-r-xr-xr-x  1 sdb sdba 1410112 Oct 25  2007 libicui18n.so.30

-r-xr-xr-x  1 sdb sdba 1149474 Oct 25  2007 libicuuc.so.30

-r-xr-xr-x  1 sdb sdba 1349383 Oct 25  2007 libsapni.so

-r-xr-xr-x  1 sdb sdba  172746 Oct 25  2007 libsapu16.so

-r-xr-xr-x  1 sdb sdba 1064727 Oct 25  2007 libSDBBOS.so

-r-xr-xr-x  1 sdb sdba 1673499 Oct 25  2007 libSDBLoader76.so

-r-xr-xr-x  1 sdb sdba 1673523 Oct 25  2007 libSDBLoader.so

-r-xr-xr-x  1 sdb sdba 3227258 Oct 25  2007 libSQLDBC76_C.so

-r-xr-xr-x  1 sdb sdba 3233434 Oct 25  2007 libSQLDBC76.so

-r-xr-xr-x  1 sdb sdba 3227218 Oct 25  2007 libSQLDBC_C.so

-r-xr-xr-x  1 sdb sdba 3209392 Oct 25  2007 libSQLDBC.so

-r--r--r--  1 sdb sdba 5061594 Oct 25  2007 libsqlod.a

-r-xr-xr-x  1 sdb sdba 2270943 Oct 25  2007 libsqlod.so

-r--r--r--  1 sdb sdba 5062122 Oct 25  2007 libsqlodw.a

-r-xr-xr-x  1 sdb sdba 2271195 Oct 25  2007 libsqlodw.so

dr-xr-xr-x  3 sdb sdba    4096 Jul 30 07:52 python2.3

-r--r--r--  1 sdb sdba 2071185 Oct 25  2007 python23.zip

# ls -al /sapdb/programs/

total 112

dr-xr-xr-x 14 sdb  sdba 4096 Jul 30 07:52 .

drwxr-xr-x  5 root root 4096 Jul 30 07:52 ..

dr-xr-xr-x  3 sdb  sdba 4096 Jul 30 07:52 bin

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 config

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 env

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 etc

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 incl

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 install

dr-xr-xr-x  3 sdb  sdba 4096 Jul 30 07:52 lib

dr-xr-xr-x  2 sdb  sdba 4096 Jul 30 07:52 msg

dr-xr-xr-x  3 sdb  sdba 4096 Jul 30 07:52 pgm

dr-xr-xr-x  6 sdb  sdba 4096 Jul 30 07:52 runtime

dr-xr-xr-x  4 sdb  sdba 4096 Jul 30 07:52 sdk

dr-xr-xr-x  4 sdb  sdba 4096 Jul 30 07:52 terminfo

ls -al /sapdb/

total 40

drwxr-xr-x  5 root root 4096 Jul 30 07:52 .

drwxr-xr-x 28 root root 4096 Jul 24 09:58 ..

drwxrwxr-x 11 sdb  sdba 4096 Jul 30 07:52 data

drwxrwxrwx  7 root root 4096 Jul 30 03:02 LPM

dr-xr-xr-x 14 sdb  sdba 4096 Jul 30 07:52 programs

[Reagan · Accepted solution]

Hello

Try to create a symbolic link under /sapdb/programs/lib and see if that helps.

It appears to me that the kernel you are using requires a higher version of the MaxDB software and client on the system.

cd /sapdb/programs/lib

ln -s libSQLDBC76.so libSQLDBC77.so

After recreating the symbolic link then retry and if that fails then try with a lower version of the kernel possibly using 700 release and see if that helps.

Regards

RB

[Former Member · Accepted solution]

Thank you Reagan!!

Symbolic linking worked!!!

ln -s libSQLDBC76.so libSQLDBC77.so

After creating symbolic link, I retried the operation and it passed ahead.

Now its importing ABAP.

Regards,

Swapnil

[Former Member]

Thanks all for your help and support.

[former_member182657]

Additionally follow SAP Note  1386088 - Loading MaxDB DBSL (dbsdbslib.o) on AIX 5.3 and AIX 6.x

Thanks,

Gaurav

[former_member182657]

Hi ,

libSQLDBC77.so: cannot open shared object file: No such file or directory"

Could you share the MaxDB database version which you are using .In addition follow note 1142632

Regards,

Gaurav

[Former Member]

Hi Gaurav,

the MaxDB version I am using is 7.6.03.09

Thanks,

Swap

[former_member182657]

Hi Swap,

If possible try to use MaxDB version 7.8 instead of 7.6 and consider SAP Note 1142632.

Regards,

Gaurav

[divyanshu_srivastava3]

Hi Swap,

1st, you should check the logs file for detailed error.

2nd. from above, the issue can be with R3trans and DBSL, so you can update them and try again.

Divyanshu

[Former Member]

Hi Divyanshu,

I run R3trans -d command. Below is the content of trans.log file

4 ETW000 R3trans version 6.23 (release 720 - 31.10.12 - 20:12:06).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 04.08.2014 - 04:04:39

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Mon Aug  4 04:04:39 2014                                               11464  0.011464

4 ETW000  [     dev trc,00000]  db_con_init called                                                        16  0.011480

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                  27  0.011507

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  13  0.011520

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                  8  0.011528

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/LPM/SYS/exe/run/dbsdbslib.so' ...            20  0.011548

4 ETW000  [    dlux.c  ,00000]  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/LPM/SYS/exe/run/dbsdbslib.so") FAILED

4 ETW000                          "libSQLDBC77.so: cannot open shared object file: No such file or directory"

4 ETW000                                                                                                 161  0.011709

4 ETW000  [    dbcon.c ,00000]  *** ERROR => Couldn't load library '/usr/sap/LPM/SYS/exe/run/dbsdbslib.so'

4 ETW000                                                                                                  39  0.011748

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/LPM/SYS/exe/run') or dbms_type ('ADA'

Please check this.

Thanks,

Swap

[divyanshu_srivastava3]

Hi Swap,

/usr/sap/LPM/SYS/exe/run/dbsdbslib.so

Database shared library is missing.

Download and extract in this directory.

Divyanshsu

[Reagan]

su - lpmadm

ldd /usr/sap/LPM/SYS/exe/run/dbsdbslib.so

Regards

RB

[former_member182657]

Hi,

Try to upgrade the kernel with the latest patch available and retry the phase again.

Regards,

Gaurav

[former_member188883]

Hi Swap,

Please attach

1) sapinst_dev.log

2) knlmsg log

Regards,

Deepak Kori