SAP HANA – error: Cannot invoke “String.regionMatches(int, String, int, int)” because “text” is null

After changing Alerts -> “Configure E-Mail Functions” in SAP HANA Studio I received an error like below on the screen. I tried only changed recipient’s e-mail address.

Solution

Run below SQL statement to overwrite the NULL value

Update "_SYS_STATISTICS"."STATISTICS_ALERT_THRESHOLDS" set default_value = '' where default_value IS NULL;

Statement 'Update "_SYS_STATISTICS"."STATISTICS_ALERT_THRESHOLDS" set default_value = '' where default_value ...' 
successfully executed in 2 ms 963 µs (server processing time: 1 ms 782 µs) - Rows Affected: 4