Cannot determine port due to unknown HANA version

The problem is, that the plugin does not get any basic information about your instances:

+++ su - admcensored -c '/usr/sap/SIDcensored/HDB00/exe/hdbsql -C -F\; -x -a -n localhost -i 00 -U usercensored "SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME='\''Version'\'' or NAME='\''All Started'\'' "'
++ result=
++ rc=3
++ echo ''
++ sed -e 's/^;//' -e 's/;$//'
++ return 3

This query should return the state of all instances found on the management database and should look like:

<<<sap_hana_status:sep(59)>>>
[[P60 60]]
Version;;2.00.036.00.1547699771 (fa/hana2sp03)
All Started;OK;Yes

You can run this command line directly to may get some more information. According to the documentation (SQL Error Codes - SAP Help Portal), rc=3 means a fatal error.

As long as this query doesn’t return anything all other queries are skipped, that’s why you don’t get any services and check results.

1 Like