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!
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?
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.
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?
Hello, did you find out a fix for this issue?
I resolved the problem by isolating all of the feature classes used by the feature services to a separate geodatabase.