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 - 2003-08-27 : 07:56:50
|
| Superoliver writes "Hi Everyone.We here at BEX have a problem that we are unable to resolve. We are running merge replication between all our 7 branchs. Our problem comes in where data seems to misterouisly drops off the system. Some are in the conflict table and have been deleted because of a primary key violation, what causes this (Besides the primary key violation) and how do we stop it? But this is the minor one, we are also getting "System deletes" from foreign key errors, we don't feel confident building our own COM resolvers and some of our tables don't even have foreign keys! Could anyone please give us some direction as to what else could cause this and how to stop it. Please can you also explain the consiquenses of turning the foreign key replication off?Your help will be greatly appriciated.Thanks alot,Derrick" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-27 : 13:08:48
|
| I am not understanding. Is the data being deleted at the publisher? If it is happening at the publisher, then your application needs to fix this. If it is happening at the subscriber, then you've got a problem with replication and it probably just needs to be redone. When a primary key is violated, data does not get deleted. The row that is trying to be inserted will just not get inserted. I do not know what you mean by "system deletes". Please explain this.Tara |
 |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-08-27 : 20:40:47
|
| Greetings,I had the similar situation while supporting merge replication between 500 distributed subscribers. It took lot of debugging before I could get over this problem.Beside all the Questions Tara has asked, can you please answer the following * How do you generate your primary Key's?* Is Not For Replication Property selected for Primary Key fields?* what is your implemented conflict resolution policy ?Cheers,Samrat |
|
|
|
|
|
|
Merge Replication, "System delete"