JoinField General Function Failure

Discussion created by david.gis on Aug 21, 2013
Latest reply on Sep 18, 2013 by mitcjess
Hi there,

I am having an issue with the arcpy.JoinField_management() function. Most of the time (but NOT always), it fails in several of my scripts, although it is structurally no different than example 2 in ArcGIS help: that is, a feature class and a table, both imported into a geodatabase, and the JoinField used to join the table to the feature class.

The error I get is:
arcgisscripting.ExecuteError: ERROR 999999: Error executing function.
General function failure [featureclassname]
Failed to execute (JoinField).

looking into the script of the function, the exact point of failure is:
        retval = convertArcObjectToPythonObject(gp.JoinField_management(*gp_fixargs((in_data, in_field, join_table, join_field, fields), True)))
        return retval
    except Exception, e:
        raise e

What can I do to solve this problem? My impression is that it's a cache/memory issue, since it doesn't always fail. Is there a way to clear memory in arcpy?

Any help would be appreciated - I've been struggling with this for weeks. I'm happy to provide more code or data if that's useful to explain the problem.