topic Re: Why are there duplicate records in the database? in ArcGIS Collector Questions https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68712#M1357 <HTML><HEAD></HEAD><BODY><P>After more testing with Collector, I found that what I thought were duplicate records (based on OBJECTID) were actually the additional <STRONG>archived</STRONG> records as we have archiving enabled on this data. I'm so used to the OBJECTID being a unique primary key, this threw me off!</P></BODY></HTML> Fri, 13 Feb 2015 15:41:58 GMT VenusScott 2015-02-13T15:41:58Z Why are there duplicate records in the database? https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68710#M1355 <HTML><HEAD></HEAD><BODY><P>I added a couple of records using Collector then went back into one and updated the data a couple of times. In the Oracle database it shows a record multiple times? Is what I'm seeing the "xxx_H" records? Does a compress resolve the duplicate records? Just trying to understand from a database perspective of what I should be seeing when Collector updates records.</P><P></P><P><IMG alt="DupRecs.jpg" class="jive-image image-1" src="https://community.esri.com/legacyfs/online/61254_DupRecs.jpg" style="width: 620px; height: 132px;" /></P></BODY></HTML> Thu, 12 Feb 2015 21:13:19 GMT https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68710#M1355 VenusScott 2015-02-12T21:13:19Z Re: Why are there duplicate records in the database? https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68711#M1356 <HTML><HEAD></HEAD><BODY><P>Are you accessing the base table or the versioned view? The versioned view will give you the best window into the data.</P></BODY></HTML> Thu, 12 Feb 2015 21:57:17 GMT https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68711#M1356 AlexMahrou 2015-02-12T21:57:17Z Re: Why are there duplicate records in the database? https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68712#M1357 <HTML><HEAD></HEAD><BODY><P>After more testing with Collector, I found that what I thought were duplicate records (based on OBJECTID) were actually the additional <STRONG>archived</STRONG> records as we have archiving enabled on this data. I'm so used to the OBJECTID being a unique primary key, this threw me off!</P></BODY></HTML> Fri, 13 Feb 2015 15:41:58 GMT https://community.esri.com/t5/arcgis-collector-questions/why-are-there-duplicate-records-in-the-database/m-p/68712#M1357 VenusScott 2015-02-13T15:41:58Z