I administer a large database with 100+ forms. The environment has two clustered databases, one of which acts as the centre of around 20 databases which have a subset of documents controlled by replication formula. The issue is that when I create a document of a specific form, (form: stockTransfer) it appears new instances are not recognised by the other clustered server. What is actually happening is that the stockTransfer is turning up on the other server then is immediately removed by the replicator task. I have seen this in the log. Immediately after I create a transfer on Server A there is an entry in the log for Server B(replicator has deleted 1 document). I have checked the replication formula and there is only one form mentioned and its not this one. Also both clustered databases were running with no formula set and this error still occurred. Both servers have been restarted and coincidently both databases have just been upgraded from notes 5 to 8.5. This was done by creating two new replicas at 8.5 and replacing the existing notes 5 replicas. This issue was occurring before the databases were replaced and is still happening.
Subject: rep formula
I’d be willing to bet that if you remove your replication formula your problem will go away. I never had much luck with them and they were more trouble than they are worth. I prefer using Reader fields to control what the servers can “see”.
Subject: rep formula
This issue was occurring before we upgraded the ODS versions of our two main databases. Our two main databases hold all of the data for the set up, with around 20 other databases only holding their own data. They know who they are because each has a document telling it who it is. All other documents are mentioned in the replication formulas so that the correct documents go to the correct database. However the two main databases get all documents except the documents that tell the other databases who they are. Inadvertently during upgrade the replication formula was removed from both main servers and they had no formula set. This issue still occurred.
Subject: solution
the two main servers should have all roles in the ACL I created a role to allow viewing of all transfers but omitted giving it to the two main servers. The upshot of this was the server that it was created on had access to it by default but the other didn’t.