cancel
Showing results for 
Search instead for 
Did you mean: 

ERP not able to connect to HDB database after server restart

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Yes, user is sidadm.

The sql trace of SAP KBA 1852017 seems to be helpful - it's indicating that a previous internal IP address is still being used. I will investigate this further (try to set static internal IP, flush server cache).

Will update when done.

Kind regards,

Gørril

Former Member
0 Kudos

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

Answers (2)

Answers (2)

former_member182709
Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Gorril,

Please check following could be the reasons.

Incorrect hostname/port, database stopped, blocking firewall.

Regards

Anand