2447386 - EC Alerts: EC Alerts and Notifications job fails with "null object loaded from local variable 'conn'"

EC Alerts and Notifications job failing.

If we see the error in Job Details, it will be as below:

nested exception is: java.lang.NullPointerException: while trying to invoke the method java.sql.Connection.prepareStatement(java.lang.String) of a null object loaded from local variable 'conn';

Employee Central - Alerts and Notifications

Scheduled automatic EC Alerts and Notifications job fails when executed.

(This could be one fo the cause. however, the same error may happen for other reasons too)

One of the following values one of the configured "AlertMessage" objects used by one of the Alert Rules processed by the job is missing: alertHeader, alertDescription,alertHeaderLocalized, alertDescriptionLocalized.

Fill values of alertHeader, alertDescription,alertHeaderLocalized, alertDescriptionLocalized for those alert messages which would be triggered by EC Alerts and Notifications job:

To avoid any unhandled scenarios, you can consider providing values for above headers in all alert messages.

EC Alerts and Notifications job fails, ECT-65283, ECT-68224, Alert job fails, alerts not sent, notification not recieved, ECT-70425, nested exception is: java.lang.NullPointerException: while trying to invoke the method java.sql.Connection.prepareStatement(java.lang.String) of a null object loaded from local variable 'conn'; , KBA , LOD-SF-EC-ALR , Alerts & Notifications (saveAlert - EC Core only) , LOD-SF-EC , Employee Central , Problem