Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My tasks have 50 tables. Only one of the table is giving problem no record found for Update. Is there a way to "Apply Conflicts" to that problematic table and not the whole task ?
Hello @ysseow
Error Handling--> Apply Conflicts will be applied for entire task, we cannot apply for a particular table(s).
You can raise a Feature request using a below link:
Regards,
Suresh
Hello @ysseow ,
Let's try to find out the RCA of the "Apply Conflicts" prior to a solution. The possibilities include data out of synchronization in a period of time, the PK or Unique Index columns values precision lost (eg missing milliseconds of timestamp data type), or 3rd party apps changed the target rows, the DELETE operation applying failure , the PK or Unique Index definition is not identical between source and target tables etc.
Set TARGET_APPLY to Verbose may get much helpful information in task log file. or temporarily change the apply mode from Batch optimized applyto Transactional apply to get the accurate PK values to understand the RCA.
Hope this helps.
John.