Symptom
This article outlines the top 5 most common errors which may cause the Employee Central History Processor job to fail.
**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 Sucessfactors Variable Pay
Resolution
1. “Could not access code; in class: com.successfactors.hris.service.impl.Propertyresolver$PicklistOption.”
If instead of custom-string7 we decide to use the label or the code for this field (custom-string7.code or custom-strin7.label) we will not be able to import the History.
This happens as we have defined a picklist for custom-string7.
This is a limitation to legacy picklists. By defining jobInfo.custom-string7 the system will return the option externalCode, and if the option externalCode doesn’t exist then it will return the option ID.
2. "Proration is 0 due to decimal places of pro-ration is too short”.
This error happens when there are assignments of days or maybe a single day and the decimal precision for proration is too small. For example, if there is an assignment of 1 day:
If our proration is using 2 decimals we are defining a proration for this assignment of 0, so when used in calculations:
Making the import fail.
The solution is to increase the number of decimals used by the proration field, for example #,##0.0000.
3. "Cannot cast class java.lang.String to class java.lang.Number”
Happens when mapping custom-string fields to fields that require a numeric value.
When that happens the system shows an error as we are trying to convert text fields into number type fields and the ECT History Import fails to complete.
It is necessary to define the target fields as numeric fields instead of string type.
4. "Wrapped Exception: Fail to add background: SQLException executing:”
This happens when there is a field within the VarPay's Background Section in the data model that is mapped to a float number but the value stored in EC is not a valid float number.
Sample Error: This scheduled job failed to complete. For details, please contact SuccessFactors customer support.
com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: Fail to add background: SQLException executing: insert into stg17sfv4_STOCKPM170081.SM_BACKGROUND (SM_BG_ID,USERS_SYS_ID,SM_BG_TYPE,SM_BG_NAME,SM_BG_DESC,SM_BG_VFLD1,SM_BG_VFLD2,SM_BG_VFLD3,SM_BG_VFLD4,SM_BG_VFLD5,SM_BG_VFLD6,SM_BG_VFLD7,SM_BG_VFLD8,SM_BG_VFLD9,SM_BG_VFLD10,SM_BG_VFLD11,SM_BG_STARTDATE,SM_BG_ENDDATE,SM_BG_DFLD1,SM_BG_DFLD2,SM_BG_DFLD3,SM_BG_DFLD4,SM_BG_IFLD1,SM_BG_IFLD2,SM_BG_IFLD3,SM_BG_IFLD4,SM_BG_FFLD1,SM_BG_FFLD2,SM_BG_FFLD3,SM_BG_FFLD4,SM_BG_LASTMODIFIED,SM_BG_ORDERPOS,ATTACHMENT_ID,SM_BG_VFLD12,SM_BG_VFLD13,SM_BG_VFLD14,SM_BG_VFLD15,SM_BG_IFLD5,SM_BG_IFLD6,SM_BG_IFLD7,SM_BG_IFLD8,SM_BG_FFLD5,SM_BG_FFLD6,SM_BG_FFLD7,SM_BG_FFLD8,SM_BG_VFLD16,SM_BG_VFLD17,SM_BG_VFLD18,SM_BG_VFLD19,SM_BG_VFLD20) values (stg17sfv4_STOCKPM170081.smbg_id_sq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)Using arguments: : 113106, varPayEmpHistDataECSourceGermany, , , , 4813, 4813, , 367, , , , , , , 2017-01-01 00:00:00.0, 2017-12-31 00:00:00.0, , , , , , , , , 28314.101653913916, 20.0, 161522,04, , 2018-03-01 20:02:53.182, -1, , , , , 1, , , , , , , , , , , , , ,
The solution is to correct the field value according to its type.
5. "java.lang.IndexOutOfBoundsException”
See article 2555961 - EC History processor job fails with java.lang.IndexOutOfBoundsException error
Keywords
ECT Processor, History, Employee History,Employee Central History Processor job, job fail, java.lang.IndexOutOfBoundsException , KBA , LOD-SF-VRP-EC , Employee Central data, configuration , LOD-SF-VRP , Variable Pay Programs , Problem