Hi all - I keep getting: Runtime error Traceback ( most recent call last ) : File " " , 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 JG

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Anonymous User

Hi all -

I keep getting:

Runtime error 
Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"<string>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">26</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
RuntimeError<SPAN class="punctuation token">:</SPAN> workspace already <SPAN class="keyword token">in</SPAN> transaction mode‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

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

<SPAN class="comment token"># Move points based up current lat/lon</SPAN>
<SPAN class="comment token">#grab stuff you need</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Imported Libraries."</SPAN>

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

editor<SPAN class="punctuation token">.</SPAN>startEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>
editor<SPAN class="punctuation token">.</SPAN>startOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Editor Commands."</SPAN>

<SPAN class="comment token">#create curser on fc</SPAN>
<SPAN class="comment token">#try:&nbsp;&nbsp;&nbsp; </SPAN>
<SPAN class="comment token">#print "Trying"</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc_path<SPAN class="punctuation token">,</SPAN>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"With"</SPAN>&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"for row in cursor"</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
x <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
y <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
xy <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN>y<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
pnt <SPAN class="operator token">=</SPAN> xy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> pnt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Updated Rows."</SPAN>
<SPAN class="comment token">#finally:&nbsp;&nbsp;&nbsp; </SPAN>
editor<SPAN class="punctuation token">.</SPAN>stopOperation<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
editor<SPAN class="punctuation token">.</SPAN>stopEditing<SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">del</SPAN> editor
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"It worked!"</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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

Trouver plus de publications taguées avec

Accepted answers

Anonymous User

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

All comments

AdanDeLeon

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

AdrianWelsh

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‌?

RebeccaStrauch__GISP

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

<SPAN class="keyword token">import</SPAN> time
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">mySleep</SPAN><SPAN class="punctuation token">(</SPAN>secs<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"&nbsp;&nbsp;&nbsp;&nbsp; zzz...sleeping {0} seconds to allow network file status to catch up...."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>secs<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;time<SPAN class="punctuation token">.</SPAN>sleep<SPAN class="punctuation token">(</SPAN>secs<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
mySleep<SPAN class="punctuation token">(</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Anonymous User

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

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.