The publication does not use dynamic filtering

• WhiteLotus

  SSChampion

  Points: 12122

  More actions

  March 20, 2016 at 11:20 pm

  #305838

  Hi All,

  Msg 20674 level 16 , state 1 , Procedure sp_addmergerpartition, Line 31

  The publication does not use dynamic filtering

  I got above error after running this below script (This error seems refer to @hostname = @operatorName) :

  :setvar mergeAgentLogin N'XYZ\ABC'

  :setvar mergeAgentPWD N'asdasdhasjd'

  :setvar subscriberInstance N'<SQLServerInstanceHere>';

  :setvar operatorName N'<OperatorName>';

  DECLARE@publicationName AS sysname;

  DECLARE@subscriberInstance AS sysname;

  DECLARE @operatorName AS nvarchar(100);

  DECLARE @mergeAgentLogin AS nvarchar(256);

  DECLARE @mergeAgentPWD as sysname;

  SET @publicationName = N'DeviceCommsMergePublication';

  SET @mergeAgentLogin = $(mergeAgentLogin);

  SET @mergeAgentPWD = $(mergeAgentPWD);

  SET @subscriberInstance = $(subscriberInstance);

  SET @operatorName = $(operatorName);

  USE[TMS]

  -- Create a new subscription to the merge publication

  EXECsp_addmergesubscription

  @publication = @publicationName,

  @subscriber = @subscriberInstance,

  @subscriber_db = N'TMS',

  @subscription_type = N'Push',

  @sync_type = N'Automatic',

  @subscriber_type = N'Global',

  @subscription_priority = 75,

  @description = N'',

  @use_interactive_resolver = N'False',

  @hostname = @operatorName

  -- Add agent job that will schedule the synchronization of the push subscription to the merge publication

  EXECsp_addmergepushsubscription_agent

  @publication = @publicationName,

  @subscriber = @subscriberInstance,

  @subscriber_db = N'TMS',

  @job_login = @mergeAgentLogin,

  @job_password = @mergeAgentPWD,

  @subscriber_security_mode = 1,

  @publisher_security_mode = 1,

  @frequency_type = 1,

  @frequency_interval = 0,

  @frequency_relative_interval = 0,

  @frequency_recurrence_factor = 0,

  @frequency_subday = 0,

  @frequency_subday_interval = 0,

  @active_start_time_of_day = 0,

  @active_end_time_of_day = 235959,

  @active_start_date = 0,

  @active_end_date = 0

  -- Create dynamically filtered partition for subscription that is filtered by the values of HOST_NAME.

  EXECsp_addmergepartition

  @publication = @publicationName,

  @suser_sname = N'',

  @host_name = @operatorName

  -- Execute batch

  GO

  Anybody knows what is the meaning of The publication does not use dynamic filtering ?

  any feedback are much appreciated

  cheers

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 21, 2016 at 3:23 pm

  #1866631

  Probably something to do with this part:

  EXECsp_addmergepartition

  does a merge partition require a dynamic filter?