topic Re: Why does the page refresh and not save table edits via "data" page? in ArcGIS Online Questions

Why does the page refresh and not save table edits via "data" page?

WillMcInnes — Tue, 06 Dec 2016 22:03:03 GMT

I have a Feature Service in AGOl with editing enabled. When I go to the "Data" page under item description and try to edit records, the page refreshes after I hit enter and erases the edit. I am an admin and able to edit other layers, but not this one. I am able to edit the records via the map, but not the data page for some reason.

Any help appreciated.

Re: Why does the page refresh and not save table edits via "data" page?

WillMcInnes — Tue, 06 Dec 2016 22:46:37 GMT

Further information:

If I look at the network log from the chrome console, I get this:

{"addResults":[],"updateResults":[{"objectId":1,"globalId":null,"success":false,"error":{"code":1000,"description":"The variable name '@ID' has already been declared. Variable names must be unique within a query batch or stored procedure."}}],"deleteResults":[]}

It seems like there is some kind of SQL error, not sure why.

Re: Why does the page refresh and not save table edits via "data" page?

Anonymous User — Fri, 09 Dec 2016 18:40:05 GMT

If it is only reproducible with one feature layer we would most likely need to do some testing with that specific feature layer. I think this is a good candidate for a Technical Support case.

Please let me know if you need assistance getting a case created.

Best,

Katie

Re: Why does the page refresh and not save table edits via "data" page?

WillMcInnes — Fri, 09 Dec 2016 19:16:51 GMT

Thanks Katie,

I did a bit more testing today, and yes it seems to have been a problem with the specific layer. It thought that a field was included twice in the table, or the query was asking for a field twice.

In the end I exported the feature service to a GDB, used that GDB in ArcMap to overwrite the FS. It is now working again.