EC Alerts and Notifications job failing in the provisioning.
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
Reproducing the Issue
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)
The following values in the configured alert message 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.
Also, the error message in the job details is being discussed to be made user friendly in case of missing headers via enhancement ticket #ECT-70425.
EC Alerts and Notifications job fails Alert job fails alerts not sent notification not recieved , KBA , LOD-SF-EC-ALR , EC Alerts & Notifications , LOD-SF-EC , Employee Central , Problem