I have a GP service published that updates a series of features then publishes a pdf. Several of the feature classes have attachments, so it is necessary to open an edit session when updating them. The script works, both within Arcmap and from the GP service.
But, after using the GP service several times (typically when several users start using it), I keep getting an error in the server manager logs:
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.].
Can anyone help troubleshoot how or why this error message keeps appearing? I'm assuming that somehow two users are calling the GP service at the same time and somehow it is causing a lock situation. Or maybe someone is accessing that feature layer at the same time (there are feature services that access the same layers) Restarting the gp service and feature service appears to fix the issue, until it occurs again.
Are there any script examples or advice on how a script should handle opening closing edit sessions when other instances of the script might be doing the exact same thing?
ok, thanks anyway. I have passed on to our local ESRI distributor to follow up and see if they can find out any more info about it.
Okay, false alarm, my problem came back. I was told by ESRI that it is a bug. They have a patch for 10.4.1 and it will be fixed in 10.5.1. I upgraded to 10.4.1 and applied the patch.
Interesting, thanks for posting about that Carlos. I wasn't aware there was a patch for 10.4.1. I have emailed our local distributor to see if they can get that patch for us.
Cheers,
-Paul
ArcGIS 10.4.1 for Server Hot Fix
Hot Fix Name: QFE-1041-S-347065
Hi,
Did this patch resolve your issues?
I am having issues locating the download for the patch through the Esri site, do you have a link?
Thanks
I haven't managed to get hold of it yet, am waiting for our local distributor. Apparently it's only available as a hotfix and not a patch, so you'd have to request it especially.
Good Morming:
I am using the version 10.4 and I have the same problem:
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.].
If I restart the service, works correctly.
I would like to know if you got a solution for this problem. I would appreciate your help
Thanks
Hi Frank.
We upgraded to 10.5.1 and are not experiencing that problem anymore. Sorry I know that's not really a solution if upgrading is not an option for you, but that's where we got to.
Assuming that upgrading is not possible, have you asked your local distributor about the patch for 10.4.1? (See comments above)
cheers,
-Paul
Good Moorning Paul:
Thanks for your answering, we don't want to change the version yet, so we are going to look for the patch for this error. Please, if you know the link of this, let me know.
Thanks
We are using 10.4 and had the same problem for a specific service. After stop/start of the service the problem was solved.