My notes database has a parent child relationship. There is one parent form and two response forms. End users add/modify children documents on the replica on sr3. I have agents running on sr1 that update documents as well. No documents are updated on sr2. It is a view only database. The conflict handling property on my three forms (1 parent and 2 response) on all three replicas is set to "Merge/no conflicts."
When sr1 and sr2 replicate, there are no conflicts. When sr2 and sr3 replicate I get thousands of conflicts (mostly in the response form, some parent).
First question, I am trying to figure out why I have conflicts in the first place. Do you have any ideas?
Second question, none of my conflicts have a $ConflictAction field. Is that ok?
Check whether the agent you have running on sr1 is updating and saving many documents. Then check whether it is updating any of the same fields that the users are updating on sr3. The conflicts may even arise out of fields that aren't updated directly -– if you have computed fields that are updated when a document is refreshed or saved, then conflicts will occur even if different fields are directly modified on separate replicas.
If you can narrow down which field(s) are being updated in multiple places, you can have a better idea of how to modify the design to minimize the risk of conflicts.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Notes Domino Database Management
Related Q&A from Brad Balassaitis
Upon moving to Lotus Notes 8, some Lotus Notes users received an error message stating: 'Database has not been opened yet.' Find out why here. Continue Reading
Discover what security settings you need to fix if you encounter the Lotus Notes database error: 'database is not opened yet.' Continue Reading
Learn the Formula language code that you can use if you'd like your Lotus Notes form with embedded views to stop displaying all response documents. Continue Reading