null geometry sde, unable to delete or use replace geometry tool

[ShaneLim]

I have 8 line segments that have a geometry of null.  I am unable to delete them or replace them.  They are in a multi-version SDE environment running on MSSQL and participating in a Geometric network.  Is there anything I can do to get them to go away? The constantly give me errors and currently I am unable to create a replication for someone in a distant office.

Shane

[SepheFox]

Hi Shane, have you tried running the repair geometry tool?

[ShaneLim]

Repair Geometry is not available for SDE datasets.

[RebeccaStrauch__GISP]

I Know others have mention the repair geometry ​ArcGIS Help (10.2, 10.2.1, and 10.2.2)   and you say it's not available....just out of curiosity, have you tried?  Looks like the help says it's not needed, but at least for the 10.x version attached, I didn't see it not being available.  Still might be worth a try if you haven't.

• SDE geodatabases automatically check and repair feature geometries when the features are uploaded to the database, so using the Check Geometry and Repair Geometry tools with SDE feature classes is unnecessary.

[ShaneLim]

When you run the tool it only allows you to pick personal or file geodatabases.

[JakeSkinner]

Hi Shane,

What is the error you receive when you try to delete the features?

[ShaneLim]

Unable to delete feature with Null Geometry.

[JakeSkinner]

Do you receive the same error when you select the features and then run the 'Delete Rows' tool?

[ShaneLim]

Yes.  And when I use the replace geometry tool.

[ShaneLim · Accepted solution]

I was able to fix the problem by deleting the geometric network, dropping all the versions and then deleting the rows.