topic Re: Two publication for one database - Unexpected Behavior in Qlik Replicate

Two publication for one database - Unexpected Behavior

epanosian — Wed, 02 Nov 2022 14:44:37 GMT

Hello,

For a few databases, when Qlik Replicate task created two publications on the same database with required articles. I removed articles from second publication and added them to the first and then removed second publication. After a bulk reload, Qlik created the second publication without article. How can I remove permanently the second publication?

SQL Server 2016

Qlik Replicate: May 2022 (2022.5.0.395)

Thank you,

Estifan

Re: Two publication for one database - Unexpected Behavior

SwathiPulagam — Wed, 02 Nov 2022 14:51:25 GMT

Hi @epanosian,

What are the publication names?

Thanks,

Swathi

Re: Two publication for one database - Unexpected Behavior

epanosian — Wed, 02 Nov 2022 14:57:40 GMT

@SwathiPulagam ,

two different names: [database name] AR_PUBLICATION_nnnn and [database name] AR_PUBLICATION_mmmm

Thank you,

Estifan

Re: Two publication for one database - Unexpected Behavior

SwathiPulagam — Wed, 02 Nov 2022 15:18:15 GMT

Hi @epanosian,

When we start the Qlik Replication task with SQL Server as a source, Qlik Replicate will verify whether the MS Replication feature is enabled or not, and once all the pre-requisites are met Qlik replicate will try to create the publication with the name AR_PUBLICATION_XXXX where XXXX represents the dbid of the Replicated database

For any reason, if your dbid is changed and you want to maintain one publication then it must match with the name AR_PUBLICATION_XXXX where XXXX represents the dbid of the Replicated database

Below is the article link for your reference:

https://community.qlik.com/t5/Official-Support-Articles/How-does-Qlik-Replicate-define-the-publication-name-in-SQL/ta-p/1936826

Thanks,

Swathi

Re: Two publication for one database - Unexpected Behavior

epanosian — Wed, 02 Nov 2022 18:34:24 GMT

that explained the issue and I was able to remove duplicates.

For another database, I see duplicate jobs:

serverA-databaseA-AR_PUBLICATION_00023-100 and

serverA-databaseA-AR_PUBLICATION_00023-99

any link to an article for this?