February 5, 2003 at 3:54 pm
I setup immediate update subscriber between a publisher and a subscriber. I can make changes fine to the publisher, but when a change the replicated data on the subscriber nothing happens. No error msg, no data change. Nothing! The one-way replication works great. What am a doing wrong?
February 6, 2003 at 5:26 am
Start by seeing if replication created triggers on the subscriber tables? Is DTC running?
Andy
February 6, 2003 at 9:22 am
DTC is running. I do not see any triggers on the tables that are part of the replication articles.
February 6, 2003 at 10:24 am
if you got your publication properties and check updatable tab does that say is immediate updating enabled.
February 6, 2003 at 2:59 pm
Yes!
February 6, 2003 at 3:04 pm
Are you trying to perform bi-directional replication?
Bianca
February 6, 2003 at 3:30 pm
if you go and check the subscription properties (job history) you might get some more information. are u using pull or push subscription.
February 6, 2003 at 4:02 pm
quote:
Are you trying to perform bi-directional replication?Bianca
Yes!
February 6, 2003 at 5:31 pm
I called Microsoft support and they recommended Merge Replication for bidirectional replication.
Bidirectional Transaction Replication has a high probability of going on an infinite resonant loop.
Make sure that you have set 'SA' accounts for the databases in question - and the accounts are the same in both Publisher and Distributor.
February 25, 2003 at 2:02 am
Setting immediate updating subscribers option on the publication doesn't make the subscribers updating by default. When you set up the subscriber, you must enable advanced options (check box on the first screen) and another form will appear when going through the wizard to select updating subscriptions, but it defaults to the non-updating option. Hope this helps.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply