topic Re: ArcGIS Server Open Transaction Errors in ArcGIS Enterprise Questions

ArcGIS Server Open Transaction Errors

GeorgeOulton1 — Wed, 15 Jul 2015 16:19:46 GMT

Hello All!

We have ArcGIS Server 10.3 running with a postgresql 9.1 database. The features are non-versioned. We use collector for field data collection and users sync in the evening. Sometimes the sync fails and ArcGIS Server reports an error like so:

Error: The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.].

during the method "GraphicFeatureServer::Update"

This error also happens from time to time while editing features within the ArcGIS Online web map and web app.

Any insight on this type of error would be helpful.

Thanks!

Re: ArcGIS Server Open Transaction Errors

ScottKearney — Fri, 11 Mar 2016 15:22:41 GMT

I'm having the same error in Collector with a SQL Server 2012 AGS 10.1 geodatabase non-versioned feature class published as an AGS 10.3 feature service:

Message:

Error: The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.].

Code:

17000

Method Name:

GraphicFeatureServer.HandleREST_DeleteFeaturesOperation

Any ideas on cause?

Re: ArcGIS Server Open Transaction Errors

ThomasSpindler1 — Wed, 11 May 2016 19:05:04 GMT

I was just trying to figure this out myself:

Error: The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.].

In the map service properties, under the Pooling tab, set "Maximum number of instances per machine" to 1.

After hitting OK, this error should be a non-issue.

Re: ArcGIS Server Open Transaction Errors

PeterGranberg — Wed, 15 Jun 2016 08:54:24 GMT

So, this error is related to diffrent SOC-processes trying to edit at the same time? Will it still be a good solution if you set max 1 instance, but you configure the service to low-isolation, therby utilizing 1 SOC, but say 3 instances per process?

My scenario is 2-3 concurrent field workers, online-editing. Is Registered as Versioned a better confuguration for this?

Re: ArcGIS Server Open Transaction Errors

jonathanrobinson — Wed, 14 Jun 2017 23:53:03 GMT

Hello, did you find out a fix for this issue?

Re: ArcGIS Server Open Transaction Errors

ScottKearney — Wed, 21 Jun 2017 20:09:16 GMT

I resolved the problem by isolating all of the feature classes used by the feature services to a separate geodatabase.