topic Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database. in Python Questions

arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons — Fri, 11 Mar 2022 16:40:00 GMT

I'm attempting to use the arcpy method DeleteIdentical_management on an ESRI geometry type sqlite database. However, no records are removed from the database upon running.

When I run delete identical in ArcPro, the identical records are deleted as expected.

Is this a known issue?

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

KoryKramer — Fri, 11 Mar 2022 18:08:07 GMT

I don't think we're aware of this issue. If you have reproducible steps and example data that demonstrate the problem, I'd highly encourage you to report it as a bug here: https://support.esri.com/en/report-bug

Thank you

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

DrewFlater — Fri, 11 Mar 2022 18:24:00 GMT

I ran a quick test, and I got the same Delete Identical result when running inside Pro using the tool UI and running using arcpy in standalone Python.exe. In both case the single duplicate in my sqlite polygon feature class was deleted.

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons — Fri, 11 Mar 2022 18:50:06 GMT

The code sample below doesn't delete any duplicates, even if I just specify the shape field. Can ArcPro be open when this runs?

EDIT: when the application is closed, the duplicates still remain after running this tool on the sqlite feature class

fields = ['SHAPE', 'CommonName', 'ObservationDate'] arcpy.DeleteIdentical_management(r'F:\portfolio_projects\database\PA_Birds1.sqlite\main.pa_birds_pnts', fields)

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

DrewFlater — Fri, 11 Mar 2022 19:02:30 GMT

I tried with a list of fields as well and it still is correctly deleting one record. Make sure your field names are matching the real field names, including SHAPE (I don't think upper vs lower case will really matter, but it's something to check)

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons — Fri, 11 Mar 2022 19:26:00 GMT

Tried doing this within the ArcPro Python window - when I run the arcpy method, the feature class in the contents shows that the tool recognizes the feature class (it greys out, locks). However, after it runs, no identical geometries are deleted.

Then, I run delete identical from the UI using only 'Shape' and all of the identical records are deleted as expected.

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

DrewFlater — Fri, 11 Mar 2022 21:00:34 GMT

"However, after it runs, no identical geometries are deleted. "

Does the tool messages say if any duplicates were deleted? It might be that some cache inside the application is not updating and the deleted records are still showing. If the messages say that duplicates were deleted, try to close and reopen Pro and see if the duplicates still show or are gone now.

Also I see in your Python window that you encountered an ERROR 999999. Can you show me what parameter settings you were using to produce that?

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons — Fri, 11 Mar 2022 21:09:25 GMT

Printed the messages for you to view below. Does seem to find the duplicates and it says they were deleted. However, after closing Pro and reopening, the number of features in the feature class is the same.

The error was randomly caused when I tried running in the python window the first time, I referenced the layer by name in the tool (as is was in the TOC) and it gave me that error.

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

DrewFlater — Fri, 11 Mar 2022 21:50:29 GMT

Thanks I could reproduce the error 999999, we will work to get that fixed. I am not sure why the tool messaging and what displays in the app are different. A developer is looking into that as well. If you use the Report A Bug system linked above by Kory you will have an issue # for tracking when the issue will be addressed.

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

MulfordnSons — Fri, 11 Mar 2022 23:11:00 GMT

using the GetCount() method returns the number of features before the delete identical as well, so it doesn't seem to actually be deleting anything in this instance.

Re: arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database.

DrewFlater — Tue, 15 Mar 2022 17:40:25 GMT

@MulfordnSons this bug has been addressed in ArcGIS Pro 3.0.