[BIG PROBLEM] SAP Host Agent cannot connect to SYSTEMDB

[symon_braunbaer]

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.

[kashyap_shah3]

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.

[kashyap_shah3]

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

[symon_braunbaer]

Hello Kashyap,

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

[kashyap_shah3]

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.