topic Re: Qlik Replicate Internal Parameters in Qlik Replicate

Qlik Replicate Internal Parameters

KG93 — Tue, 11 Jan 2022 15:53:30 GMT

What's the internal parameter on Qlik Replicate to handle duplicates?

Re: Qlik Replicate Internal Parameters

Heinvandenheuvel — Tue, 11 Jan 2022 16:22:22 GMT

The best way to handle duplicate is to avoid them in the first place.

Unfortunately your question and subject are not very complete or useful for future reference by others.

My best guess is that you are interested in controlling the error handling when a target apply fails due to a uniqueness (PK) constraints being violated. Correct?

If so, that is controlled though task error handling which be default uses the global error handing rules.

In the UI go to SERVER - Global Error Handling - Apply Conflicts - Drop down for 'Duplicate key when applying' and make your choice from a drop-down. See attached picture.

No internal parameter needed and if there was it would be endpoint specific where you did not indicate anything (source, target, version...)

hth,

Hein.

Re: Qlik Replicate Internal Parameters

KG93 — Tue, 11 Jan 2022 16:25:32 GMT

You got my question half correct. Is there a way to handle duplicates using internal parameters?
I have server settings in place.

Thanks in advance.

Re: Qlik Replicate Internal Parameters

Heinvandenheuvel — Tue, 11 Jan 2022 16:54:52 GMT

Hmm, You really like to keep us guessing what the real underlying question is, what the problem is which you are trying to solve, or is this like an exam question ?

There is an internal parameter "ignoreDuplicateKey" which is used by SQLserver type endpoints during the PK index creation, adding "WITH (IGNORE_DUP_KEY = ON )" to the create statement.

Default is FALSE for Azuresqlmanagedinstance, Microsoftazuresqlmscdc, Rdssqlserver, Sqlserver;
True for Sqlazure

Hein.

Re: Qlik Replicate Internal Parameters

lyka — Sat, 15 Jan 2022 00:51:07 GMT

Hello,

To avoid the task to go one-by-one due to duplicate errors, you can set the apply error handling to use MERGE

The option to change is:

Got to task settings > error handling > apply conflicts.

Duplicate key when applying an INSERT: > Update the existing target record:

thanks

Lyka