Question Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB in Technology Q&A

[BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Thu, 18 Apr 2024 23:45:43 GMT

Dear Experts,

I am totally nuts about the following problem:

# /usr/sap/hostctrl/exe/saphostctrl -function ListDatabases

The passwords of <SID>adm, SYSTEM in SYSTEMDB and SAPDBCTRL are 100% correct, tried them all out.

SAP Note

2023587 - Maintaining SAP HANA user store using SetDatabaseProperty for SAP Host Agent

is NOT helping

SAP Note

2621457 - hdbconnectivity failure after upgrade to 2.0

is NOT helping

Please kindly advise how to get this solved.

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

kashyap_shah3 — Fri, 19 Apr 2024 09:39:03 GMT

Hello,

Could you please elaborate on symptom, what problem you see, where. Appeciate that you are trying to avoid to reinvent the wheel and so listed your troubleshotting steps but it seems to confuse things, at least for me. I am not sure the screenshot that you havegiven is running what command from where. Also, is it secure connection (HTTPS) between Host agent and HANA? If yes, have both, agent and HANA got same root certificate installed or trust established by any other mans?

Thanks.

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Fri, 19 Apr 2024 10:44:26 GMT

Hello and thanks a lot for your reply!
This is the output from the command /usr/sap/hostctrl/exe/saphostctrl -function ListDatabases

I have intentionally left out the upper few lines, as I have to keep hostnames and SIDs private.
I have no idea if the connection you are mentioning is HTTPS. I did not setup any HTTPS. Furthermore,
this is host-internal.

I am VERY puzzled by the statement no hosts left... Like if there is a list of hosts, but there isn't, it's
just this host. When I try to connect with hdbsql on the command line, it works flawlessly.
I have also updated to the latest SAP Host Agent, still the same problem!

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

kashyap_shah3 — Fri, 19 Apr 2024 11:36:21 GMT

I found an interesting article, not directly related to Host agent but HANA, which states:

Such error can appear if you have ";" character in your HANA database user password. The only workaround at the moment is to change the password.

Please check and see if that helps.

Best regards,
Kashyap Shah

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Mon, 22 Apr 2024 10:34:44 GMT

Hello Kashyap,

thanks a lot for your research and proposal. We do not have this character in the password.
Please kindly suggest another solution.

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Mon, 22 Apr 2024 10:40:11 GMT

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

kashyap_shah3 — Mon, 22 Apr 2024 14:10:38 GMT

I'm still interested to see the symptom. I understand, as you have provided, output of ListDatabases for saphostctrl have got some errors towards the end. At beginning, it's detecting HANA components alright. So I want to understand what it stops you doing.
If you cehck Agent Admin on your Solution Manager system, is Host agent Green there: http(s)://<SolMan_FQDN>:5<Java_App_Instance_number><00_for_HTTP/01_for_HTTPS>/smd/AgentAdmin --> SAP Host Agent --> HANA FQDN under Agent name
How about Diagnostics agent: http(s)://<SolMan_FQDN>:5<Java_App_Instance_number><00_for_HTTP/01_for_HTTPS>/smd/AgentAdmin --> Agents --> HANA FQDN under Connected Agents - Full Host Name
Do you have outside discover setup by host agent or diagnostics agent? You can find that in your LMDB (on SolMan) --> Hosts --> HANA short hostname against Host Name --> Display --> besides Host Name, it will show "Supplied by Outside Discovery (SAP Host Agent)" if outside discovery by host agent is configured.
Moreover, if you have systems registering to SLD and from there going to LMDB, then you need to look at that as well.

Thanks.

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Wed, 24 Apr 2024 13:19:24 GMT

Any update please ? Any ideas please ?

This is hindering us tremendously, as several automation scripts are failing due to this problem !!
We need to get this sorted out... Thanks a lot!

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

kashyap_shah3 — Thu, 25 Apr 2024 11:08:58 GMT

have you looked at my reply from Monday to your comment?

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

symon_braunbaer — Fri, 03 May 2024 14:07:44 GMT

Hello kashyap_shah3, this new layout is very misleading and I think some of the contents in this thread got lost. If you mean your answer from 19-Apr-2024, the yes, I have checked it and unfortunately this is not useful, as we do not have the ; character in our Hana password. Any other ideas please ?

Re: [BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

kashyap_shah3 — Fri, 03 May 2024 14:18:05 GMT

No, long reply that says 2 weeks ago. I am pasting it here as well:

I'm still interested to see the symptom. I understand, as you have provided, output of ListDatabases for saphostctrl have got some errors towards the end. At beginning, it's detecting HANA components alright. So I want to understand what it stops you doing.
If you cehck Agent Admin on your Solution Manager system, is Host agent Green there: http(s)://<SolMan_FQDN>:5<Java_App_Instance_number><00_for_HTTP/01_for_HTTPS>/smd/AgentAdmin --> SAP Host Agent --> HANA FQDN under Agent name
How about Diagnostics agent: http(s)://<SolMan_FQDN>:5<Java_App_Instance_number><00_for_HTTP/01_for_HTTPS>/smd/AgentAdmin --> Agents --> HANA FQDN under Connected Agents - Full Host Name
Do you have outside discover setup by host agent or diagnostics agent? You can find that in your LMDB (on SolMan) --> Hosts --> HANA short hostname against Host Name --> Display --> besides Host Name, it will show "Supplied by Outside Discovery (SAP Host Agent)" if outside discovery by host agent is configured.
Moreover, if you have systems registering to SLD and from there going to LMDB, then you need to look at that as well.