idea Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load in Suggest an Idea

Qlik Replicate: Handling Duplicate Rows when doing a Full Load

Wim — Mon, 15 Mar 2021 15:03:36 GMT

Some tables that are heavily updated on the source during a full reload of that table on the target, generate duplicate insert errors.

This is a known issue described in much detail in the QLIK KB here.

However, since version 6.6 the workaround described in that article no longer works, and produces an error. The syntax of the string that needs to be put in the table settings has changed.

I open this request to have this formally implemented as a feature/option that should be enabled by default for DB2 z/OS or DB2 AS/400 databases. Currently it is a "hidden" internal feature to workaround this issue, and thus not supported and not stable.

It is crucial for our business that this gets implemented.

Related case: 02138955 - INITIAL LOAD FAILS WITH DUPLICATE INSERT ERRORS WHILE APPLYING CACHED EVENTS.

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load - Status changed to: Open - On Roadmap

Shelley_Brennan — Mon, 22 Mar 2021 13:15:04 GMT

Thank you for the suggestion. We will continue to collect feedback from others as well.

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load - Status changed to: Open - In Development

Shelley_Brennan — Thu, 13 May 2021 15:27:02 GMT

Improvements here are under development. Thank you!

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load

Wim — Tue, 18 May 2021 13:49:06 GMT

Hello, do you have an idea what release this will be available in?

We are planning a product upgrade and consider waiting for this if it's not too far away. Thanks.

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load

Shelley_Brennan — Thu, 10 Jun 2021 21:05:08 GMT

It is a candidate for the Nov 2021 release. I don't think it will be available sooner than this. Thanks!

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load

Shelley_Brennan — Tue, 19 Oct 2021 21:32:12 GMT

This request has been implemented for DB2 z/OS sources in our upcoming November release. Technical Preview for this release should be out later this week. Please take a look and provide any early feedback. Thank you!

Re: Qlik Replicate: Handling Duplicate Rows when doing a Full Load - Status changed to: Partially Delivered

Shelley_Brennan — Fri, 12 Nov 2021 21:36:55 GMT

This has been addressed for DB2 z/OS sources in the Nov 2021 release of Qlik Replicate.