HA - Transnational Replication issue RRS feed

  • Question

  • Hi All,

    I have an issue in Transnational replication. while configuring replication i have below issues,

    1. I've set the article properties Action if name is in use =Keep existing object unchanged, after completing setup above condition is resetting to default(Drop existing object and create a new one)
    2. For Statement delivery type I've made changes to different types for different articles not to deliver all types of statement(INSERT, UPDATE and DELETE), but after completion all configurations are resetting to default, it's replicating all statements. 
    3. Also getting errors(The process could not bulk copy into table '"dbo"."Table"'.(Source: MSSQL_REPL, Error number:MSSQL_REPL20037) and Batch send failed Violation of PRIMARY KEY constraint 'PK_**'. Cannot insert duplicate key in object 'dbo.Table'. The duplicate key value is (2). (Source: MSSQLServer, Error number: 2627))
    4. Also setup for -SkipErrors with 2601, 2627, and 20598 

    I am not sure why and how this happening regularly all the time. some more info in below,

    Microsoft SQL Server 2012 - 11.0.5058.0 (X64)-Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600:)(Hypervisor)

    OS - Microsoft Windows Server 2012 R2 Standard. 

    Please help me on this. 

    Syed Jakeer

    • Moved by Tom Phillips Saturday, August 20, 2016 4:06 PM Replication question
    Wednesday, August 17, 2016 11:16 PM


All replies