Skip to Content

EPH3 Upgrade - FATAL ERROR: DBSL error 29 (db code -1): Connect failed

Hello,

We are trying to upgrade our CRM environment to EPH3 from EPH1.  We are receiving an error in the Configuration Phase - Prep_Extension/Patch_CHK3. I attached the SQLSTMTSTD.OUT log and a screenshot of the error. I know it says connection failed but it appeared the prior SQL scripts ran with out issue.

EXECUTING /usr/sap/DC2/SUM/abap/bin/SAPuptool execdb ../var/OPENPATCHES.TQL

Logging to '/usr/sap/DC2/SUM/abap/log/OPENPATCHES.LOG'

INFO:  XDNLevelTraceSetLocation: Trace set to: XDNTrace.059543.*

FATAL ERROR: DBSL error 29 (db code -1): Connect failed

SAPup> Process with PID 3059543 terminated with status 20 at 20141231101748!

---------------------------------------------------------------------------------------------------------------------------

The prior SQL Execution steps appeared to work

EXECUTING /usr/sap/DC2/SUM/abap/bin/SAPuptool execdb ../var/SQLDBSCRIPT.TQL

Logging to '/usr/sap/DC2/SUM/abap/log/SQLDBSCRIPT.OUT'

INFO:  XDNLevelTraceSetLocation: Trace set to: XDNTrace.325566.*

SAPup> Starting subprocess with PID 2407355 in phase 'PATCH_CHK3' at 20141230174814

    ENV: CLASSPATH=/qibm/ProdData/HTTP/Public/jt400/lib/jt400.jar:/JCo/sapjco.jar

    ENV: DIR_LIBRARY=/usr/sap/DC2/SUM/abap/bin

    ENV: ILE_PATH=/usr/sap/DC2/SUM/abap/bin:/sapmnt/DC2/exe/uc/as400_pase_64:/usr/bin:.

    ENV: JAVA_HOME=/QOpenSys/QIBM/ProdData/JavaVM/jdk50/64bit

    ENV: LIBPATH=/usr/sap/DC2/SUM/abap/bin:/usr/sap/DC2/SUM/jvm/jre/lib/ppc64/server:/usr/sap/DC2/SUM/jvm/jre/lib/ppc64:/usr/sap/DC2/SUM/jvm/jre/../lib/ppc64:/usr/sap/DC2/SUM/jvm/jre/lib/ppc64/jli:/usr/sap/DC2/SUM/jvm/jre/../lib/ppc64/jli:/sapmnt/DC2/exe/uc/as400_pase_64:/usr/sap/DC2/hdbclient:/sapdb/clients/DC2/lib/lib64:/sapdb/clients/DC2/lib

    ENV: PASE_LANG=en_US

    ENV: PASE_LC__FASTMSG=true

    ENV: PASE_LIBPATH=/usr/sap/DC2/SUM/abap/bin:/sapmnt/DC2/exe/uc/as400_pase_64:/usr/sap/DC2/hdbclient:/sapdb/clients/DC2/lib/lib64:/sapdb/clients/DC2/lib

    ENV: PASE_LOCPATH=/usr/lib/nls/loc

    ENV: PASE_NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat:/usr/lib/nls/msg/en_US/%N:/usr/lib/nls/msg/en_US/%N.cat

    ENV: PASE_PATH=/usr/sap/DC2/SUM/abap/bin:/sapmnt/DC2/exe/uc/as400_pase_64:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:/usr/bin:.:/usr/sap/DC2/hdbclient:/sapdb/clients/DC2/bin

    ENV: PASE_STDIO_ISATTY=N

    ENV: PASE_THREAD_ATTACH=Y

    ENV: PASE_TZ=<EST>5<EDT>,M3.2.0,M11.1.0

    ENV: PASE_USRGRP_LIMITED=

    ENV: PATH=/usr/sap/DC2/SUM/abap/bin:/sapmnt/DC2/exe/uc/as400_pase_64:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:/usr/bin:.:/usr/sap/DC2/hdbclient:/sapdb/clients/DC2/bin

    ENV: SAPSYSTEMNAME=DC2

    ENV: dbms_type=db4

    ENV: dbs_db4_schema=R3DC2DATA

    ENV: ILE_DIR_LIBRARY=/usr/sap/DC2/SUM/abap/bin

    ENV: PASE_DIR_LIBRARY=/usr/sap/DC2/SUM/abap/bin

    ENV: DIR_LIBRARY_RMT=/usr/sap/DC2/SUM/abap/bin

    ENV: ILE_DIR_LIBRARY_RMT=/usr/sap/DC2/SUM/abap/bin

    ENV: PASE_DIR_LIBRARY_RMT=/usr/sap/DC2/SUM/abap/bin

    ENV: ILE_LIBPATH=/usr/sap/DC2/SUM/abap/bin

    PWD: /usr/sap/DC2/SUM/abap/tmp

Error.jpg (128.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 02, 2015 at 01:21 AM

    Try the suggestions given in this thread and see if they help.

    Are you using the same version of the SUM tool mentioned in that thread?

    Try updating the kernel and see if that helps.

    Cheers

    Reagan

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you for the reply. Yes I am using SUM 1.0 SP12. I updated r3trans tp and dbls. Support suggested that and also to upgrade the kernel. I am restarting sum and will see what happens.

      Thank you

  • Jan 04, 2015 at 08:26 PM

    Hello All,

    We were able to get passed the previous error. Now we get the errors in the screen shot

    below. It is talking about execute permissions...But I am not sure to what exactly.

    bbelow.


    error1.jpg (98.7 kB)
    error2.jpg (113.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • If you look at the C-Stack information from the dev_SAPup trace file you have provided it shows the limits for the OS user. Assuming that you started the SUM tool under the <SID>adm user I believe the umilits are for that user. Just because the trace file contains such information I believe ulimit should be valid for OS/400. On Unix and Linux you can find the settings using the ulimit command.

      Eg : su - dc2adm

      ulimit -a

      I have no idea about OS/400 and if there is no such thing with OS/400 then you may ignore that.

      The problem looks more likely with the SUM tool and not with a phase in the upgrade. As the screen shot says "Tool died unexpectedaly with sh: db2: 0403-006 Execute Permission denied"

      Have you checked the logs under /usr/sap/DC2/SUM/sdt/log?

      Has it got something to do with the db2 directory under /usr/sap/DC2/SUM/sdt/patch/db/DB2/config/templates/db2?

      Review the permissions of the files/directories and sub-directories under /usr/sap/DC2/SUM/sdt.

      Unfortunately I am running out of clues and there is no point in suggesting "Check this" or "Check that" as it will waste your time. if nothing works then check with SAP.

      Good Luck

      RB

  • Jan 07, 2015 at 09:08 PM

    In the end there were 2 issues.

    #1

    FATAL ERROR: DBSL error 29 (db code -1): Connect failed

    SAPup> Process with PID 3059543 terminated with status 20 at 20141231101748!


    This was solved by upgrading R3Trans, TP and DBSL libs.


    #2 Tool died unexpectedly with Assertion failed: nNavers > 0, file  SAPuppat.c, line 5420


    We exported the NAvers table from another system and inserted into the one with the issue.



    Thanks for all the help!

    Add comment
    10|10000 characters needed characters exceeded