HRIS Sync Job is failing, job details error:
Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: org.hibernate.exception.GenericJDBCException: could not prepare statement
Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
SAP SuccessFactors Employee Central
This is caused by a value which is being synced exceeding the maximum length of the target field.
To resolve the issue the impacted values must have the value shortened.
If the sync has been failing for sometime you may need to run a Full HRIS sync may be needed to ensure the data of the instance is correct.
To find out what values/fields are causing the issue please raise a support case with LOD-SF-EC-HRS
EC Support Team, please review this KBA's internal memo for steps to highlight the impacted values/fields
HRIS, Sync, Failed, Prepare, Statement, CS20210001686684, INC0757919, GenericJDBCException: could not prepare statement, GenericJDBCException, could not prepare statement, inserted value too large for column , KBA , LOD-SF-EC-HRS , HRIS Sync , Problem