Hi,
I'm trying to create leave requests using SSIS.
For each Leave Request, I insert the first day on LeaveRequestV2 table and then add the remaining days on EssLeaveRequestDetail table.
However, I'm getting an error when trying to add the days on the EssLeaveRequestDetail table. In this table, the second day of each request is never inserted.
For example, for a leave request with days 21/10/2020, 22/10/2020 and 23/10/2020:
- 21/10/2020 -> is inserted on LeaveRequestV2 table
- 22/10/2020 -> is not inserted on EssLeaveRequestDetail table
- 23/10/2020 -> is inserted on EssLeaveRequestDetail table
I'm getting the error:
Write failed for table row of type 'EssLeaveRequestDetailEntity'. Infolog: Info: Cannot create a record in Leave and absence request detail (LeaveRequestDetail).\nThe record already exists.."
Here are the fields for each record on EssLeaveRequestDetail table:
Anyone knows what is the problem here and how can I fix this?
Best regards,
Ana Alves.
