RuntimeError: ERROR 999999: Error executing function.

G__EricCastillo_Morales

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.

1. import arcpy
2. from arcpy import env
3. env.workspace = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp'
4. crbuff = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\CRojaPBuff'
5. insumo = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\Insumo'
8. # Add field to insumo.
9. arcpy.AddField_management(insumo, "test", "TEXT", "", "", "50", "", "NULLABLE", "NON_REQUIRED", "")
12. # Make a layer from crbuff to get the select by location works.
13. arcpy.MakeFeatureLayer_management (crbuff, 'crbuff_layer')
14. arcpy.MakeFeatureLayer_management (insumo, 'insumo_layer')
17. # loop with cursor
18. cursor = arcpy.SearchCursor(crbuff)
19. field = "Lab" # Specify the field in the loop.
20. for row in cursor:
21.     print (row.getValue(field))
22.     arcpy.SelectLayerByLocation_management('insumo_layer', "HAVE_THEIR_CENTER_IN", 'crbuff_layer', "", "NEW_SELECTION", "NOT_INVERT")
23.     # Process: Calculate Field.
24.     cursorIn = arcpy.UpdateCursor('insumo_layer')
25.     for row in cursorIn:      
26.         row.setValue("test", row.getValue(field))
27.         cursorIn.updateRow(row)
28.    
31. # Process: Summary Statistics.
32. intable = r'D:\Eric\Ejercicio\shp\Insumo.shp'
33. outtable = r'D:\Eric\Ejercicio\shp'
34. 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.

AndrewKeith3

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.