topic Re: Error 000224 when running Delete Identical on SDE enterprise database in Python Questions

Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Sat, 03 Feb 2024 23:54:28 GMT

I am attempting to run Delete Identical on a feature hosted on an enterprise geodatabase and keep receiving the Error 000224: Cannot insert features. This occurs when running from a standalone Python script and running the tool directly in ArcGIS Pro. I have tried both a user with appropriate permissions and the geodata owner. If I export the data to a local GDB everything runs great.

Error 000224 is typically related to mismatched field definitions between incoming features and the output feature class. But this tool modifies the existing feature class, so they should be the same.

This is similar to the issue reported by @MulfordnSons in arcpy.DeleteIdentical_management does not delete identicals in ESRI sqlite database. However, this was to have been resolved in ArGIS Pro 3.0. Currently running ArcGIS Pro 3.2.1, the database is hosted on an MS SQL Server as an 11.2 version enterprise database.

Any ideas?

I did submit a support ticket, but it will be Monday or Tuesday before they get back to me.

Re: Error 000224 when running Delete Identical on SDE enterprise database

JonathanPollack — Mon, 12 Feb 2024 14:48:08 GMT

I am running into the same issue, did you ever get this resolved?

Re: Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Mon, 12 Feb 2024 15:04:23 GMT

I am still working with ESRI support to narrow down the issue. They were able to replicate the problem and are leaning towards a bug.

Re: Error 000224 when running Delete Identical on SDE enterprise database

JonathanPollack — Mon, 12 Feb 2024 15:09:45 GMT

Thanks, we just recently updated to 11.2 and performance/stability has greatly improved but this is a bummer.

In the meantime I am using an update cursor to perform the same function.

Re: Error 000224 when running Delete Identical on SDE enterprise database

KG_427 — Tue, 27 Feb 2024 14:41:09 GMT

Did support ever identify a bug? I am also running into this issue. It works from a file geodatabase as expected in Pro. We are on 10.9 still so I tried the enterprise GDB in ArcMap and it worked fine, but i would prefer using this tool in Pro.

Re: Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Tue, 27 Feb 2024 14:50:00 GMT

I am still working with support on this issue. We have another session scheduled for tomorrow to capture some SQL logs. They have been able to replicate the issue.

Re: Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Wed, 28 Feb 2024 17:28:31 GMT

Out of curiosity, if you are experiencing the same issue, what enterprise database platform are we using? I am experiencing this on MS SQL.

Re: Error 000224 when running Delete Identical on SDE enterprise database

JessieBrain — Mon, 18 Mar 2024 20:28:59 GMT

I'm having the same issue. Was there any resolution here?

Re: Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Thu, 11 Apr 2024 16:53:52 GMT

After working with ESRI support, this was confirmed as a Bug. BUG-000166278

Re: Error 000224 when running Delete Identical on SDE enterprise database

BrandenHarding — Thu, 11 Apr 2024 14:41:27 GMT

Lance - your link takes me to My Esri but the bug does not show up? Has ESRI provided a timeline for a fix? The same is happening to me now on ArcPro 3.2.2.

Alternatively, does anyone know of a version between 3.1 and 3.2.2 where this bug doesn't happen? We need the upsert ability that comes with ver 3.1 but also need this delete ident toolset to work....

Re: Error 000224 when running Delete Identical on SDE enterprise database

LanceCole — Thu, 11 Apr 2024 17:00:19 GMT

@BrandenHarding,

I updated the BUG-000166278 link above to the correct public format. It is still showing as under consideration. As the bug has not yet been prioritized, I would recommend reporting your issue through ESRI support.

Re: Error 000224 when running Delete Identical on SDE enterprise database

ArizonaGIS — Fri, 12 Apr 2024 02:37:34 GMT

The inability to use this feature is a significant limitation to our workflow. Esri's suggested workaround of exporting data to a file geodatabase, running delete identical, and importing it back into an enterprise geodatabase is unacceptable.

Re: Error 000224 when running Delete Identical on SDE enterprise database

esteele — Mon, 15 Apr 2024 14:17:57 GMT

Also running into this issue! Not acceptable. This needs to be prioritized and escalated so that a fix is released in the next patch.

Re: Error 000224 when running Delete Identical on SDE enterprise database

Sfortunatamente — Mon, 20 May 2024 16:30:58 GMT

How about "Find Identical"? The result is a table with OBJECTIDs of duplicates. I am going to join that table to my original feature class with the option to get only matching records and delete these (duplicates). It is not ideal but may work. PostgreSQL 12 + PostGIS here.

Re: Error 000224 when running Delete Identical on SDE enterprise database

ChristalHigdon_USFS — Tue, 15 Oct 2024 22:18:00 GMT

I am getting the same error, Postgres SDE database. I would like to echo this bug should be fixed!