Why does Collector say Update failed?

9757
22
08-01-2014 08:14 AM
JoshWhite
Regular Contributor III

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. 

Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
22 Replies
RussellRoberts1
Esri Frequent Contributor

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

0 Kudos
JoshWhite
Regular Contributor III

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?

Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
RussellRoberts1
Esri Frequent Contributor

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

0 Kudos
JoshWhite
Regular Contributor III

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. 

Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
RussellRoberts1
Esri Frequent Contributor

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

Thanks

Russ

0 Kudos
JoshWhite
Regular Contributor III

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

SEVEREAug 1, 2014, 3:58:54 PMA database error occurred.featureservice.MapServer

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

DEBUGAug 1, 2014, 3:58:54 PMRequestId: 17068 8/1/2014 3:58:53 PM 52a0166d-90b4-49f6-908b-2a0ab7623324 Aborted the Edit operation.featureservice.MapServer

DEBUGAug 1, 2014, 3:58:54 PMRequestId: 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.

Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
RussellRoberts1
Esri Frequent Contributor

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

0 Kudos
JoshWhite
Regular Contributor III

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

Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
SumantMallavaram
New Contributor II

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