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.