I upgraded a few HANA databases from SPS9 to SPS10. At the end of the upgrade I received this error.

SAP HOST AGENT; SAP Host Agent version; Select desired Operating System; Download Archive Q: H ow to install SAP Host Agent in Windows? Ans: – Before SAP Host Agent installation check SAP note: 1375494 – Extract SAPHOSTAGENT.SAR with below command 'sapcar -xvf SAPHOSTAGENT.SAR' – after extract you will find saphostexec file. Ac4va4on. Ac6vate the auto update – downloaded the latest host agent patch level to the soKware repository loca6on /sap/soKware/HOSTAGENT – restart the host agent on all hosts in your SAP estate – this could be scripted – aKer 10 minutes, check files devsaphostexec and upgrade.log in the work directory of the host agent /usr/sap. Determine the current installed version of SAP Host Agent and download the desired installation file from the Extract the downloaded file to a new directory and execute the below command. Only one single command be used and the entire upgrade process will execute automatically. 2528633-Host Agent version cannot be checked due to HTTP Code 500 in the SAPHostControl web service Symptom The Agent Admin UI in SAP Host Agent tab shows message.

17:51:14.813 – INFO: Deploying SAP Host Agent configurations…
17:51:14.813 – INFO:
—————————————————-
——-
17:51:14.813 – INFO: Deploying SAP Host Agent configurations on host
‘sapheccd01’…
17:51:15.592 – INFO: Calling SAP Host Control web service operation
‘DetectManagedObjects’ (host: ‘hostname’, user: ‘<sidadm>’, url:
https://hostname:1129, arguments: ‘manifest’ –
‘/hana/shared/<SID>/hdblcm/SIGNATURE.SMF’)
17:51:15.607 – ERR : 500 Can’t connect to hostname:1129
(Connection
refused)
17:51:15.607 – WRN : Deployment of SAP Host Agent configurations
failed
on host ‘hostname’
17:51:15.607 – INFO:
—————————————————-
——-
17:51:15.607 – INFO: END: Deploying SAP Host Agent configurations
(start:
17:51:14.813 duration: 00:00:00.794)
17:51:15.607 – INFO:
—————————————————-
——-
17:51:16.010 – INFO: SAP HANA components updated

Note: Deployment of SAP Host Agent configurations finished with errors.

Command To Check Sap Host Agent Version Linux

I’m still pretty new to SAP, ERP and HANA databases. I have been a DBA for over 10 years on other databases. I know that errors and warnings need to be investigated. I also know that the host agent is important for communication between the host and database. So I opened up an incident with SAP. After sending logs and a little back and forth, SAP support asked me to check to see if anything is listening on port 1129.

When I try to connect to the httpshdblcm I get page not available.

https://<hostname>:1129/lmsl/HDBLCM/index.html

I took a look to see if anything was listening on port 1129. netstat –tnlp | grep 112, it came back with 1128, sapstartsrv was only listening on 1128 and not 1129. I compared a working system to this one and found that the ownership was incorrect for the files in /usr/sap/hostctrl/exec/sec.

root was the owner.

How To Check Sap Host Agent Version Without

–rw–r—r— 1 root sapsys 993 Feb 25 2013 xxxxx.crt
–rw——- 1 root sapsys 1847 Jun 4 2014 xxxxx.pse
–rw——- 1 root sapsys 1855 Apr 22 2014 xxxxx.pse_backup
–r——– 1 root sapsys 81 Jun 4 2014 xxxxx_v2
–r——– 1 root sapsys 97 Apr 22 2014 xxxx_v2_backup

How To Check Sap Host Agent Version

So I changed the ownership on all the files to <sidadm>:sapsys and restarted the host agent, /usr/sap/hostctrl/exe/saphostexec -restart. Now I see sapstartsrv listening on 1128 and 1129. I tried httpshdblcm again and was given a new error.

“The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and
then click the Refresh button, or try again later”.

I came across SAP note 2078425 and found this in the note.

1. 5. Configure SAP Host Agent to serve the Web UI

By default, during installation or update of the SAP HANA system, hdblcm configures the SAP Host Agent to serve its Web UI. For some reason this might have not happened, for example because of a failure during the installation/update procedure or if the SAP Host Agent had been manually reinstalled afterwards.

To update the integration of hdblcm on the SAP HANA host, run the following command:

<sapmnt>/<SID>/hdblcm/hdblcm –action=update_host –components_registration=none

1. 6. Restart SAP Host Agent

/usr/sap/hostctrl/exe/saphostexec -restart

Since the hdblcm configuration uses https, 1129 it failed. Now that I have https working, I ran the command in the note and restarted the host agent.

How To Find Sap Version

<sapmnt>/<SID>/hdblcm/hdblcm –action=update_host –components_registration=none

How To Check Sap Host Agent Version Latest

I’m now able to open httpshdblcm. The big takeaway for me is, investigate all errors and warnings in the HANA upgrade log. In my case I had other problems as a result of this error.