Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-19 : 12:20:48
|
| Dian writes "Hi I don;t know how to explain my feelings about SQL Server replication ......It is the most boring and strange stuff i ever met...sometimes it works sometime it doesn't even i have same configuration that works other times?...here is my probs:i have 4 servers server1 with SQL 2000 server2 with SQL 2000server3 with SQL 2000 server4 with SQL 2000server1 is distibutor and publisherservers2 to 4 are subscribers with imediate update chanegs at subscribersOn server1 have 3 articles to replicate with transactional replication these 3 articles is 3 tables each of them has clustered PK...in the beginning replication did not work at alli recieves messeges DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_prod_det_info_proddet'. The conflict occurred in database 'xxx', table 'prod_det_info', column 'prod_det_id'.(Source: server2 (Data source); Error number: 547)---------------------------------------------------------------------------------------------------------------The row was not found at the Subscriber when applying the replicated command.(Source: server2 (Data source); Error number: 20598)---------------------------------------------------------------------------------------------------------------but actually i was doing UPDATE on articles in Server1 and all of my subscribers interpreted it as DELETE/INSERT (deffered UPDATE) and it stoped synhronization on servers 2 to 4 welldone SQL Server welldone !!!!I remove clusered index and it begin work :)) welldone but i want CLUSERED index !!!!and i put it again - clusered index! I read about sp_scriptdynamicupdproc which came with SP1 and i executed it on my articlesand what a miracle - replication become work and when i UPDATE my articles in server1 the update reaches and servers 2 to 4 (but even that i'm not sure if sp_scriptupdproc helped me) ok then !!!Doing an UPDATE at server2(as expample) makes changes and replicate them to server1 and then I recieves same messeges on agents for Server3 and server4:DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_prod_det_info_proddet'.The conflict occurred in database 'sanita', table 'prod_det_info', column 'prod_det_id'.(Source: server3 (Data source); Error number: 547)---------------------------------------------------------------------------------------------------------------The row was not found at the Subscriber when applying the replicated command.(Source: server3 (Data source); Error number: 20598)---------------------------------------------------------------------------------------------------------------same error at server4 no errors on server2 and server1what is that nasty hell i am in ????? my hell is named SQL Server replicationcan some one help? thanks" |
|
|
|
|
|
Transactional Repl HELP