Tuesday, February 21, 2012

Replication. Cant delete rows

Hi All.

I have the folling replication issue:

BD1 > BD0
Replicate with filter

BD2 > BD0
Replicate with filter

BD3

Four data bases BD0,BD1,BD2,BD3
In BD1 y BD2 there are two merged publications subscribed continuous in BD0.
The publications are defined as insert only and allow changes in the subscriber. Everything works perfectly. The records replicate immediately. In BD0 you can insert and modify records, however when I attemept to delete a record I get the following message:

error:

You can't insert a row with a duplicate key in the object 'dbo.MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone'

Note: This is a translation of the original error message in Spanish below.

No se puede insertar una fila de clave duplicada en el objeto
'dbo.MSmerge_tombstone' con índice único 'uc1MSmerge_tombstone'

Cheers,

Have you defined multiple publications? i.e. a publication that is sent from BD0 to BD1 and a different publication that is sent from BD0 to BD2?

No comments:

Post a Comment