UpdateCursor problems with AddJoin

Discussion created by mzcoyle on Sep 27, 2011
Latest reply on Sep 28, 2011 by mzcoyle
Background: When trying to improve speed of script, changed JoinField tool to AddJoin tool. The former was taking over 3 hours to join, the later a few seconds.

Later in the script when trying to create an UpdateCursor I get an error when using the temporary join (AddJoin).

Previously ran fine with permanent join (JoinField). Or when exported after temporary join.

Is this normal or a bug? Does anyone know of a faster way to process joined data?

Line giving error:
rows = arcpy.UpdateCursor(calc_table)

Error received:
Traceback (most recent call last):
  File "<pyshell#15>", line 1, in <module>
    rows = arcpy.UpdateCursor(calc_table)
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\", line 825, in UpdateCursor
    return gp.updateCursor(*args)
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\geoprocessing\", line 362, in updateCursor
RuntimeError: ERROR 999999: Error executing function.)