none
Replication-Subscription create Error RRS feed

  • Question

  • erverA : publication

    Server B: subscription

    type : push

    created pub, while create sub am getting below error,

    when i try to create sub from T-SQL also getting error,

    Job 'SERVERA--_cat_prodwe-SERVERB-93' started successfully.
    Warning: The distribution agent job has been implicitly created and will run under the SQL Server Agent Service Account.
    Msg 207, Level 16, State 1, Procedure sp_helpdistributor, Line 272 [Batch Start Line 0]
    Invalid column name 'deletebatchsize_xact'.
    Msg 207, Level 16, State 1, Procedure sp_helpdistributor, Line 273 [Batch Start Line 0]
    Invalid column name 'deletebatchsize_cmd'.
    Wednesday, October 24, 2018 5:13 AM

All replies

  • What SQL versions are your Publisher/Distributor/Subscriber?
    Wednesday, October 24, 2018 6:11 AM
  • Pub & Distri:  (push)

    Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)   Mar 18 2018 09:11:49   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor) 

    SUB: 

    Microsoft SQL Server 2016 (SP1-CU10-GDR) (KB4293808) - 13.0.4522.0 (X64)   Jul 17 2018 22:41:29   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) 

    by adding two column

     dbo.MSdistributiondbs in msdb database.

    The two columns are deletebatchsize_xact (int), deletebatchsize_cmd (int) and default values of 5000 and 2000 respectively.

     ( there is replication setup running with more than 2 pub- is this affect  existing replication setup?)


    Wednesday, October 24, 2018 10:07 AM
  • These columns were added recently.

    They should have been added with SQL Server 2012 SP4 and SQL Server 2016 SP2 - which it looks like you have.

    Have you tried the steps outlined here:

    https://stackoverflow.com/questions/50157260/invalid-column-name-deletebatchsize-xact-and-deletebatchsize-cmd

    Wednesday, October 24, 2018 1:53 PM
    Moderator
  • after added it's working....no disturbance on my existing replica setup..
    Thursday, October 25, 2018 2:03 AM