topic Re: null geometry sde, unable to delete or use replace geometry tool in Data Management Questions

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

ShaneLim — Thu, 11 Jun 2015 20:46:20 GMT

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

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

SepheFox — Fri, 12 Jun 2015 00:35:51 GMT

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

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

JakeSkinner — Fri, 12 Jun 2015 11:24:07 GMT

Hi Shane,

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

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

ShaneLim — Fri, 12 Jun 2015 14:17:33 GMT

Repair Geometry is not available for SDE datasets.

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

ShaneLim — Fri, 12 Jun 2015 14:18:01 GMT

Unable to delete feature with Null Geometry.

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

JakeSkinner — Fri, 12 Jun 2015 14:23:04 GMT

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

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

ShaneLim — Fri, 12 Jun 2015 14:38:59 GMT

Yes. And when I use the replace geometry tool.

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

RebeccaStrauch__GISP — Mon, 15 Jun 2015 01:23:17 GMT

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.

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

ShaneLim — Wed, 17 Jun 2015 21:09:50 GMT

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

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

ShaneLim — Wed, 17 Jun 2015 21:13:07 GMT

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