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

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