Qlik Replicate Internal Parameters

[KG93]

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

[Heinvandenheuvel]

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.

[KG93]

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.

[Heinvandenheuvel]

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.

[lyka]

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