Hi, we have 2 replicas, let’s say Replica1 and Replica2. The Replica2 is only supposed to receive documents via a selection formula where the status field is published. If we have 5 documents in each replica and some one changes the status of a document in Replica1 to draft then upon next replication that document gets deleted from the Replica2. So at that point the Replica1 has 1 draft and 4 published documents while the Replica2 only ends up with 4 documents all published. Replication events in the log file indicate “Replicator Deleted x document(s)”. Does some one know why is replicator deleting it since the document was never deleted, just it’s status was changed? We still expected to see 5 documents in each replica. Puzzling part is this problem is intermittent. We thought about checking off deletions setting but we need to have it on since people will actually be deleting documents in Replica1 also and we would like the deletions to replicate.
-Armand
Subject: um, because you told it to?
you added a selective REPLICATION formula to replica2 so every time it REPLICATES it removes (or does not replicate) any document that does not match that formula.
in your example we have 5 published documents
replica1 and replica2 both contain the same documents
you change the status of a document in replica1 from published to draft
the next time replication happens it sees the change and goes to replicate the document, it checks the selective replication formula that says “i only want published documents in this database” so it removes the now draft document from replica2 instead of replicating it because it is no longer a published document.
Subject: RE: um, because you told it to?
Indeed what you are saying makes perfect sense except for like I stated in the earlier post, it is an intermittent problem and the documents are NOT always removed when their status changes.
Subject: RE: um, because you told it to?
don’t know how i missed reading that bit.
i suppose it may depend upon how often you replicate, if you are actually using the right replica to edit on (is it obvious to the user what server they are on), if when you change the field to draft, is it Draft/draft/DRAFT, ie does it perfectly match the replication formula, because i’ve never seen one of them not work.
try creating a view that has the same selection formula as the replication formula and see which documents turn up in that view on the main replica.