Latest Contributions by MichaelSouffront

Has anyone have this problem? I created a python script, and it runs fine in a python interface or as a python tool in Arcmap, but when I convert it to a geoprocessing service it won't run. Furthermore, the error it gives it's unclear: RuntimeError: Objects in this class cannot be updated outside an edit session This error doesn't make sense because 1. the process is done in an editing session, and 2. it works as a standalone script or as a python tool. Below is the code in case you want to take a look, but again it runs fine so the problem seems to be in the geoprocessing service step. import arcpy arcpy.env.overwriteOutput = True # If needed create a connection file to the sde geodatabase if not arcpy.Exists('connect.sde'):   arcpy.CreateDatabaseConnection_management('************') arcpy.env.workspace = r'connect.sde' # Input files districts = '*****' sites = '*****' arcpy.MakeFeatureLayer_management(sites, 'sites') # Start an editing session with arcpy.da.Editor(arcpy.env.workspace) as edit:     fields = ['Name', 'totalsites', 'completedsites', 'SHAPE@']     with arcpy.da.UpdateCursor(districts, fields) as cursor:     for row in cursor:       name = row[0]       shape = row[3]         arcpy.SelectLayerByLocation_management('sites', 'WITHIN', shape)       arcpy.CopyFeatures_management('sites', 'in_memory/selected')         # count total and completed       total = 0       completed = 0       siteFields = ['SITE_STATUS']       with arcpy.da.SearchCursor('in_memory/selected', siteFields) as cursor2:         for row2 in cursor2:           status = row2[0]           total += 1           if status == '****':             completed += 1         row[1] = total       row[2] = completed         cursor.updateRow(row)   print 'Finished'     Thanks a in advance, Michael ... View more

I was just wondering this the other day. I moved to Python 64 background processing a while ago, but there are certain tools I want to use that still need Python 32. I would like to keep Python 64 background processing but be able to go back to Python 32 every once in a while without having to uninstall 64. Thanks, Michael ... View more

I updated a script to clip wetlands data per county. Some counties work, but for others the Clip analysis fails. Here is the code: import arcpy import time # Start time start = time.time() print('Prepping wetlands county clipped data') # Enivornment variables arcpy.env.overwriteOutput = True arcpy.env.workspace = 'in_memory' arcpy.env.outputCoordinateSystem = arcpy.SpatialReference('NAD 1983 UTM Zone 12N') # Input paths countyPath = r'Counties' wetlandsPath = r'UT_Wetlands' # Output path outFolder = r'output.gdb' # Create feature dataset wetlandsFolder = '{}/Wetlands'.format(outFolder) if not arcpy.Exists(wetlandsFolder):   arcpy.CreateFeatureDataset_management(outFolder, 'Wetlands') arcpy.MakeFeatureLayer_management(countyPath, 'countyLayer') maxCount = len(idList) count = 1 countyRows = arcpy.SearchCursor(countyPath) for countyRow in countyRows:   county = str(countyRow.NAME).replace(' ', '_')      outFile = '{}/Wetlands/{}_Wetlands'.format(outFolder, county)   query = '"NAME" = \'' + str(countyRow.NAME) + '\''   arcpy.SelectLayerByAttribute_management('countyLayer', 'NEW_SELECTION', query)   print 'Clipping ' + str(count) + ' out of ' + str(maxCount)   arcpy.Clip_analysis(wetlandsPath, 'countyLayer', outFile)   arcpy.SelectLayerByAttribute_management('countyLayer', 'CLEAR_SELECTION')   count += 1   print 'Working on wetlands for ' + county.replace('_', ' ') + ' county...'   # Here I create variables   # Here I add new fields   # Here I populate the new fields with the created variables del countyRow, countyRows    # Finish end = time.time() print '\nFinished, run time', time.strftime('%M:%S', time.localtime(end - start)) The script will work until it gets to SANPETE county, which gives this error: arcgisscripting.ExecuteError: ERROR 999999: Error executing function. The table was not found. The table was not found. [SANPETE_Wetlands] The table was not found. The table was not found. [SANPETE_Wetlands] Invalid Topology [Incomplete void poly.] Failed to execute (Clip). I've tracked the error to the clip function. At first I thought there was an error in the syntax, then I thought arcpy was getting confused as to where to look for the created clipped feature because I was saving it in memory, then I thought maybe the wetlands data was just too big, or there is something wrong with the attribute data for the SANPETE county, but it's non of those. I tried skipping SANPETE but then it runs for a while and fails in BEAVER county. I'm running out of ideas as to what it may be. I tried the clip manually in arcMap and it works. Any suggestions as to what else to try or do you see anything I'm missing in the script? Thanks, Michael ... View more