Skip to Content
avatar image
Former Member

R3trans error


iam getting this error when i do an R3rans -x command:

twm1:wm1adm 84> more trans.log

4 ETW000 R3trans version 6.14 (release 700 - 10.07.07 - 13:48:00).

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

4 ETW000

4 ETW000 date&time : 12.12.2006 - 11:01:19

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] Tue Dec 12 11:01:19 2006

116 0.000116

4 ETW000 [dev trc ,00000] db_con_init called

25 0.000141

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

49 0.000190

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/put/exe/dbsdbslib.s

o' ...

4 ETW000 55 0.000245

4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib: dlopen()= cannot open shared object file: No such file or directory -> DLENOACCESS (0,Success)

4 ETW000 493 0.000738

4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/put


4 ETW000 37 0.000775

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

So have checked the library' its there in that directory.I also looked for and its in /sapdb/programs/lib.

i have set the DIR_LIBRARY to where' is.







so what i dont know is ,are they supposed to be in the same directory(' and )and what kind of permissions should they have.

iam running SUSE Linux Enterprise 9.1 maxdb 7.6 (upgraded from to 76 ),upgrading from 4.7 to ECC6.

any ideas welcome

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 13, 2008 at 03:46 PM


    Rename the library file and download a new library file as per the Kernel version.

    Restart the Application including the Database



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 12, 2007 at 10:37 AM


    according to sap note 817463

    As of NW 2004s, the new MaxDB DBSL (dbsdbslib) and therefore the disp+work uses the Shared Library libSQLDBC76 of the MAXDB 7.6.00 client installation.

    The shared library is loaded from the operating system,

    which means that you have to set the relevant operating system-dependent system variables so that MaxDB DBSL can load the shared libraries.

    Therefore, you must permanently enhance the following system variables in the user environment of <sid>adm:




    with the path to the libSQLDBC76:


    The system also checks whether the system variable is set correctly in PREPARE phase DBCHK_PRE..



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the note.

      i tried that but no luck.May you give me the instructions on setting that up (the env)for sidadm at OS i think there is somewhere iam doing it wrong.

  • avatar image
    Former Member
    Dec 12, 2007 at 02:06 PM

    Hi Mudzingwa Wilson ,

    1. hostname



    1. hostname -f


    1. sestatus

    SELinux status: disabled

    If selinux is not disable please disable it or else use your own secutiry policy


    1. cat /etc/hosts

    2. Do not remove the following line, or various programs

    3. that require network functionality will fail. localhost.localdomain localhost

    ::1 localhost6.localdomain6 localhost hostname


    rpm -ivh IBMJava2-AMD64-142-SDK-1.4.2-9.0.x86_64.rpm

    cp /opt/IBMJava2-amd64-142/lib/


    copy below in ~/.bash_profile

    JAVA_HOME=/opt/IBMJava2-amd64-142 export JAVA_HOME

    #JAVA_PATH=/opt/IBMJava2-amd64-142 export JAVA_PATH

    SAPINST_JRE_HOME=/opt/IBMJava2-amd64-142 export SAPINST_JRE_HOME



    In /etc/sysctl.conf Add the following parameters

    #kernel.hostname =

    #kernel.domainname = abc

    kernel.shmmax = 23136829430

    kernel.shmmni = 4096

    kernel.shmseg = 4096

    kernel.shmall = 3279547

    kernel.shmmin = 1

    kernel.sem = 1250 256000 100 1024

    #Below are new entry

    #kernel.semmsl = 700

    #kernel.semmni = 200

    #kernel.semmns = 15000

    #kernel.semopm = 500

    kernel.msgmni = 2878

    kernel.msgmnb = 360000

    vm.max_map_count = 300000

    fs.file-max = 327679

    net.ipv4.ip_local_port_range = 1024 65536





    net.ipv4.tcp_wmem = 4096 65536 4194304

    net.ipv4.tcp_rmem = 4096 87380 4194304

    net.ipv4.tcp_syncookies = 1

    #Increasing I/O Throughput at the Linux OS Level

    #fs.aio-max-size = 214748364 changed on 08March2005

    #fs.aio-max-size = 2097152

    fs.aio-max-size = 1048576

    #fs.aio-max-size = 131072




    Add the following parameters in limits.conf file

    @sapsys soft noproc 32800

    @sapsys hard noproc 32800

    @sapsys hard nofile 32800

    @sapsys soft nofile 32800

    @dba soft noproc 32800

    @dba hard noproc 32800

    @dba soft nofile 32800

    @dba hard nofile 32800

    Thanks and Regards,

    Kamal Kishore

    Add comment
    10|10000 characters needed characters exceeded

    • You can't do an "R3trans -x" in the "exe" subdirectory during a PREPARE. This can't work because kernel 7.00 needs the dependent libraries in /usr/sap/put/exe which are not in your LD_LIBRARY_PATH and thus the system will complain. Additionally you can't simply add those to the path because then, the old 6.40 system won't work any more.

      For that reason SAPup is setting a new environment for each call of R3trans and executing R3trans in that environment (not using the old one).

      I did it the following way in the past:

      - execute PREPARE

      - run PREPARE until it complains, that your R3trans is too old

      - replace R3trans and tp in /usr/sap/put/exe

      - restart PREPARE

      Any R3trans -x before the phase KX_SWITCH in the upgrade from the new kernel will fail - and this is intended.