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.
Solved! Go to Solution.
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.
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.
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
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.