SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Tracer tokens not moving from distributor to subscriber


Tracer tokens not moving from distributor to subscriber

Author
Message
harsh_raj_r
harsh_raj_r
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 48
I have a replication for which the commands are moving fine from distributor to subscriber but when i insert a tracer token, one out of the 5 subscribers isn't getting the token.... the tracer token tab in replication monitor shows pending for distributor to subscriber latency for this subscription... although any changes made in the articles is replicating just fine...

Anyone has any idea as what the problem could be... this is happening for a 2005 -> 2005 replication and also to a 2008 -> 2008 one... the subscriber and publisher database involved in these two replications are also used in several other replications but i don't see a problem there..
Derrick Smith
Derrick Smith
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2114 Visits: 715
Have you tried stopping and restarting the subscription?
harsh_raj_r
harsh_raj_r
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 48
yup!! tried stopping the distribution agent job and restarting it again.... also dropped and recreated the subscription... still the problem persists...
harsh_raj_r
harsh_raj_r
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 48
I have a replication for which the commands are moving fine from distributor to subscriber but when i insert a tracer token, one out of the 5 subscribers isn't getting the token.... the tracer token tab in replication monitor shows pending for distributor to subscriber latency for this subscription... although any changes made in the articles is replicating just fine...

Anyone has any idea as what the problem could be... this is happening for a 2005 -> 2005 replication and also to a 2008 -> 2008 one... the subscriber and publisher database involved in these two replications are also used in several other replications but i don't see a problem there..
harsh_raj_r
harsh_raj_r
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 48
this is a design problem... refer this for some details on this...


http://connect.microsoft.com/SQLServer/feedback/details/522602/tracer-tokens-should-post-to-all-subscriptions
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search