Learn step-by-step solutions to resolve errors encountered during alert configuration in SAP HANA Studio
Symptom
After upgrading to HANA 2.0 SP06, the following alerts are generated on HANA studio:
Problems occurred when invoking code from plug-in: “org.eclipse.jface”.
java.lang.NullPointerException: Cannot invoke “String.regionMatches(int, String, int, int)” because “text” is null
Environment
HANA Studio
HANA 2.0
Cause
Above error occurred from HANA Studio because the default values for the alerts 89, 141, 710, and 999 is NULL.
These alerts were not present to maintain thresholds before HANA 2.0 SP06.
Resolution
Run below SQL statement to overwrite the NULL value.
Update "_SYS_STATISTICS"."STATISTICS_ALERT_THRESHOLDS" set default_value = '' where default_value IS NULL;