BUGFIX ARCHIVE

Download link

Description: Insights 1802 FIX-006 HANA Alerts collector (syslog errors)

https://mats.datavard.com/downloader.php?ticketid=495e7c55a115e4c9c92c90b4123ae973

Password: Datavard1

Transports requests

Transport request must be imported to the central system and all satellite systems. 

Bugfix is also valid for the version 1711.

ISSUE DESCRIPTION

The 'HANA Alerts' collector terminates with the error message: "Invalid column name: ALERT_HOST: line 1 col 54 (at pos 53)..."

ERROR DESCRIPTION

In previous releases of HDB, the system table with HANA alerts doesn't contain the field 'ALERT_HOST'. Error messages are displayed in a system log (transaction SM21).

SOLUTION

The collector checks if the field 'ALERT_HOST' exists in the system table with HANA alerts and based on this, the field is included/excluded in a SQL query.