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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 About Rplication error

Author  Topic 

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-20 : 04:26:55
I hvae got the messge 'the process could not deliver update(S) to the subscriber'

fazle rabbee

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-20 : 06:04:16
Post full error message and type of replication.
Go to Top of Page

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-20 : 10:41:04
I am facing the follwing problem while trying to replicate data of a table. the error message is 'Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'. Please give me solution asap.

fazle rabbee
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-20 : 14:09:45
Looks like you have unique key in subscriber but not in publisher.
Go to Top of Page

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-21 : 00:05:13
So what should I do for the solution.

fazle rabbee
Go to Top of Page

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-21 : 00:50:46
Please I need an an urgent solution.

fazle rabbee
Go to Top of Page

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-21 : 03:16:46
For your kind information I have already installed the latest SP for 2000 server (SP4)

fazle rabbee
Go to Top of Page

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2009-02-21 : 05:54:34
Now I am getting the follwing error 'Attepting to run merge replication - get the error "The merge process could not initialize the subscription'. Please tell me what is the solution?


fazle rabbee
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-21 : 09:11:36
Remove the duplicate row in subscriber and start replication.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-21 : 09:14:32
If this is the issue then you should do like this:

http://support.microsoft.com/kb/278629
Go to Top of Page
   

- Advertisement -