Alerts stopped working when the user got terminated

Summary:

Scheduled alerts stopped working when the user got terminated

Content (please ensure you mask any confidential information):

Hi,

We have some scheduled alerts in the system which stopped working when the user who created and scheduled it got terminated. We copied the alert and scheduled it from an active user but got the below in the log of the alert.

Recommendations :

1. Filter expression contains -> SYSDATE. It should be modified getCurrentDate() and addDays as shown below:

eg: sysdate+14 => ${AlertFilterUtils.addDays(AlertFilterUtils.getCurrentDate(),14)}

2. The resources that are used in templates should have atleast one filter, if no filter exists add dummy filters like 1=1 for better performance