[GIS] arcpy join field tool is not licensed

arcpyerror-000824spatial-analyst

I am using ArcGIS and arcpy to process some shapefiles. When I try to use the function

arcpy.JoinField_management()

the program stops and Python says that the tool is not licensed. This confuses me because the documentation for the tool does not ask for any special licenses.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000065000000

An extract of my code and the error follow (the code is quite long but I run it ineractively to check it as I go).

import arcpy
arcpy.env.workspace = 'C:/Data/'
arcpy.CheckOutExtension('Spatial')
outZSaT = arcpy.sa.ZonalStatisticsAsTable('mb06.shp', 'MB_NUM', 'slope', 'sum_slope.dbf', 'DATA', 'SUM')
arcpy.JoinField_management('mb06.dbf', 'MB_NUM', 'sum_slope.dbf', 'MB_NUM')

Traceback (most recent call last):
  File "<pyshell#2>", line 2, in <module>
    workspace + '/sum_slope7.dbf', 'MB_NUM')
  File "c:\Program Files (x86)\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).

Best Answer

This issue can be resolved by installing ArcGIS for Desktop SP3 (or the current SP4) http://files.eaglegis.co.nz/ArcGIS%2010/ArcGIS%2010%20Service%20Pack%204/ArcGIS%20For%20Desktop%20(Basic,%20Standard,%20Advanced)/

Related Solutions

[GIS] Comparing extents of rasters using ArcPy

Try using the ExtractByMask tool again. Many times, even though ArcMap or ArcCatalog show that you have the Spatial Analyst extension checked out, the script will not recognize it. You can explicitly check out the Spatial Analyst extension at the beginning of your script and then it should work.

Check out this link to ArcGIS help:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/CheckOutExtension/000v0000003q000000/

[GIS] ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Layer Name or Table View: Dataset L does not exist

Here's a different way to do this by setting the dataframe equal to the current layer's extent. It a lot more simple. Also, you'd better check your path because it shows the MXD being inside the geodatabase.

import arcpy
import os

path = "C:\\Users\\Et\\Documents\\ArcGIS" #need to use two backslashes
mxd = arcpy.mapping.MapDocument(os.path.join(path, "WinterGritting.mxd")) #use os.path.join
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
layer_list = arcpy.mapping.ListLayers(mxd, "", df) #don't use indexing here

for layer in layer_list:
    layer_name = str(layer.name)

    for layer_check in layer_list: #turns on/off other layers
        if layer_check != layer:
           layer_check.visible = False
           layer.visible = True

    mxd.title = layer_name    
    layer_extent = layer.getExtent() #get the extent of the current layer
    df.extent = layer_extent #set the dataframe to the layer's extent
    arcpy.RefreshActiveView()
    arcpy.mapping.ExportToJPEG(mxd, os.path.join(path, "Routes", layer_name + ".jpg"))

del mxd

Updated for comment.

Add the names of whatever layers you don't want to turn off into the landbase list.

import arcpy
import os

path = "C:\\Users\\Et\\Documents\\ArcGIS" #need to use two backslashes
mxd = arcpy.mapping.MapDocument(os.path.join(path, "WinterGritting.mxd")) #use os.path.join
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
layer_list = arcpy.mapping.ListLayers(mxd, "", df) #don't use indexing here

landbase = ["Roads", "Lakes"] #add layer names you want always visible here

for layer in layer_list:
    layer_name = str(layer.name)

    if layer_name not in landbase:

        for layer_check in layer_list: #turns on/off other layers
            if layer_check != layer and layer_check.name not in landbase:
                layer_check.visible = False
            else:
                layer_check.visible = True

        mxd.title = layer_name
        layer_extent = layer.getExtent() #get the extent of the current layer
        df.extent = layer_extent #set the dataframe to the layer's extent
        arcpy.RefreshActiveView()
        arcpy.mapping.ExportToJPEG(mxd, os.path.join(path, "Routes", layer_name + ".jpg"))

del mxd

Related Question

[GIS] ArcGIS Exporting (ALL) layers from Table of Contents