topic Re: GP service error: "The current version does not support editing..." in ArcGIS Enterprise Questions

GP service error: "The current version does not support editing..."

Anonymous User — Thu, 27 Oct 2016 01:49:23 GMT

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?

Re: GP service error: "The current version does not support editing..."

BasWest1 — Thu, 17 Nov 2016 08:33:19 GMT

Hi Paul, dit you already resolve this issue? We have similar problems.

Re: GP service error: "The current version does not support editing..."

Anonymous User — Thu, 17 Nov 2016 21:01:28 GMT

Hi Bas

No, not resolved yet. Getting very frustrating for us!

To try to rectify it, I even went through the scripts and replaced the use of arcpy insert and update cursors with using arcrest to call the rest api. The theory there was that somehow the insert/update cursors, which *did* regularly open and close edit sessions, were somehow not closing one properly (even though I couldn't see how that could happen), and that using pure rest api calls for any edits would allow arcgis server to manage those concurrent edits. But I've still had the same error occur. It even happened late last night, at a time when I was testing the arcrest scripts and knew 99.9% that I was the only one using the system, so I knew there was no other edit sessions open (e.g. in arcmap etc).

I'm using ags 10.4.1 on aws with a SQL server enterprise geodatabase.

Can you share a bit about your setup and workflow to see if any similarities perhaps?

cheers,

-Paul

Re: GP service error: "The current version does not support editing..."

BasWest1 — Fri, 18 Nov 2016 08:53:43 GMT

We are on ArcGIS for server 10.3 with an Oracle enterprise geodatabase.

We also have this problem with a featureclass with attachments (and another related table). These are exclusively being edited by rest calls (through the Javascript API). Sometimes there is no problem for days, and then it occurs again. Last time when this problem occured our DBA could confirm that the the open transaction was in the attachment table and that the database was waiting for the client Arcsoc to send some kind of signal to close the transaction, but was not receiving any (as far as I understood).

So I guess the problem seems to be caused by something related to the adding of attachments through the REST API.

Re: GP service error: "The current version does not support editing..."

Anonymous User — Fri, 18 Nov 2016 13:33:38 GMT

Hi Paul,

Try to increase
The maximum time a client can use a service: as per transaction compilation time as average one.
You can also need to configure number if instance for GP services.
Some settings are not optimise.

Re: GP service error: "The current version does not support editing..."

Anonymous User — Sun, 20 Nov 2016 19:32:31 GMT

Interesting. No clear similarities between your situation and ours then. i.e. 10.3 vs 10.4.1, Oracle vs. Sql Server, and I've had it happen to feature classes that didn't have attachments enabled. And, initially, I was using arcpy insert and update cursors (e.g. NOT the rest api) whereas you are exclusively using rest calls.

I'm still a bit stumped I'm afraid....

Re: GP service error: "The current version does not support editing..."

Anonymous User — Sun, 20 Nov 2016 19:36:42 GMT

Hi Avinash.

Thanks for the reply.

The default 'maximum time a client can use a service' is 600 seconds, or 10 minutes, which should be plenty of time to execute the GP tasks I have in place. Typically they complete in around 15-20 seconds.

The number of instances is set just to min 1 max 2, but a) I've seen the problem occur when I'm the only one using the service so it wasn't under huge load and b) I thought the idea was that in the services were maxed out then a new request would either wait or timeout. i.e. it shouldn't cause a lock scenario such as it is.

Would appreciate any further discussion or insights into how it works.

Cheers,

-Paul

Re: GP service error: "The current version does not support editing..."

CarlosKrefft — Wed, 15 Mar 2017 20:48:00 GMT

I contacted ESRI premium support about this. They said they knew of it, it's a bug and has been fixed in 10.5.1:
BUG-000100553: Receiving "An open transaction was detected. All user transactions must be closed prior to StartEditing" error in the ArcGIS Server logs when applying online edits with a non-versioned feature service

What I don't understand is this was working fine before and all of a sudden stopped. There must be a work around to resolve this like republishing the service, re-installing server, something because it's not an issue out of the box.

Re: GP service error: "The current version does not support editing..."

Anonymous User — Wed, 15 Mar 2017 21:04:25 GMT

Hi Carlos

Thanks for your comment, that's interesting to hear. Can you post a link to the bug report? I can't seem to find any reference to 'BUG-000100553' when searching on the ESRI support site, and am not sure if I'm looking in the right place.

I have raised this with our local ESRI distributor previously but they haven't mentioned this so probably not aware of it and it would be good to be able to pass the info on to them.

Thanks.

Re: GP service error: "The current version does not support editing..."

CarlosKrefft — Wed, 15 Mar 2017 21:55:51 GMT

I don't have a link. They just gave me that bug information and description.

I did seem to have resolved my problem. I simply republished my service and all is okay now. I can add the attachments and I no more of those errors are logged.

Good Luck!

Re: GP service error: "The current version does not support editing..."

Anonymous User — Wed, 15 Mar 2017 23:02:19 GMT

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.

Re: GP service error: "The current version does not support editing..."

CarlosKrefft — Tue, 23 May 2017 21:49:37 GMT

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.

Re: GP service error: "The current version does not support editing..."

Anonymous User — Tue, 23 May 2017 22:10:45 GMT

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

Re: GP service error: "The current version does not support editing..."

CarlosKrefft — Tue, 23 May 2017 22:13:40 GMT

ArcGIS 10.4.1 for Server Hot Fix
Hot Fix Name: QFE-1041-S-347065

Re: GP service error: "The current version does not support editing..."

BevanDarr — Wed, 31 May 2017 23:48:34 GMT

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

Re: GP service error: "The current version does not support editing..."

Anonymous User — Thu, 01 Jun 2017 02:33:43 GMT

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.

Re: GP service error: "The current version does not support editing..."

FrankCastro — Wed, 06 Jun 2018 16:24:36 GMT

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

Re: GP service error: "The current version does not support editing..."

Anonymous User — Thu, 07 Jun 2018 04:35:43 GMT

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

Re: GP service error: "The current version does not support editing..."

FrankCastro — Thu, 07 Jun 2018 15:06:30 GMT

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

Re: GP service error: "The current version does not support editing..."

philippeleempoels — Wed, 30 Oct 2019 16:55:38 GMT

We are using 10.4 and had the same problem for a specific service. After stop/start of the service the problem was solved.