Insert Cursor is failing after retriving value using search curor.

JackAvis

Hey GISers My code is failing to insert cursor value.  The value it is return for parcel is correct its just not inserting it into my table.  

A little help would be gratly appreciated.  Thank you.

CODE

# Insert Cursor for GDB table to GDB table 
# Import modules, environment settings
import arcpy, traceback, string
arcpy.env.overwriteOutput = True

# Database connection variables on SPGISPROC1
OutFGDB = r"P:\batch\APO\District_overlay.gdb\pa_fp_dat1"
InFGDB = r"P:\batch\APO\District_overlay.gdb\pa_fp_rel1"

#Create cursor for input table items
InCursor = arcpy.SearchCursor(InFGDB)

# Create a variable that stores the value for column in a given row of the input table

for InRow in InCursor:

    parcel      = InRow.getValue('pafp_frq_PARCEL') 
    fp_zone1    = InRow.getValue('pafp_frq_ZONE2')

    # Copy the stored value from the input table into the output table
    gdbCursor = arcpy.InsertCursor(OutFGDB)
    row = gdbCursor.newRow()

    if fp_zone1:
        fp_zone1 = fp_zone1.upper
       
    #Fill out fields with variables from input table       
    row.pafp_frq_PARCEL = parcel
    row.pafp_frq_ZONE2  = fp_zone1   

    #Insert new row into output file
    gdbCursor.insertRow(row)

#Delete cursor and row objects to remove locks on the data
del row
del cursor




ERROR Message

Traceback (most recent call last):
  File "C:\Python27\ArcGISx6410.1\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 325, in RunScript
    exec codeObject in __main__.__dict__
  File "C:\gisdata\Python\Insert_table_Cursor.py", line 28, in <module>
    row.pafp_frq_PARCEL = parcel
  File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__
    return setattr(self._arc_object, attr, ao)
RuntimeError: ERROR 999999: Error executing function.
>>>

T__WayneWhitley

Pretty simple, I guess you're mixing up your field aliases with your actual field names --- and your answer was alluded to by Jason and from the last comment by GISer on GIS Stack Exchange here:
http://gis.stackexchange.com/questions/80428/insert-cursor-fails-to-write-results-to-table

I entered a few commands interactively - probably what you're asking is why the field doesn't exist?...that becomes clear when you use ListFields (which operates on the actual field names, not the field aliases, just as the cursors do) -- there's more code than you need below to identify your error as I did this in ArcMap's Python window (and I'd actually use the da search and insert cursors in the end if I were you).  See the 2nd ListFields which I guess you meant to target 'parcel' - so be careful mixing up names for fields.  Also I suggest you be more careful not to confuse variable names either, which you are dangerously close to doing with the name 'parcel'.

>>> infc = 'pa_fp_rel1' >>> outfc = 'pa_fp_dat1'  >>> InCursor = arcpy.SearchCursor(infc) >>> gdbCursor = arcpy.InsertCursor(outfc) >>> for InRow in InCursor: ...     parcel = InRow.getValue('pafp_frq_PARCEL') ...     fp_zone1 = InRow.getValue('pafp_frq_ZONE2') ...     row = gdbCursor.newRow() ...     if fp_zone1: ...         fp_zone1 = fp_zone1.upper() ...     row.pafp_frq_PARCEL = parcel ...     row.pafp_frq_ZONE2 = fp_zone1 ...     gdbCursor.insertRow(row) ...      Runtime error  Traceback (most recent call last):   File "<string>", line 7, in <module>   File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__     return setattr(self._arc_object, attr, ao) RuntimeError: ERROR 999999: Error executing function.   >>> fieldsIn = arcpy.ListFields(infc)  >>> for field in fieldsIn: ...     print field.name ...      OBJECTID pafp_frq_FREQUENCY pafp_frq_PARCEL pafp_frq_ZONE2 pafp_frq_Shape_Area pafp_frq2_OBJECTID pafp_frq2_FREQUENCY pafp_frq2_PARCEL pafp_frq2_Shape_Area  >>> fieldsOut = arcpy.ListFields(outfc) >>> for field in fieldsOut: ...     print field.name ...      OBJECTID parcel fp_zone1 >>>