SAP Knowledge Base Article - Public

2826355 - Numeric overflow exception while applying non-EC eligibility rules - Compensation

Symptom

When applying eligibility rules for Compensation template there is an error message:

Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: com-successfactors.compensation.util.exception.CompensationEJBException:
Exception while CompMiscUtil.applyEligRule: ;nested exception is: com.successfactors.sca.service.SetviceLegacyRoIIbackException:
Exception: DAO Exception caught: DAOException caught: Rule: Last Increase, SQL Exception: [314]: numeric overflow: search table error: [6944] exception 70006944: AttributeEngine: overflow in numeric calculation At com.successfactors.compensation.service.schedulejob.CompApplyEligRuleJob.executeJob(CompApplyEligRuleJob.java:159)

**Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental**

Environment

  • SAP SuccessFactors Compensation
  • SAP SuccessFactors HXM Suite

Reproducing the Issue

When applying eligibility rules from Plan Setup > Plan Details > Eligibility, the job details show an error message as well as the below message within the UI.

compensation ec rule failure.png

Cause

This is due to employee data being incorrectly formatted.

In most cases, when you define these rules for EC or non-EC employees the problem can be caused by the date fields being used.

Resolution

Should you encounter this error message while applying eligibility rules please check all employee data and ensure the fields being used are correctly formatted.

For example, within the UI for non-EC rules you set a hire date to be = 12/30/2019 however in the UDF an employee's hire date can be 30/12/2019 or in order invalid formats like 30.12.2019.

When using EC business rules check the rule conditions against employee data in people profile.

See Also

2085255 - Custom/Standard date field format - Compensation

Keywords

70006944, CompApplyEligRuleJob, table search error, numeric overflow, compensation rule failure, ec rule failure, rules fails, , KBA , LOD-SF-CMP , Compensation Management , Problem

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM suite all versions