Two publication for one database - Unexpected Behavior

[epanosian]

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

[SwathiPulagam]

Hi @epanosian,

What are the publication names?

Thanks,

Swathi

[epanosian]

@SwathiPulagam ,

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

Thank you,

Estifan

[SwathiPulagam · Accepted solution]

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-publicati...

Thanks,

Swathi

[epanosian]

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?