Skip to Content
author's profile photo Former Member
Former Member

ERP not able to connect to HDB database after server restart

Hello,

I have a server in Azure running SAP HANA database (HDB), SAP ERP (ERP) and SAP Webdispatcher (WD1) (Demo21 setup). Everything was working fine, I could restart systems without issues. Then I booted the server, and now ERP is not able to connect to the database.

I have set internal server name and FQDN correctly in all instance profiles, they are static values. Result of R3trans -d:

> R3trans -d

This is T3trans version 6.25 (release 742 - 11.02.15 - 14:06:42).

unicode enabled version

2EETW169 no connect possible: "DBMS = HDB --- SERVER = ' ' "

R3trans finished (0012).

I'm attaching R3trans.log.

Please help, I am stuck here 😔

Kind regards,

Gørril

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 13, 2015 at 12:13 PM

    Hi

    1. Are you using the SIDADM user id to execute the R3trans command?

    2. Refer the SAP KBA 1852017 - Error 10061 when connecting SAP Instances to failed over HANA nodes


    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi again,

      Problem turned out to be that ip was used instead of hostname in hdbuserstore. Reset it with this command:

      hdbuserstore SET DEFAULT <hostname>:<port> SAPERP <password>

      Then things started working again like magic!

      Thank you so much!!

      Kind regards,

      Gørril

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2015 at 12:34 PM

    Hello Gorril,

    Please check following could be the reasons.

    Incorrect hostname/port, database stopped, blocking firewall.

    Regards

    Anand

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2015 at 07:38 AM

    Just in case anyone encounters the same error. I would like to share how I solved the issue.

    Background:

    I upgraded my HANA DB. After that, I found I couldn't start the NW instance. I could see error "no connect possible DBMS=HDB.

    Then I upgraded DBSL for HANA and upgrade kernel to 742.

    System info:

    HANA DB: 1.00.097(After the upgrade)

    BW 740 SP07

    Kernel 740(After the upgrade)

    Charlie

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.