topic Re: Why does Collector say Update failed? in ArcGIS Collector Questions

Why does Collector say Update failed?

JoshWhite — Fri, 01 Aug 2014 15:14:13 GMT

When I was testing Collector I made a test feature but got a message that the update failed-updates could not be sent and I can cancel or retry. Cancel abandons the feature and retry returns the same result.

Re: Why does Collector say Update failed?

RussRoberts — Fri, 01 Aug 2014 16:57:27 GMT

Are you using hosted or your on-premise server?

Are you able to collect in AGOL?

If you try in AGOL - collect a feature and refresh your browser page and see if the feature still exists or see if it made it back into your SDE. This will help us determine where the issue is.

Thanks

Russ

Re: Why does Collector say Update failed?

JoshWhite — Fri, 01 Aug 2014 18:14:12 GMT

I am using an on-premise server.

It doesn't appear I am able to add features in AGOL either. It says click to add a point and then nothing happens. I have several feature layers present in this particular map and none of them appear to work, actually one works for some reason but the rest don't. I have done some schema changes, would that cause the issue? If so, how can I fix this issue?

Re: Why does Collector say Update failed?

RussRoberts — Fri, 01 Aug 2014 18:18:45 GMT

I don't think that would cause the issue. If you can enable debug logging on your server or look at the network requests when you try to add you might be able to determine the issue.

Russ

Re: Why does Collector say Update failed?

JoshWhite — Fri, 01 Aug 2014 18:36:10 GMT

The log repeatedly says a database error has occurred after I attempt to add a feature, nothing more. The source is featureservice.mapserver. The service featureservice appears to be running. Yes I know simple name but the idea was this was a test service. Fiddler doesn't return anything on a click. Also interesting is that I apparently can edit existing points in AGOL. However, even edits will not post from Collector. Again, I am able to edit one of my features without issue in Collector and in AGOL.

Re: Why does Collector say Update failed?

RussRoberts — Fri, 01 Aug 2014 20:44:24 GMT

Did you have the debug logging enabled from the servername/arcgis/admin ?

Thanks

Russ

Re: Why does Collector say Update failed?

JoshWhite — Fri, 01 Aug 2014 21:06:13 GMT

Oh, I missed the Debug part. I will try and get some of the info:

SEVERE

Aug 1, 2014, 3:58:54 PM

A database error occurred.

featureservice.MapServer

DEBUG

Aug 1, 2014, 3:58:54 PM

RequestId: 17068 8/1/2014 3:58:53 PM 52a0166d-90b4-49f6-908b-2a0ab7623324 Performed StopEditing (without save).

featureservice.MapServer

DEBUG

Aug 1, 2014, 3:58:54 PM

RequestId: 17068 8/1/2014 3:58:53 PM 52a0166d-90b4-49f6-908b-2a0ab7623324 Aborted the Edit operation.

featureservice.MapServer

DEBUG

Aug 1, 2014, 3:58:54 PM

RequestId: 17068 8/1/2014 3:58:53 PM 52a0166d-90b4-49f6-908b-2a0ab7623324 Error while Performing Edits for GraphicFeatureServer.ApplyEdits.

featureservice.MapServer

These are a few of the entries that resulted. Error while Performing Edits for GraphicFeatureServer.ApplyEdits seems to be the culprit but I have no idea what this means.

Re: Why does Collector say Update failed?

RussRoberts — Fri, 01 Aug 2014 22:12:03 GMT

Thanks for the info Josh. One more thing if you could try and collect/edit those layers in ArcMap would be great if the edits can be saved after an edit session.

Thanks

Russ

Re: Why does Collector say Update failed?

JoshWhite — Mon, 04 Aug 2014 13:18:32 GMT

Yes I edit most of those layers on a regular basis in ArcMap

Re: Why does Collector say Update failed?

SumantMallavaram — Mon, 18 Aug 2014 22:31:51 GMT

I wanted to chime in with a similar problem using the same workflow but with an error that is a little more specific:

Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]There are no rows in the current fetch buffer.] [GDBName.DBO.LayerName].

I first got this message in one geodatabase. I then moved it to a brand new GDB. It worked fine for two days and now the same error is coming back up again. This is my first app using the 10.2.2 offline mode and as such I don't have any comparison points with other apps.

Any ideas on whether this is related to my specific database/datasets or could this be a bug.

Thanks

Re: Why does Collector say Update failed?

AntonioRodrigues_Martins_Junio — Tue, 14 Oct 2014 20:14:30 GMT

I'm facing the same problem here.

Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]There are no rows in the current fetch buffer

Using arcgis 10.2.2 and working with offline data. When I try to edit features using ArcMap(same dataset as I use in offline mode), works for a while, then appear the error reported above.

Quite similar with Sumant Mallavaram problem.

Re: Why does Collector say Update failed?

SethHays — Tue, 02 Dec 2014 15:37:50 GMT

Hi Antonio,

Were you ever able to resolve this problem. We are getting that exact error here.

Thanks

Re: Why does Collector say Update failed?

DaveCross — Fri, 27 Feb 2015 18:40:43 GMT

I have encountered the same problem with an on-premesis 10.22 ArcGIS Server and a SQL-Server backed GDB. In my case the symptom was that the ApplyEdits REST API call failed.

The Error from ArcGIS Server is:

Unable to complete operation.

Unable to perform applyEdits operation.

And the detail in the logs is:

Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]There are no rows in the current fetch buffer.]

I cannot yet explain how the server got into this state, but perhaps my resolution will help you. To resolve the issue we did the following:

Stop all services connecting to the offending database.
Restart the DB instance with the commands below
Restart the services again

ALTER DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE
go
ALTER DATABASE MyDatabase SET ONLINE
go

Once the services came back online the REST API was able to update features once again.

Re: Why does Collector say Update failed?

RyanNosek2 — Mon, 15 Jun 2015 23:47:42 GMT

Thank you for your post Dave - I can verify having the same issue as the Original post and the same Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]There are no rows in the current fetch buffer.]. Your solution fixed our problem. Now if we could only figure out why it happened in the first place?

Can any one else verify if Dave's solution worked for them as well?

Re: Why does Collector say Update failed?

PeterMcRostie — Wed, 29 Jul 2015 04:21:22 GMT

Has this solution worked for anyone? I am getting the same error in 10.3.1

Re: Why does Collector say Update failed?

nev — Fri, 31 Jul 2015 00:38:50 GMT

I believe the underlying cause of "There are no rows in the current fetch buffer" error is archiving. I was getting this error a lot and had to disable archiving to stop it. Luckily i was just trialing offline and dont have a major need for it at the moment.

Would be interested to see if that fix works, not sure how taking the DB off line then back would be a long term fix though?

Re: Why does Collector say Update failed?

JoshWhite — Fri, 31 Jul 2015 13:36:25 GMT

Just an update, we are still testing out and haven't officially taken the plunge yet (yep a year later) but to the best of my knowledge this error is no longer happening and to be completely honest, I have no idea what we did to fix it anymore or if a bug fix was patched on. I have always been in online mode, so archiving wasn't my issue and I never saw the error mentioned above.

Re: Why does Collector say Update failed?

TracieStreltzer — Thu, 07 Jan 2016 13:11:28 GMT

I was also getting reports of the download stalling. Compressing the database with all connections closed, then taking it offline and back online again resolved it for me. Editing through ArcMap online was never affected, it was only the REST interface that was an issue.

Re: Why does Collector say Update failed?

ToddHenry1 — Thu, 07 Jan 2016 17:01:01 GMT

Seth / Sumant / Antonio,

We are getting the same error when editing in ArcMap or ArcGIS Online to a SQL server database. Did you find any long term resolution besides restarting the SQL server?

ESRI support pointed us to this knowledge base http://support.esri.com/en/knowledgebase/techarticles/detail/43036, but enabled CLR is likely not an option because we are using a shared database instance.

Re: Why does Collector say Update failed?

PeterMcRostie — Mon, 29 Feb 2016 23:11:34 GMT

The temporary fix of stopping all services and taking the SQL database offline and putting back online works but the big question is why do I have to do this every other week??

The archive enabled data which is being used offline seems to be source of the issue...

Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]There are no rows in the current fetch buffer.] [GIS_EDIT.DBO.tmpRubbishRemoval].