AnsweredAssumed Answered

How do I fix the SHAPE.STArea/SHAPE.STLength issue?

Question asked by bokeefe on May 2, 2017
Latest reply on May 2, 2017 by bokeefe

I'm trying to adopt the ArcGIS Addressing Assistant and running into issues.

 

I have the MXD downloaded. The ArcGIS Attribute Assistant and the ArcGIS Addressing Assistant are installed as well. However, my MXD is failing to draw layers constantly because of :

 

Editing Basemap:  9K:  FacilitySites_9K:  Attribute column not found [42S22:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SHAPE_Area'.] [LocalGovernment2.SDE.FacilitySite]

 

So, at first, I was able to move through most of the layers and adjust the definition query or the label expression or the SQL expression for that layers labels. But then I hit the layer from the error message above, Facility Sites.

 

Nothing I do will get that layer to go. I've even tried unchecking it from the Table of Contents and it still throws an error.

 

I've found this referenced in another thread: SHAPE.STArea()field in SQL 2008 

 

Apparently it's part of a known bug that ESRI doesn't think is a priority.

 

If ESRI would like the City of Tulsa to adopt their Addressing solutions? It really should be bumped up a little? A solution is necessary or I have to give up on this process. We are trying to move to get our entire addressing data moved into the LGM, but this... this is a HUGE setback when every layer is messed up like this.

 

Any help would be greatly appreciated.

Outcomes