FIXED THE SCRIPT COPY/PASTE below: HI all - Maybe you can help me out. I've been getting this error for ages and it is making me nuts: Here's the script: # Move points based up current lat/lon #grab stuff you need import arcpy , os # Set variables folderName = r "S:\AGR\AGR-Shared\AGR-GIS\AGR_Data" fileName = "Connection to cloud.agriculture.vermont.gov.sde" filepath = r 'S:\AGR\AGR-Shared\AGR-GIS\AGR_Data\Connection to cloud.agriculture.vermont.gov.sde' serverName = "agr-ofwq2012\AGRGIS" serviceName = "5151" databaseName = "AGRGISDATA" authType = "DATABASE_AUTH" username = "**********" password = "**********" saveUserInfo = "SAVE_USERNAME" versionName = "SDE.DEFAULT" saveVersionInfo = "SAVE_VERSION" # Process: Use the CreateArcSDEConnectionFile function arcpy . CreateDatabaseConnection_management ( folderName , fileName , "SQL_SERVER" , serverName , authType , username , password , saveUserInfo , databaseName ) fc = "AGRGISDATA.DBO.ApiariesWGS" print fc fc_path = os . path . join ( filepath , fc ) print fc_path fields = [ 'Longtitude' , 'Latitude' , 'SHAPE@XY' ] print fields arcpy . env . workspace = filepath workspace = os . path . dirname ( filepath ) print workspace editor = arcpy . da . Editor ( workspace ) print editor editor . startEditing ( False , False ) editor . startOperation ( ) #create curser on fc try : with arcpy . da . UpdateCursor ( fc , fields ) as cursor : for row in cursor : x = row [ 0 ] y = row [ 1 ] xy = ( x , y ) pnt = xy row [ 2 ] = pnt cursor . updateRow ( row ) finally : editor . stopEditing ( True ) del editor

This does seem like a pathing issue: folderName = r "S:\AGR\AGR-Shared\AGR-GIS\AGR_Data" fileName = "Connection to cloud.agriculture.vermont.gov.sde" filepath = r 'S:\AGR\AGR-Shared\AGR-GIS\AGR_Data\ Auto Connection to cloud.agriculture.vermont.gov.sde' The full file path in the filePath variable has an "Auto" in it, which seems out of place given your folderName and fileName variables.

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

Cannot open workspace

Anonymous User

FIXED THE SCRIPT COPY/PASTE below:

HI all -

Maybe you can help me out.

I've been getting this error for ages and it is making me nuts:

Here's the script:

<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="punctuation token">,</SPAN> os


<SPAN class="comment token"># Set variables</SPAN>
folderName <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"S:\AGR\AGR-Shared\AGR-GIS\AGR_Data"</SPAN>
fileName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Connection to cloud.agriculture.vermont.gov.sde"</SPAN>
filepath <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'S:\AGR\AGR-Shared\AGR-GIS\AGR_Data\Connection to cloud.agriculture.vermont.gov.sde'</SPAN>
serverName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"agr-ofwq2012\AGRGIS"</SPAN>
serviceName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"5151"</SPAN>
databaseName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AGRGISDATA"</SPAN>
authType <SPAN class="operator token">=</SPAN> <SPAN class="string token">"DATABASE_AUTH"</SPAN>
username <SPAN class="operator token">=</SPAN> <SPAN class="string token">"**********"</SPAN>
password <SPAN class="operator token">=</SPAN> <SPAN class="string token">"**********"</SPAN>
saveUserInfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SAVE_USERNAME"</SPAN>
versionName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SDE.DEFAULT"</SPAN>
saveVersionInfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SAVE_VERSION"</SPAN>

<SPAN class="comment token"># Process: Use the CreateArcSDEConnectionFile function</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateDatabaseConnection_management<SPAN class="punctuation token">(</SPAN>folderName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fileName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">"SQL_SERVER"</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; serverName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; authType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; username<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; saveUserInfo<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; databaseName<SPAN class="punctuation token">)</SPAN>

fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AGRGISDATA.DBO.ApiariesWGS"</SPAN>
<SPAN class="keyword token">print</SPAN> fc
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>
<SPAN class="keyword token">print</SPAN> fc_path
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="keyword token">print</SPAN> fields
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> filepath
workspace <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>filepath<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> workspace
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="keyword token">print</SPAN> editor
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">False</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="comment token">#create curser on fc</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&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>fields<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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;&nbsp;&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;&nbsp;&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;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pnt <SPAN class="operator token">=</SPAN> xy
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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;&nbsp;&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>
<SPAN class="keyword token">finally</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&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;&nbsp;&nbsp;<SPAN class="keyword token">del</SPAN> editor
<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>‍</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>

Trouver plus de publications taguées avec

Accepted answers

All comments

Anonymous User

yeah, this is a copy/paste weirdness

JonathanQuinn

This does seem like a pathing issue:

folderName <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"S:\AGR\AGR-Shared\AGR-GIS\AGR_Data"</SPAN>
fileName <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"Connection to cloud.agriculture.vermont.gov.sde"</SPAN>
filepath <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit;">=</SPAN> r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">'S:\AGR\AGR-Shared\AGR-GIS\AGR_Data\<SPAN style="text-decoration: underline;"><STRONG>Auto</STRONG></SPAN>Connection to cloud.agriculture.vermont.gov.sde'</SPAN>

The full file path in the filePath variable has an "Auto" in it, which seems out of place given your folderName and fileName variables.

RebeccaStrauch__GISP

Besides the comments above, I don't see where you mention the version you are using. Did it break after upgrading ArcGIS Server? Using a service like 5151 is not available in the current versions and you you may benefit from switching this to a Direct Connect.

Why should I be making direct connections to an ArcSDE geodatabase? | ArcGIS Blog

That is an older blog, but might get you headed in the right direction with Direct Connects.

DanPatterson_Retired

once that is solved... it will be time to move on to how the coordinates are collected and which are the actual coordinates (I would check field name spelling first). Another reason to work on a local drive, then upload results.

curtvprice

So, your workspace definition is invalid. There could be several reasons for that, but for starters, spaces in pathnames are never a good idea. In fact anything outside [a..z][0..9]_ should be avoided.

RandyBurton

I think line 35 is actually line 23 in the original code (as both lines 1 and 18 are multiple lines):

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> filepath‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DarrenWiens2

Is this the exact code that caused the error? I don't see any reason why Line 35 (pnt = xy) should be trying to access any workspace at all. Also, Line 1 should have a syntax error (the character before the comment) and Line 39 should be 'editor' not 'edit'.

edit: I see that your current Line 18 should be split across several lines, which is messing up your Line numbering. What is supposed to be Line 35?

DanPatterson_Retired

is you line 17 and 18 a copy paste format glitch? it seems to be a concatenation of a comment and another line

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.