3067705 - HRIS Sync Job Failed with error org.hibernate.exception.GenericJDBCException: could not prepare statement

HRIS Sync Job is failing, job details error:
Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: org.hibernate.exception.GenericJDBCException: could not prepare statement
at com.successfactors.hris.service.scheduledjob.hrissync.HrisSyncJob.executeJob(HrisSyncJob.java:704)
at com.successfactors.jobscheduler.jobimpl.SimpleJob.execute(SimpleJob.java:411)

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