Troubleshooting¶
This section provides procedures for diagnosing and resolving common issues encountered during the deployment and operation of the SAP HANA plugin.
Logging¶
The primary source for diagnostic information is the Zabbix Agent 2 log file. To obtain detailed information regarding plugin operations, increase the DebugLevel in the zabbix_agent2.conf file and restart the agent service.
Common Issues¶
Insufficient Privilege
Ensure the dedicated monitoring user has all required grants.
You can usually run CALL SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('<Error message GUID>', ?) as a database administrator to get more detailed information.
Connection Timeout
Adjust Plugins.SAPHANA.Timeout in the configuration file if the network connection takes too long to be established.
Adjust Plugins.SAPHANA.CallTimeout in the configuration file if the database is slow to execute queries.
TLS Certificate Validation
The HANA cloud connection requires SNI, and the Plugins.SAPHANA.Sessions.<SessionName>.TLSServerName parameter may be set in the plugin configuration file to provide the correct hostname.
The plugin uses the root certificate set provided by the host, which usually comes with the necessary certificates. To provide an alternative root certificate, the Plugins.SAPHANA.Sessions.<SessionName>.TLSRootCAFile parameter may be set in the plugin configuration file.
If certificate validation fails (e.g., when using self-signed certificates), the Plugins.SAPHANA.Sessions.<SessionName>.TLSInsecureSkipVerify parameter may be set to true in the plugin configuration file. Note that this should be evaluated against organizational security policies.
License Invalid
Ensure the LicenseKey is correctly copied into the configuration file without extra characters.
If using a subscription type license, ensure that the host can connect to the internet.