topic Re: Problem posting updates with FeatureServer in ArcGIS REST APIs and Services Questions

Problem posting updates with FeatureServer

RichardBetts — Mon, 24 Jan 2011 13:01:09 GMT

Hello,

Im writing an feature editing application with the Flex API using FeatureServer in ArcGIS server 10. I can successfully add and delete features but am as yet unable to modify the geometry of polygon features in SDE/Oracle(10.2.0.1.0)

Heres an example of an update I'm attempting to apply with the FeatureLayer applyEdits html page in the Services Directory.

[{"geometry":{"rings":[[[202912.407817124,898446.6930849041],[215361.05189148115,898469.7675136692],[216284.0283703202,883021.4500510262],[208761.0505275416,877310.3641501195],[201758.6872185752,883944.4265298652],[202912.407817124,898446.6930849041]]],"spatialReference":{"wkid":27700}},"attributes":{"OBJECTID":1602,"ID":11}}]

And here is the error that is returned...

Underlying DBMS error [ORA-01008: not all variables bound<br/>] [TABLE_OWNER.EDIT_TABLE]
Error applying edits.

Ive tried both the applyEdits page and the updateFeatures page with the same result.
Interestingly, If I change the word "geometry" to the word "shape" in the above (the geometry column in the database is actually called SHAPE) the result claims to be successful but if I check the geometry of the feature in the database it has not infact been updated.

OBJECTID is the only not null column in the dataset. The dataset is not versioned.

I would very much appreciate any thoughts or advice.

Cheers

Richard

Re: Problem posting updates with FeatureServer

RaviNarayanan — Sun, 30 Jan 2011 21:19:41 GMT

can you try update after applying simplify on the geometry?

http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Geometry/GeometryServer/simplify?f=pjson&sr=27700&geometries={"geometryType"+%3A+"esriGeometryPolygon"%2C"geometries"+%3A+[{"rings"%3A[[[202912.407817124%2C898446.6930849041]%2C[215361.05189148115%2C898469.7675136692]%2C[216284.0283703202%2C883021.4500510262]%2C[208761.0505275416%2C877310.3641501195]%2C[201758.6872185752%2C883944.4265298652]%2C[202912.407817124%2C898446.6930849041]]]%2C"spatialReference"%3A{"wkid"%3A27700}}]}

Re: Problem posting updates with FeatureServer

RichardBetts — Fri, 04 Feb 2011 14:18:19 GMT

Thanks for your suggestion Ravi. I tried this and still could not get the edit to work.

However, I created an entirely new table on the database, registered with sde, published a new map service with feature access enabled and I am now able to edit this new layer fully (adds,updates and deletes).

Not sure what made the difference yet but I'm still looking into it.

Thanks again.