I am running into an issue where I am seeing duplicates in an archiving-enabled geodatabase. What we are seeing is for a given OBJECTID, there will be multiple records with GDB_TO_DATE = 9999-12-31 23:59:59.0000000
In the above screenshot, for OBJECTID 9038247, there are 3 records with GDB_TO_DATE = 9999-12-31 23:59:59.0000000. This means that we are seeing 3 copies of this OBJECTID when we query any feature service or view that is derived from this table. Normally, there should only be one record with GDB_TO_DATE = 9999-12-31 23:59:59.0000000.
We are unsure what causes these duplicates. Any ideas on what could be causing this? We are on ArcGIS Server 10.5.1.