Domino & Enterprise Integrator 12.0.1. I have a Replication Activity that has been running without issue since August 2021, on a schedule every 15 minutes. The Source connection is ODBC SQL Server table. Any records that meet certain conditions in the Source (SQL table) are to be replicated/inserted into Notes application. Worked like a charm forever until it recently & suddenly populated my Notes app with thousands of new records (typically gets 1-2). Then normal behavior would resume for days, until the issue suddenly returned. So now I run the Activity manually, and will get 30-50 successful (accurate) runs, followed by a run that will duplicate many records. This pattern has been occurring regularly over the past few months, ever since it first occurred. The Target restriction Skip Updates and Skip Deletions, as I'm only looking to Insert new record from SQL that the Notes app does not have.
Upon closer inspection, it seems as though the record Inserted are being replicated from the Notes app itself. Some of document variables have values that are assigned only by Notes, not the Source SQL Table.
I've tried indexing, re-creating the index, using new (LEIIndexView) Selected View in Notes Connection doc. Everything works fine 95% of the time, but will suddenly replicate records that already exist in Notes. Activity immediately before & after will work just fine. Any ideas?
