topic Replicate: apply conflict on select tables only within a task and not the whole task in Qlik Replicate

Replicate: apply conflict on select tables only within a task and not the whole task

ysseow — Wed, 03 Jan 2024 10:20:06 GMT

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 ?

Re: Replicate: apply conflict on select tables only within a task and not the whole task

sureshkumar — Wed, 03 Jan 2024 10:33:58 GMT

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:

Ideation | Qlik Community

Regards,
Suresh

Re: Replicate: apply conflict on select tables only within a task and not the whole task

john_wang — Wed, 03 Jan 2024 12:28:04 GMT

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.