topic Cannot delete feature with Null Shape_Area (SDE) in Data Management Questions

Cannot delete feature with Null Shape_Area (SDE)

Cat_Boyes — Tue, 20 May 2025 04:13:12 GMT

I have a feature in a featureclass that sits in an SDE. The feature has a null Shape_Area and it seems i therefore cannot delete it..

I have tried the following with no success:

ArcPro - Delete in attribute table as per a normal feature
ArcPro - Geoprocessing Tool 'Delete Features' - ArcPro literally crashes!
ArcPro - Replace Geometry Geoprocessing Tool
FME to filter out the individual record and delete via a writer (FME fails as soon as it hits this record, and provides this standard error 'ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Error performing query operation'. Details: '')

Does anyone know how I could delete this feature? Ideally using FME or ArcPro. It's causing problems in some of our other processes so we need to find a way to do it.

Re: Cannot delete feature with Null Shape_Area (SDE)

George_Thompson — Tue, 20 May 2025 10:29:40 GMT

If the feature class is being used in a service, I would stop that service and try to delete.

Is the data versioned?

If not, you could try to copy out all the good records, then truncate the table (should drop all records). Make sure you have a backup of the data before truncate. This would be the last option I would use.

Re: Cannot delete feature with Null Shape_Area (SDE)

VinceAngelo — Tue, 20 May 2025 12:10:04 GMT

Feature classes haven't been "in an SDE" since SDE 3.0 was released. The current term of art is "enterprise geodatabase in {name of RDBMS}". Please provide the RDBMS name (and version), and the CREATE TABLE statement for the feature class in question. Generally, Shape_AREA is a computed column that doesn't even exist in the database, and therefore can't be defined NOT NULL.

- V

Re: Cannot delete feature with Null Shape_Area (SDE)

Cat_Boyes — Tue, 20 May 2025 22:33:37 GMT

Hi, not sure if this is helpful but here's some more info:

Database:

Feature Class:

Problematic feature:

Re: Cannot delete feature with Null Shape_Area (SDE)

Cat_Boyes — Tue, 20 May 2025 22:40:41 GMT

Legend!

I stopped the four services that used this Feature Class and I could delete in the attribute table successfully.

Thanks so much.