2447386 - EC Alerts and Notifications job fails - PARTNER

SAP Knowledge Base Article - Public

2447386 - EC Alerts and Notifications job fails - PARTNER

Symptom

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

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)

The following values in the configured alert message 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.

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.

See Also

ECT-65283

ECT-68224

Keywords

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

Product

SAP SuccessFactors HCM Core 1702