Skip to Content

Connect to database failed

When trying to start my NW 7.5 AS ABAP on HANA system, disp+work times out while YELLOW. I tried running R3trans -d and it also failed similarly.

Looking at the dispatcher log and R3trans log, they both showed similar error outputs so it is an overarching issue.

dev_disp: http://puu.sh/s4u3T/aeb07d5aa6.png

trans.log: http://puu.sh/s4vay/8b871f39d1.png

My HANA database is working fine: http://puu.sh/s4y9Y/e2d5d2e27d.png

Does anyone know what might be the problem?

For more context:
When attempting to start the system and instances with:

/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function StartSystem and /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function Start

the output is "OK" and the dispatcher attempts to start up the first system but then is unreactive for the rest of the sapcontrol start attempts.

startsap ALL results in "No instance profiles found" with this output: http://puu.sh/s4ziE/e4d4cd6747.png
It looks like the script can locate the profiles but will not register them as profiles.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 03, 2016 at 07:57 PM

    Hello Geoffrey,

    You are welcome!

    The issue seems more related to the infrastructure, not to the involved software (assuming that the hostname and port seen at the trans.log are the correct ones ;-)).

    You could also test the connection using telnet:

    telnet <database server> <30015>

    Regards,

    Isaías

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2016 at 07:28 PM

    Hello Geoffrey,

    If the HANA database is up and running, involve your network team.

    The error from the trans.log shows that R3trans was unable to open a TCP/IP connection to the database.

    Regards,

    Isaías

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for the reply Isaías!

      I'm in the process of installing BPC 10.1 so I'm really the only person responsible for everything at the moment for this particular system. I would be the one who would have to solve this TCP/IP connection issue correct?

      This is my first time dealing with an SAP system so I apologize if I'm misunderstanding something.

  • avatar image
    Former Member
    Nov 03, 2016 at 07:44 AM

    Hi Geoffrey,

    regarding your "no instance profile found" please check SAP Note 1888359.

    Best regards,
    Andreas

    Add comment
    10|10000 characters needed characters exceeded