Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
ysseow
Contributor
Contributor

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

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 ?

Labels (1)
2 Replies
sureshkumar
Support
Support

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

john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!