SAP Knowledge Base Article - Public

3696687 - Sync Employee Central Dependents with Benefits Job failing

Symptom

  • After activating the "Latest Overview Benefits" feature, the "Sync Employee Central Dependents with Benefits" job failed to complete successfully.
  • Error message: "Error occurred. com.successfactors.db.dao.DAOException: thrown could not extract ResultSet".

Environment

  • SAP SuccessFactors Employee Central
  • Global Benefits module

Reproducing the Issue

  1. Activate the "Latest Overview Benefits" feature in the environment.
  2. Run the "Sync Employee Central Dependents with Benefits" job.

Cause

Issue arose due to long-running job not completing the synchronization of multiple employees when the legal entity has a large number of active employees.

Resolution

  1. The job execution has been optimized to ensure it completes sooner.
  2. An option has been introduced to run the job only for active users or only for inactive users. The default option is to run for active users only.
  3. As a workaround, execute the job in smaller batches of worker IDs belonging to the legal entity.

See Also

Refer to: Syncing Employee Central Dependents Data For The Latest Benefits Enrollment Experience | SAP Help Portal

Keywords

sync employee central dependents, benefits module, latest overview benefits, job failure, data inconsistency, dependents synchronization, error message, com.successfactors.db.dao.DAOException, ResultSet extraction error, long-running job, active users, inactive users, batch execution, legal entity,  , KBA , LOD-SF-EC-GBF , Global Benefits , Known Error

Product

SAP SuccessFactors Employee Central 2511