Cannot determine port due to unknown HANA version

I have run the suggested command with OS admin at the console and here is the result: (as in my current situation - here I have a seriosu limitation - not allowed to upload files)
Aside of the fact that there is no replication defined - I do not see any flaw in output.
Maybe the SAP admin failed to mention that there is nothing to monitor yet? :slight_smile:

  • shift
  • test -n 2
  • case “$1” in
  • shift
  • test -n ‘’
  • ‘[’ -e /etc/check_mk//sap_hana.cfg ‘]’
  • . /etc/check_mk//sap_hana.cfg
    ++ USERSTOREKEY=usercensored
  • ‘[’ -z usercensored ‘]’
  • ps -efw
  • grep ‘[H]DB.*sapstartsrv’
  • read -r line
    ++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
    ++ sed ‘s/./(.)/./exe/sapstartsrv./\1/g’
  • SID=SIDcensored
    ++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
    ++ sed -e ‘s/./(.)/exe/sapstartsrv.*/\1/g’ -e ‘s/[^0-9]//g’
  • INSTANCE=00
    ++ echo ‘admcensored 6806 1 0 Nov18 ? 00:00:27 /usr/sap/SIDcensored/HDB00/exe/sapstartsrv pf=/usr/sap/SIDcensored/SYS/profile/SIDcensored_HDB00_censored -D -u admcensored’
    ++ grep -Po ‘^\s*(\w+)’
  • INSTANCE_USER=admcensored
  • ‘[’ -z 00 ‘]’
  • ‘[’ -z SIDcensored ‘]’
  • do_query SIDcensored 00 admcensored
  • local SID=SIDcensored
  • local INSTANCE=00
  • local INSTANCE_USER=admcensored
  • local HOSTNAME
  • local ‘INSTANCE_NAME=[[SIDcensored 00]]’
  • local SAP_LANDSCAPE
    ++ su - admcensored -c ‘python /usr/sap/SIDcensored/HDB00/exe/python_support/landscapeHostConfiguration.py’
  • SAP_LANDSCAPE=’| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
    | | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |
    | | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |
    | ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |
    | censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |

overall host status: ok’

  • ‘[’ -z ‘’ ‘]’
    ++ sap_hana_host_from_landscape '| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
    | | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |
    | | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |
    | ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |
    | censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |

overall host status: ok’
++ local 'landscape=| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |
| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |

Partition Partition Group Group Role Role Role Role Roles Roles Groups Groups
censored yes ok 1 1 default default master 1 master worker master worker worker default default

overall host status: ok’
++ local col_hosts=1
++ local row_hosts_start=5
++ local cur_row=1
++ local cur_hostname
++ local cur_IP
++ read -r line
++ [[ | != | ]]
+++ echo ‘| Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |’
+++ sed -e ‘s/^|//’
++ line=’ Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker |’
++ ‘[’ 1 -ge 5 ‘]’
++ cur_row=2
++ read -r line
++ [[ | != | ]]
+++ echo ‘| | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |’
+++ sed -e ‘s/^|//’
++ line=’ | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual |’
++ ‘[’ 2 -ge 5 ‘]’
++ cur_row=3
++ read -r line
++ [[ | != | ]]
+++ echo ‘| | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |’
+++ sed -e ‘s/^|//’
++ line=’ | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups |’
++ ‘[’ 3 -ge 5 ‘]’
++ cur_row=4
++ read -r line
++ [[ | != | ]]
+++ echo ‘| ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |’
+++ sed -e ‘s/^|//’
++ line=’ ---------- | ------ | ------ | -------- | ------ | --------- | --------- | -------- | -------- | ---------- | ---------- | ----------- | ----------- | ------ | ------ | ------- | ------- |’
++ ‘[’ 4 -ge 5 ‘]’
++ cur_row=5
++ read -r line
++ [[ | != | ]]
+++ echo ‘| censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
+++ sed -e ‘s/^|//’
++ line=’ censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
++ ‘[’ 5 -ge 5 ‘]’
+++ echo ’ censored | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |’
+++ awk -F ‘|’ ‘{print $col}’ col=1
+++ sed -e ‘s/^[[:space:]]//’ -e 's/[[:space:]]$//’
++ cur_hostname=censored
++ [[ -z censored ]]
+++ nslookup censored
+++ grep Address
+++ grep -v ‘#’
+++ awk ‘{print $2}’
++ cur_IP=
++ [[ -z ‘’ ]]
++ continue
++ read -r line
++ [[ ‘’ != | ]]
++ break

  • HOSTNAME=
    +++ query_sap_hana_status
    +++ cat
    ++ mk_hdbsql SIDcensored 00 admcensored ‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or
    NAME=’’‘All Started’’’’
    ++ local sid=SIDcensored
    ++ local instance=00
    ++ local instance_user=admcensored
    ++ local query
    +++ echo ‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or
    NAME=’’‘All Started’’’’
    +++ tr ‘\n’ ’ ’
    ++ query=‘SELECT Name, Status, Value FROM M_SYSTEM_OVERVIEW Where NAME=’’‘Version’’’ or NAME=’’‘All Started’’’ ’
    ++ local credentials
    ++ local hdbsql_path=/usr/sap/SIDcensored/HDB00/exe/hdbsql
    ++ ‘[’ -n usercensored ‘]’
    ++ credentials=’-U usercensored’
    ++ ‘[’ ‘’ = agent ‘]’
    +++ 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
  • status_output=
  • echo ‘<<<sap_hana_replication_status>>>’
    <<<sap_hana_replication_status>>>
  • echo ‘[[SIDcensored 00]]’
    [[SIDcensored 00]]
  • sap_hana_replication_status SIDcensored 00 admcensored
  • local sid=SIDcensored
  • local instance=00
  • local instance_user=admcensored
    ++ su - admcensored -c ‘python /usr/sap/SIDcensored/HDB00/exe/python_support/systemReplicationStatus.py’
  • result=‘this system is not a system replication site’
  • echo ‘systemReplicationStatus: 10’
    systemReplicationStatus: 10
  • echo ‘this system is not a system replication site’
    this system is not a system replication site
  • ‘[’ -v PASSWORD_CONNECT ‘]’
  • read -r line