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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Find more posts tagged with

Editing

Accepted answers

George_Thompson

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.

All comments

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.

Cat_Boyes

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

Database:

Feature Class:

Problematic feature:

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

George_Thompson

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.