topic Re: Error with JoinField geoprocessing tool in Python Questions

Error with JoinField geoprocessing tool

EricCharlton — Tue, 08 May 2012 20:10:57 GMT

I'm getting the following error when I try to run a script in PythonWin for the Python Scripting for Geoprocessing Workflows ESRI Virtual Campus class for Arc GIS 10.0:

Traceback (most recent call last):
File "C:\Python26\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 309, in RunScript
    debugger.run(codeObject, __main__.__dict__, start_stepping=0)
File "C:\Python26\Lib\site-packages\pythonwin\pywin\debugger\__init__.py", line 60, in run
    _GetCurrentDebugger().run(cmd, globals,locals, start_stepping)
File "C:\Python26\Lib\site-packages\pythonwin\pywin\debugger\debugger.py", line 624, in run
    exec cmd in globals, locals
File "C:\Student\PythonGP10_0\Scripts\BufferRoads.py", line 16, in <module>
    arcpy.JoinField_management(inFeatures, inField, joinTable, joinField)
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 3667, in JoinField
    raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000824: The tool is not licensed.
Failed to execute (JoinField).

I have also tried running the tool from the Python window in ArcMap with the same results.
Here is the script:

import arcpy
from arcpy import env
#Set geoprocessing environment
arcpy.env.workspace = "C:/Student/PythonGP10_0/Data/SanJuan.gdb"
arcpy.env.overwriteOutput = True

#Set parameters used to join the BufferDistance table to the Roads feautre class

inFeatures = "Roads"
inField = "ROUTE_TYPE"
joinTable = "BufferDistance"
joinField = "ROUTE_TYPE"

#join table to feature class

arcpy.JoinField_management(inFeatures, inField, joinTable, joinField)

#Set parameters to buffer Roads feature class

outBuffers = "RoadBuffers"
buffField = "DISTANCE"

#Buffer roads based on DISTANCE attribute

arcpy.Buffer_management(inFeatures, outBuffers, buffField)

Any help on this would be greatly appreciated.

Re: Error with JoinField geoprocessing tool

MathewCoyle — Wed, 09 May 2012 12:36:17 GMT

You try running the JoinField tool from the Python window in ArcGIS and you are getting a tool is not licensed error? You aren't trying to use any extensions? That is odd behaviour, are you on a floating or single use license? View, Editor, Info? JoinField says it is available at any license level, so not even sure why that would be an issue. Have you tried it on different data?

Licensing issues are generally best handled by Esri support, I'm just grasping at straws.

Re: Error with JoinField geoprocessing tool

EricCharlton — Wed, 09 May 2012 17:15:06 GMT

I'm using an ArcGIS 10.0 demo license with an ArcEditor license level on XP SP3. I tried running the JoinField_management tool with different data in the Python window and got the same result. I am able to join tables in ArcMap in the usual way
with no problems. Other geoprocessing tools work in the Python window and in scripts with no problems.