Cannot edit versioned SDE data with Python update or insert cursor functions import arcpy fc = r "xyz" with arcpy . da . Editor ( r "xyz" ) as edit : with arcpy . da . UpdateCursor ( fc , [ "LINESEGMENTNAME" , "TEMP" ] ) as cu : for row in cu : print "print row 0:" + str ( row [ 0 ] ) row [ 1 ] = "test" cu . updateRow ( row ) console output summary print row 0:3 SystemError: error return without exception set It is stopping on line 9. I see in the above post that locks are sometimes the problem. I have tried destroying all locks on the target feature class and still get the error. Arc 10.1 SDE 10.1

The sql I tested for updating the vw tables. Just in case it helps anyone else in the future. But it has some risk with it. For my first time it was helpful to read this: https://sspinnovations.com/blog/versioning-dummies-part-4-esri-multiversion-views/ and this:What is a versioned view?—Help | ArcGIS Desktop call sde . version_util . set_current_version ( 'ARCFM8.vtest' ) ; call sde . version_user_ddl . edit_version ( 'ARCFM8.vtest' , 1 ) ; update arcfm8 . t_conductormarker_vw set REFERENCEDRAWING = 'test' where OBJECTID = 3 ; commit ; call sde . version_user_ddl . edit_version ( 'ARCFM8.vtest' , 2 ) ;

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; } } }

update cursor not working on versioned sde data

forestknutsen1

Cannot edit versioned SDE data with Python update or insert cursor functions

<SPAN class="keyword token">import</SPAN> arcpy
fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"xyz"</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Editor<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"xyz"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> edit<SPAN class="punctuation token">:</SPAN>
&nbsp; <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<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"LINESEGMENTNAME"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEMP"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cu<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cu<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"print row 0:"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"test"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cu<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</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>

console output summary
print row 0:3
SystemError: error return without exception set‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It is stopping on line 9. I see in the above post that locks are sometimes the problem. I have tried destroying all locks on the target feature class and still get the error.

Arc 10.1

SDE 10.1

Find more posts tagged with

Accepted answers

forestknutsen1

The sql I tested for updating the vw tables. Just in case it helps anyone else in the future. But it has some risk with it. For my first time it was helpful to read this: https://sspinnovations.com/blog/versioning-dummies-part-4-esri-multiversion-views/

and this:What is a versioned view?—Help | ArcGIS Desktop

<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_util<SPAN class="punctuation token">.</SPAN>set_current_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_user_ddl<SPAN class="punctuation token">.</SPAN>edit_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">update</SPAN> arcfm8<SPAN class="punctuation token">.</SPAN>t_conductormarker_vw <SPAN class="keyword token">set</SPAN> REFERENCEDRAWING <SPAN class="operator token">=</SPAN> <SPAN class="string token">'test'</SPAN>
<SPAN class="keyword token">where</SPAN> OBJECTID <SPAN class="operator token">=</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">commit</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_user_ddl<SPAN class="punctuation token">.</SPAN>edit_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

forestknutsen1

and this:What is a versioned view?—Help | ArcGIS Desktop

<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_util<SPAN class="punctuation token">.</SPAN>set_current_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_user_ddl<SPAN class="punctuation token">.</SPAN>edit_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">update</SPAN> arcfm8<SPAN class="punctuation token">.</SPAN>t_conductormarker_vw <SPAN class="keyword token">set</SPAN> REFERENCEDRAWING <SPAN class="operator token">=</SPAN> <SPAN class="string token">'test'</SPAN>
<SPAN class="keyword token">where</SPAN> OBJECTID <SPAN class="operator token">=</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">commit</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">call</SPAN> sde<SPAN class="punctuation token">.</SPAN>version_user_ddl<SPAN class="punctuation token">.</SPAN>edit_version <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ARCFM8.vtest'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

forestknutsen1

Sadly the field calculator also failed... and the old style update cursor (before da) also failed... so all that remains is doing it by hand or using the vw tables...

forestknutsen1

oh... I did not know it was ending so soon... part of the problem is we are dependent on ArcFM8... So, we are trying to get to ArcFM8 10.2.1d...

JoeBorgione

Forest- take a look at Esri Support 10.6 and you'll see that 10.2 gets retired in a year; perhaps you should/could give more consideration to a more recent upgrade. It may save you some trouble in the long run. Good luck!

forestknutsen1

Joshua, thanks for taking the time to reply. At least I know now that my approach is sound in general. I am thinking about the below options:

trying a join and a field calculator with arcpy
using cx_oracle with sql and update the versioned view tables
using stand alone sql to update the versioned view tables

On a side note we are trying (desperately) to get 10.2 so we at least will be back into a esri supported version. But we have massive corruption in are sde versions states. Which is causing no end of pain...

bixb0012

Forest, I hate when no one replies, so I am replying. That said, there isn't much I can offer since you are working with quite old software. My organization moved off 10.1 when it entered mature support a couple years ago, so I don't even have access to 10.1 software any longer.

What I can offer, without knowing more about your database back-end, is that your code snippet above works fine for me using ArcGIS Desktop 10.5.1 against a 10.3.1 Oracle enterprise geodatabase.

Good luck.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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