topic Re: Update feature class MS SQL Server in Data Management Questions

Update feature class MS SQL Server

JordanParfitt — Fri, 16 Oct 2015 21:46:16 GMT

I tried updated the geometry in my Feature Class using geometry:STPointFromText and it looked as though it worked but then the MXD wouldn't publish. I fixed it by exporting to a FGDB then re importing.

Are you allowed to at least edit the tabular data in SQL Server Management Studio (text, int, guid, etc)? Or are you required to do everything through ArcMap? I just don't want this to happen again.

Re: Update feature class MS SQL Server

ThomasColson — Fri, 16 Oct 2015 23:30:09 GMT

that "Should" have worked. Can you give more details, what version of ArcSDE, SQL, is the FC using Esri Binary, Geog, or Geom Storage? What is the SRID? Where there any null or outside of scope values? If using Geog/WGS84, you have have created an outside-of-sphere error, which would result in the error you describe. See Repetitive Attribute Values Automated with SQL for an example of how STPointFromText can be automated.

Re: Update feature class MS SQL Server

JordanParfitt — Mon, 19 Oct 2015 14:03:01 GMT

SDE 10.3

SQL Server 2012 R2

My SQL was:

update USERASSIGNMENT set shape = geometry::STPointFromText('POINT (26037125.623245418 652287.62337251008)', 102688) where OBJECTID > 0

The one thing I should have mentioned but didnt was that it published fine unless I wanted to sync enable it. So I enabled archiving, then publish as a feature layer with sync enabled. Then it failed with a generic error but the logs said something like "unable to publish because the feature layer isn't sync enabled."

Thanks

Re: Update feature class MS SQL Server

VinceAngelo — Mon, 19 Oct 2015 14:49:23 GMT

Did you really want to clobber all geometries in the table to have a single coordinate value? Is the data really accurate to sub-Angstrom precision? It would help if you provide a clear description of your procedure, including exact commands and exact error messages.

- V

Re: Update feature class MS SQL Server

JordanParfitt — Mon, 19 Oct 2015 16:35:37 GMT

The exact errror message from the logs was:

Layer(s) or table(s) are not configured for Sync.

I did want everything to have the same geometry. I just needed every feature to be contained within the state of Michigan, the exact location doesn't matter. The dot showed up in my MXD just fine, I just had to export then reimport multiple tables in order to get them to publish.

Thanks Guys!

Re: Update feature class MS SQL Server

JasonTipton — Mon, 19 Oct 2015 19:10:34 GMT

Have you added Global IDs?

Prepare data for offline use—Documentation (10.3 and 10.3.1) | ArcGIS for Server

Re: Update feature class MS SQL Server

JordanParfitt — Mon, 19 Oct 2015 19:12:21 GMT

Yep

I fixed the problem just wanted to know if it was a known issue. If it's not its probably something obscure I did.