cancel
Showing results for 
Search instead for 
Did you mean: 

Hostagent and MAXDB user key issues

0 Kudos

Hello,

i have a system, that "looses" all Database monitoring data from time to time. What i mean is, that it turns the Databaseinformation from green (or better said any information) to grey/unknown and vice versa.

as this happens more or less randomly no precise monitoring can be guaranteed.

The sole Error on the host i was able to find is on the dev_sapdbctrl:

Error --> No userkey for connect to 'database' found.

the xuser list command however gave me the usual suspects: DEFAULT / CONTROL / SUPERDBA

i Upgraded the Host sagent to the lastest version, wich made the Error to a Warning, however nothing has changed beyond that.

Has anyone encountered something similar? or can at least provide me with the information how to get rid of the Error / warning message?

Thank you very much!

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

you need to run the command from the command prompt started in Admin mode (Run As Administrator), if you execute the command on the same host, use it without providing host and os username:

C:\Program Files\SAP\hostctrl\exe\saphostctrl.exe -dbname <database_name> -dbtype ada -function GetDatabaseStatus

otherwise you need to run like this:

C:\Program Files\SAP\hostctrl\exe\saphostctrl.exe -host <database_host_name> -user <sapadm> <sapadmpwd> -dbname <database_name> -dbtype ada -function GetDatabaseStatus


0 Kudos

Hello, SAPHostAgent looks first whether own user sapadm has the connectivity information. If no, it looks whether it is running on SAP ERP database host and checks for OS users <sid>adm or sqd<sid>. It switches than to these users and try their xuser information to connect to MaxDB.

To make the behavior more deterministic, it is better to provide user sapadm with connection data. This is done with the command (as root):

/usr/sap/hostctrl/exe/saphostctrl -dbname <DBID> -dbtype ada -function SetDatabaseProperty DBCredentials=SET -dboption User=superdba -dboption Password=<pwd>

(s. SAP note 2018919 - SAP MaxDB/SAPHostagent: Setzen der Connect-Infomation als SetDatabaseProperty-Funktion, 2018919 - SAP MaxDB/SAPHostagent: Setting connect information as SetDatabaseProperty function - SAP ...)

Set this connectivity data and observe the providing of the database status information to the monitoring system.

Regards, Alexander

0 Kudos

so when i set the respective <SID>ADM user, and test the Connection with the command from the note:

C:\Program Files\SAP\hostctrl\exe\saphostctrl.exe -host <database_host_name> -user <sapadm> -dbname <database_name> -dbtype ada -function GetDatabaseStatus

i get an

Error: Http error, HTTP/1.1 401 Unauthorized.

i get the same error when i try to Setup the sapadm with the command you mentioned.