3387965 - Error executing sql when trying to import candidate background information - Legacy Data Migration - Recruiting Management

• Unable to import candidate background information.
• Candidate Import job failed due to "Error executing sql".

SAP SuccessFactors Recruiting Management

1. Run a 'Candidate Import' job to import candidate background information.
2. The job failed due to an error: "Error executing sql : INSERT INTO xxx.RCM_CAND_CUSTOM_BG (CAND_BG_ID,CANDIDATE_ID,BG_TYPE,VFLD1,VFLD2,VFLD3,VFLD4,VFLD5,VFLD6,VFLD7,VFLD8,VFLD9,VFLD10,VFLD11,VFLD12,VFLD13,VFLD14,VFLD15,STARTDATE,ENDDATE,DFLD1,DFLD2,DFLD3,IFLD1,IFLD2,IFLD3,IFLD4,IFLD5,FFLD1,FFLD2,FFLD3,FFLD4,LAST_MODIFIED,ORDERPOS,SMDM_ID,LAST_MODIFIED_BY,CAND_INFO_ID,UUID,CHANGE_SOURCE,SM_BG_LASTMODIFIED) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)".

The text string in a background element data-field has exceeded the max-length of 4000 characters.

To resolve this issue, review the text value in each data-field column and ensure it does not exceed 4000 characters.

RCM, Import, Candidate Background Information, Error, SQL, Maximum Length, Characters, legacy data migration, candidate import , KBA , LOD-SF-RCM-CAN , General Candidate Issues (not Offers, not Profiles) , LOD-SF-RCM , Recruiting Management , Problem