Attachment is not created in sn_hr_ef_employee_document table when loading data through data source

Tejas9
Tera Expert

I am trying to transfer employee offer letter in "sn_hr_ef_employee_document".

I am using Data Source file Retrieval Method as Attachment.
In CSV file there are three columns 

employeeID,AttachmentName,document type,AttachmentContent(Base64 String) which is near about 800 characters.So there is no truncation issue.
In transform map I am mapping this field with Employee,file,document type.
To create a PDF file in sn_hr_ef_employee_document I am using onAfter Transform script.
Last log in the script throws below error "attachment sys id:Could not find a record in table 'sn_hr_ef_employee_document' with sys_id 'a71643b........"
But when trying to Test Data source then data is correctly load into staging table but when I see Target Record
it throws "Attachment not found" error message.

Record "Sys_id" is getting created at the backend but "sn_hr_ef_employee_document_upload.do" ui page throws "Attachment not found" error msg

Attaching screenshot for reference


#HRSD
#EDM

0 REPLIES 0