topic Re: Generate Attachment Match Table - duplicate records generated in Geoprocessing Questions

Generate Attachment Match Table - duplicate records generated

TamiOnstad — Wed, 10 May 2017 21:18:57 GMT

I have noticed recently that when I run Generate Attachment Match Table from ArcCatalog, I am getting more records than I expect. For example, I have 5660 image files in my directory and all have a match back to my feature class. I would expect the same number of records to appear in the output Match table. However, I end up with about 5699. I was puzzled by this until I started looking at the Match table more closely. It looks like it is randomly creating duplicates of some of the match records.

The only way to quickly fix this is to convert the match table to Excel, remove the duplicates, and export back out to a table again. I can then use the new table without dups to add attachments to the feature class.

Is this a bug? I could not find anyone else who seemed to be having the same issue.

Any ideas?

Tami

Re: Generate Attachment Match Table - duplicate records generated

DanPatterson_Retired — Wed, 10 May 2017 22:12:18 GMT

http://support.esri.com/bugs/nimbus/TklNMDg2OTI4 an old one, if you are using 10.1... no resolution in any event

Re: Generate Attachment Match Table - duplicate records generated

TamiOnstad — Wed, 10 May 2017 22:17:05 GMT

We are on 10.2.1, so it appears it has still not been fixed.

Thanks for the update!

Tami

Re: Generate Attachment Match Table - duplicate records generated

KevinMacLeodCAI — Wed, 09 Jun 2021 13:32:03 GMT

FYI all - This bug is still in ArcGIS in 2021 in 10.7.1

It can be solved with the Delete Identical GP tool.