Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Updatable Subscriber fails to update publisher on SQL Serv..

 
   Database Forums (Home) -> Replication RSS
Next:  Different data types causing problem?  
Author Message
Jack Harris

External


Since: Aug 29, 2008
Posts: 3



(Msg. 1) Posted: Fri Nov 14, 2008 4:44 pm
Post subject: Updatable Subscriber fails to update publisher on SQL Server 2000
Archived from groups: microsoft>public>sqlserver>replication (more info?)

I'm having a problem with a transactional publication failing to add records
from a updatable subscriber on 2000 SP4.

When the Queue Reader Agent runs I get the 'could not find stored proceedure
ins.sp_MSsync_ins_articlename' error.

The one article I can find on the subject states that the problem is the
value of queue_id in the MSsubscription_agents table on the subscriber, which
should be 'mssqlqueuev2'. I've tried that fix and it doesn't work. In fact,
after inserting a record on the publisher the value gets changed back to
'mssqlqueue' on the subscriber.

I set this up taking a backup of the publication database after the
publication is created and applying it to the subscriber. Then I run the
distribution agent once and then change the value in queue_id. I then apply
the scripts generated by sp_scriptpublicationcustomprocs and
sp_script_synctran_commands on the publisher. I assume that these scripts
still need to be used on SP4 for a no sync initialization of the subscriber.

Anyone have any ideas or suggestions? We will be moving all the databases to
2005 in the future, but that probably won't happen until late December or
January and we need to get this working ASAP.

Thanks
--
Jack Harris

 >> Stay informed about: Updatable Subscriber fails to update publisher on SQL Serv.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Subscriber updatable transactional error. - Well I have this working one way now but I still can't get updates from the subscriber to work. I started out with immediate updating but that setting would not let me login to my application, probably because the login process needed to update the..

Publisher/Subscriber role - Can a replica database be publisher and at the same time subscriber. If so, Is Merge replication OK for applying to go in this environment and how should I configure the replicas as a subscribers or publishers? Thanks for your answers. Car.

Adding new subscribers to a publisher - We are using Merge Replication on SQL 2000 The snapshot on our publisher has a 180 day retention period. We are able to add new subscribers just fine within that 180 days, but it seems that come day 181 when we add a new subscriber it is missing a..

Replicate subscriber changes up...but accept no Publisher .. - Hello... There are some audit tables in my subscriber data that I want to upload to the server during replication....but I do not want to have any data returned to the subscriber....from any other subscribers or the publisher. I was thinking of using...

Rows do not match between Publisher and Subscriber. (Possi.. - I have a transactional updatable subscriber database that works fine for all articles (164 of them) apart from one where I continuously get the error above. The thing is, msrepl_tran_version is the same on both the publisher and the subscriber. I hav...
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]