topic Re: Insert (add) fails in ArcGIS JavaScript Maps SDK Questions

Insert (add) fails

WarrenMedernach — Wed, 25 May 2011 21:56:52 GMT

Hello all,
I have some simple point data in an ArcSDE geodatabase, I have published the data to ArcGIS Server, and I'm getting my feet wet with the JavaScript API.

Using the samples provided, and substituting my FeatureServers, I can get updates and deletes to work fine, but adds (inserts) do not work.

The response to the applyEdits on an insert is:

{"addResults":[{"objectId":-1,"globalId" : null,"success":false,"error":{"code":-2147216100,"description":"Error while inserting populated row into Insert Cursor"}}],"updateResults":[],"deleteResults":[]}

Any suggestions would be greatly appreciated.

Warren M

Re: Insert (add) fails

derekswingley1 — Wed, 25 May 2011 23:17:27 GMT

I think that error normally corresponds to permissions issues...which is strange since you can update and delete without issue. Can you double-check that you have full permissions granted on your feature class?

Re: Insert (add) fails

WarrenMedernach — Thu, 26 May 2011 03:06:38 GMT

Hi Derek,

That's what I suspected as well, but the ArcGISSOC user has db_datareader and db_datawriter permissions and db_datawriter is supposed to have DELETE, INSERT and UPDATE permissions?

But alas, this seems to not be the case, at least as far as ArcGIS Server is concerned... If I give the AcrGISSOC user db_owner permission, the inserts work fine.

So... that confirms it is a permission issue, but now I need to figure out how to do this without giving db_owner permissions...

Thanks for your help.

Warren M

Re: Insert (add) fails

derekswingley1 — Thu, 26 May 2011 03:20:44 GMT

Assigning permissions via roles might be a bit of overkill in this situation...what about assigning permissions directly on the feature class?

Re: Insert (add) fails

AndyStewart1 — Fri, 20 Jul 2012 17:19:05 GMT

I am getting the same error but it doesn't happen every time. It also only happens when I am saving a drawn polygon and not a point or line. I can't find a consistent action that triggers it either. Could this still be a permissions thing?