SAP Knowledge Base Article - Public

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

Symptom

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';

Environment

Employee Central - Alerts and Notifications

Reproducing the Issue

Scheduled automatic EC Alerts and Notifications job fails when executed.

Cause

(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.

Resolution

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

capture.jpg

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

 

Keywords

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

Product

SAP SuccessFactors HCM Core 1702