vputinski

Having problems with Runtime Error: Update Cursor

Discussion created by vputinski on Dec 1, 2012
Latest reply on Dec 3, 2012 by Wayne_Whitley
I am extremely new to Python, which will become evident in this post.
This script was working just fine before trying it on a new shapefile's attribute table.
No column or row names were changed.

Here is the code:
import arcpy
import sys, os, time, copy

def POIequals(r1,r2):
    pnts=0
    #samePOI
    if r1.poi_id==r2.poi_id:
        return True #If POI_ID is the same, it is assumed features are equal
    #sameAddress
    if r1.address==r2.address:
        pnts+=1
    #sameBank
    if r1.newname==r2.newname:
        pnts+=1
    #sameCity
    if r1.city==r2.city:
        pnts+=1
    #closeLoc
    if (r1.x<=r2.x+0.0005 and r1.x>=r2.x-0.0005) and (r1.y<=r2.y+0.0005 and r1.y>=r2.y-0.0005):
        pnts+=1
    if pnts >= 3: #three of the 5 tests above must pass for features to be considered equal
        return True
    else:
        return False
    

print "Starting process..."
start=time.strftime("%a, %d %b %Y %H:%M:%S")
print start+"\n"

inFC="C:\\Users\\Toir\\Documents\\My Dropbox\\EPOIDuplicatesRemoved\\ALLFIN2002_2011\\AllFin2002_2011_Montreal.dbf"

rowsWrite = arcpy.UpdateCursor(inFC)
total=int(arcpy.GetCount_management(inFC).getOutput(0))

c=0
chold=0

for rowW in rowsWrite:
    #set variables for loop:
    poi=rowW.poi_id
    year=rowW.epoi_year
    gain=True
    loss=True
    #find if point is a gain or loss (or both):
    #where="[poi_id] = '"+poi+"'"
    rowsRead = arcpy.SearchCursor(inFC) #add "___,where)" to improve speed
    for rowR in rowsRead:
        if POIequals(rowW,rowR):
            if year-1==rowR.epoi_year:
                gain=False
            if year+1==rowR.epoi_year:
                loss=False
            if not loss and not gain:
                break
    #set change variable:
    change=""
    if gain:
        change="Gain"
    if loss:
        change="Loss"
    if gain and loss:
        change="GainAndLoss"
    if not gain and not loss:
        change="None"
    rowW.change=change
    rowsWrite.updateRow(rowW)
    #end of loop tasks:
    del rowR, rowsRead
    if c==chold:
        print "  ->"+str(c)+" of "+str(total)+" features completed. ("+str(round((float(c)/float(total)*100.0),1))+"%)"
        chold+=100
    c+=1

#unlock and final message:
del rowW,rowsWrite
print "Complete!"
end=time.strftime("%a, %d %b %Y %H:%M:%S")
print "Started: "+start+"\nEnded:   "+end


Here is the error I get:

Traceback (most recent call last):
  File "C:\Users\Toir\Documents\My Dropbox\EPOIDuplicatesRemoved\ALLFIN2002_2011\findLossAndGainWorkingBroadEquals_edit.py", line 33, in <module>
    rowsWrite = arcpy.UpdateCursor(inFC)
  File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\__init__.py", line 825, in UpdateCursor
    return gp.updateCursor(*args)
  File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\_base.py", line 362, in updateCursor
    self._gp.UpdateCursor(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.


Any help on this would be great, and ASAP please!

Outcomes