topic Re: RuntimeError: workspace already in transaction mode?! Help, pls! in Python Questions

RuntimeError: workspace already in transaction mode?! Help, pls!

Anonymous User — Sun, 12 Dec 2021 01:59:10 GMT

Hi all -

I keep getting:

Runtime error 
Traceback (most recent call last):
  File "<string>", line 26, in <module>
RuntimeError: workspace already in transaction mode‍‍‍‍‍‍‍‍

when I run my script. I can't sort out why.

Here's my code. (Not loving how the formatting works here.)

# Move points based up current lat/lon
#grab stuff you need
import arcpy
import os
print "Imported Libraries."

# Set variablesfilepath = r'S:\AGR\AGR-Shared\AGR-GIS\AGR_Data\Connection to cloud.agriculture.vermont.gov.sde'
fc = "AGRGISDATA.DBO.ApiariesWGS"
fc_path = os.path.join(filepath, fc)
fields = ['Longtitude','Latitude','SHAPE@XY']
#arcpy.env.workspace = fc_path #I don't think this is needed. 
workspace = os.path.dirname(fc_path)
editor = arcpy.da.Editor(workspace) #this one throws "RuntimeError: workspace already in transaction mode"
print "Set vars."

editor.startEditing(False, True)
editor.startOperation()
print "Editor Commands."

#create curser on fc
#try:    
#print "Trying"
with arcpy.da.UpdateCursor(fc_path,fields) as cursor:    
print "With"    
for row in cursor:        
print "for row in cursor"        
x = row[0]        
y = row[1]        
xy = (x,y)        
pnt = xy        
row[2] = pnt        
cursor.updateRow(row)        
print "Updated Rows."
#finally:    
editor.stopOperation()    
editor.stopEditing(True)    
del editor
print "It worked!"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

My code is indented properly, I just couldn't make it do so with the syntax highlighter here. I'm sure there's a way, but I haven't figured it out.

Anyway, I've been trying different things to get this code running again, and I'm out of ideas. Would love some help.

Thx

Re: RuntimeError: workspace already in transaction mode?! Help, pls!

Anonymous User — Wed, 19 Apr 2017 15:16:39 GMT

It was an SDE locking issue, just in case anyone in the future is looking this up.

Re: RuntimeError: workspace already in transaction mode?! Help, pls!

RebeccaStrauch__GISP — Sun, 12 Dec 2021 01:59:13 GMT

Just in case it is a locking issue causes by a step in your script, you can use time.sleep() to pause what a lock is released. I have to do this with some of my scripts which seem to run faster than the system is responding. for example

import time
def mySleep(secs):
     print("     zzz...sleeping {0} seconds to allow network file status to catch up....".format(secs))
     time.sleep(secs)     
     
mySleep(10)     ‍‍‍‍‍‍

Re: RuntimeError: workspace already in transaction mode?! Help, pls!

AdrianWelsh — Wed, 23 Aug 2017 20:24:35 GMT

I had this same error but it came up in ModelBuilder in ArcGIS Pro 2.0. It was a file geodatabase and I just closed my project and opened it again, and it ran just fine. Is there a way to put in a sleep timer thing in #ModelBuilder‌?

Re: RuntimeError: workspace already in transaction mode?! Help, pls!

AdanDeLeon — Wed, 25 Apr 2018 23:41:50 GMT

After reading all sorts of fixes for this issue online, neither worked for my situation and ended up finding out that table that I was trying to insert need to have edit rights under "Privileges"! haha