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.