Cannot delete feature with Null Shape_Area (SDE)

[Cat_Boyes]

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.

[George_Thompson · Accepted solution]

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.

[Cat_Boyes]

Legend!

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

Thanks so much.

[VinceAngelo]

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

[Cat_Boyes]

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

Database:

Feature Class:

Problematic feature: