RuntimeError: ERROR 999999: Error executing function.

G__EricCastillo_Morales — Thu, 10 Mar 2016 16:35:04 GMT

I'm trying to write in test field from some layer based on iterate feature selction. I get succes using model builder but I'm fail when I try with my own code.

The process with MB.

The code and error.

Here is the code.

import arcpy
from arcpy import env
env.workspace = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp'
crbuff = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\CRojaPBuff'
insumo = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\Insumo'
# Add field to insumo.
arcpy.AddField_management(insumo, "test", "TEXT", "", "", "50", "", "NULLABLE", "NON_REQUIRED", "")
# Make a layer from crbuff to get the select by location works.
arcpy.MakeFeatureLayer_management (crbuff, 'crbuff_layer')
arcpy.MakeFeatureLayer_management (insumo, 'insumo_layer')
# loop with cursor
cursor = arcpy.SearchCursor(crbuff)
field = "Lab" # Specify the field in the loop.
for row in cursor:
print (row.getValue(field))
arcpy.SelectLayerByLocation_management('insumo_layer', "HAVE_THEIR_CENTER_IN", 'crbuff_layer', "", "NEW_SELECTION", "NOT_INVERT")
# Process: Calculate Field.
cursorIn = arcpy.UpdateCursor('insumo_layer')
for row in cursorIn:
row.setValue("test", row.getValue(field))
cursorIn.updateRow(row)
# Process: Summary Statistics.
intable = r'D:\Eric\Ejercicio\shp\Insumo.shp'
outtable = r'D:\Eric\Ejercicio\shp'
arcpy.Statistics_analysis(intable, outtable + "stats.dbf", "POB1 SUM;POB8 SUM;POB11 SUM;POB14 SUM;POB15 SUM;POB16 SUM;POB24 SUM;POB31 SUM;POB57 SUM;MIG7 SUM;INDI1 SUM;DISC1 SUM;DISC4 SUM;DISC5 SUM;DISC6 SUM;ECO1 SUM;ECO4 SUM;ECO25 SUM;ECO28 SUM;SALUD1 SUM;SALUD2 SUM;SALUD3 SUM;SALUD4 SUM;SALUD5 SUM;SALUD6 SUM", "test")

Thanks.

Re: RuntimeError: ERROR 999999: Error executing function.

AndrewKeith3 — Thu, 07 Apr 2016 17:29:15 GMT

Change Line 24 in your code to this:

cursorIn = arcpy.UpdateCursor(insumo)

dataset

The feature class, shapefile, or table containing the rows to be updated or deleted.

topic Re: RuntimeError: ERROR 999999: Error executing function. in Python Questions

RuntimeError: ERROR 999999: Error executing function.

Re: RuntimeError: ERROR 999999: Error executing function.