[GIS] ERROR 000840: The value is not a Raster|Raster Catalog|Mosaic Layer from arcpy.AddJoin_management()

arcgis-10.0arcpyerror-000840

I am doing some arcpy -functions and afterwards I'm trying to add the calculated results from one table to another table. I'm using the arcpy.AddJoin_management() function.

As input table I'm using a table which is stored in a personal geodatabase. The personal geodatabase is not the workspace environment! As "JoinTable" a Table of a file geodatabase is used. This file geodatabase is the workspace geodatabase environment.

The initialized function looks like this:

(%self.getWorkspaceEnvironment => "W:/a18fb/data/mypersonalgeodatabase.mdb" and tFactsheetHochwasser => table in the personal geodatabase)

arcpy.AddJoin_management("%s/tFactsheetHochwasser"%self.getWorkspaceEnvironment(),"KPG",
"GebaeudeKtn_BWVred1Stat","KPG","KEEP_ALL")

If the code is executed the following error-message appears:

Failed to execute.Parameters are not valid.
The value cannot be a table

ERROR 000840: The value is not a Raster Layer.

ERROR 000840: The value is not a Raster Catalog Layer.

ERROR 000840: The value is not a Mosaic Layer.

Failed to execute (AddJoin)`.

Best Answer

The solution to my issue was to create a tableView using arcpy.MakeTableView_management() The temporary existing View allows joining the tables each other.

Related Question