topic Re: arcpy.RemoveJoin_management error (bug?) in Geoprocessing Questions

arcpy.RemoveJoin_management error (bug?)

MichaelPorter1 — Fri, 07 Sep 2012 18:28:24 GMT

Using ArcMap 10.1

When I run the following in the Python window:

arcpy.RemoveJoin_management("POD", "")

I get this error:

Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\management.py", line 5402, in RemoveJoin raise e ExecuteError: ERROR 000582: Error occurred during execution.

Tried everything I could think of: replacing first argument with layer reference, removing second argument, setting secong argument ... Weird thing is when I run the same code in ModelBuilder it works. I export the python from ModelBuilder and it is the exact same as above.

Any thoughts?

Thanks

Re: arcpy.RemoveJoin_management error (bug?)

curtvprice — Mon, 10 Sep 2012 19:36:26 GMT

Is this a raster layer? If so, this is a bug I have logged, reportedly fixed in 10.1 SP 1.

[#NIM066368 Remove Join tool fails when the input is a raster with a joined field.]
http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDY2MzY4

Re: arcpy.RemoveJoin_management error (bug?)

MichaelPorter1 — Tue, 11 Sep 2012 18:53:01 GMT

nope. Feature Layer. Will try SP1 though.

Thanks

Re: arcpy.RemoveJoin_management error (bug?)

ChrisSnyder — Sun, 12 Dec 2021 00:00:08 GMT

You don't appear to be naming the join table you want to remove (which is required, and is the name of the join table).
For example:

fc = r"C:\temp.gdb\my_mc"
lut = r"C:\temp.gdb\my_lut"
arcpy.MakeFeatureLayer_managment(fc, "mickeymouse")
arcpy.AddJoin_mangement("mickeymouse", "ID", lut, "ID")
arcpy.RemoveJoin_management("mickeymouse", "my_lut")

Re: arcpy.RemoveJoin_management error (bug?)

MichaelPorter1 — Wed, 12 Sep 2012 12:21:56 GMT

Thanks for your response

I tried that and it did not work.

Also, according to the help documentation {join_name} is optional

Re: arcpy.RemoveJoin_management error (bug?)

Anonymous User — Wed, 12 Sep 2012 14:31:21 GMT

Did you use the JoinField function rather than the AddField by accident? If you used arcpy.JoinField_management you cannot remove the join because this makes a permanent join to the attribute table, whereas the arcpy.AddJoin_management will make a temporary join that can be removed. This is the only reason I can think of as to why you cannot remove the join.

Re: arcpy.RemoveJoin_management error (bug?)

ChrisSnyder — Sun, 12 Dec 2021 00:00:11 GMT

The Help topic is wrong in that regard. I cannot think of an instance when the join name would be an optional parameter. In fact the Help topic is pretty clear about the proper naming convention of the join name: http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000066000000.

Here is some of my own v10.1 Python code that uses the RemoveJoin tool:

#Process: Populates the O_RB_DIST, O_RB_OID, and O_RB_WTY fields
oesfRipBuffFC = root + "\\layer_prep\\oesf_rip_buff.gdb\\oesf_rip_buff"
arcpy.MakeFeatureLayer_management(indxTileFC, indxTileFL, "FID_oesf_rip_buff > -1")
if int(arcpy.GetCount_management(indxTileFL).getOutput(0)) > 0:
    arcpy.AddJoin_management(indxTileFL, "FID_oesf_rip_buff", oesfRipBuffFC, "OBJECTID", "KEEP_COMMON")
    arcpy.CalculateField_management(indxTileFL, "O_RB_OID", "[oesf_rip_buff.LDO_OID]", "VB")
    arcpy.CalculateField_management(indxTileFL, "O_RB_DIST", "[oesf_rip_buff.DISTANCE]", "VB")
    arcpy.CalculateField_management(indxTileFL, "O_RB_WTY", "[oesf_rip_buff.SL_WTRTY_CD]", "VB")
    arcpy.RemoveJoin_management(indxTileFL, "oesf_rip_buff")

Re: arcpy.RemoveJoin_management error (bug?)

ChrisSnyder — Wed, 12 Sep 2012 15:06:43 GMT

Forgot to ask: Is there something unusual about your parent table or look up table? For example, is your look up table a GRID .vat, an ODBC table, Excel table, etc.?

Posting more of your code would be helpful (use the # code tag button).

Re: arcpy.RemoveJoin_management error (bug?)

SteveSalas — Thu, 15 Nov 2012 20:37:10 GMT

I am still at base ArcGIS 10.1 (no sp1)... RemoveJoin in my script worked fine at 10.0, fails in 10.1. The layer being joined to is a ArcSDE feature class in Oracle. The joined table is also from Oracle ArcSDE 10.0

At 10.0, the "join_name" parameter was in the format "owner.table" - no problems
At 10.1 "owner.table" format fails, the error message indicates that the parameter should be just "table" - which matches the options in the drop-down if I try to use RemoveJoin tool in ArcToolbox. In either case, script or Toolbox tool, the RemoveJoin still fails with the format "table". The Toolbox tool considered all inputs valid... but it fails with a 999999... error when run. The only way I can make this tool work is by leaving the "join_name" parameter blank which removes all joins, and appears to be my workaround for now.

Nothing seems to match this in the SP1 resolved issues list.

Re: arcpy.RemoveJoin_management error (bug?)

GlennCondon — Fri, 04 Jan 2013 18:42:18 GMT

I have had a very interesting episode with this operation as well. For the record I'm working with 10.0 and have not been able to get this to work in an ArcTool script. The only way I could get this to work was by choosing the parameter options from the interactive Python Window. The most inexplicable thing was, if I manually typed in the correct parameters I get a syntax error. If I take the drop-down list choices I'm good. This has certainly got to be a bug that needs to be addressed. See screen shot from Python Window with highlighted Parsing Error and successful execution of the command in last line.[ATTACH=CONFIG]20457[/ATTACH]

Re: arcpy.RemoveJoin_management error (bug?)

curtvprice — Mon, 07 Jan 2013 13:43:23 GMT

This has certainly got to be a bug that needs to be addressed.

The best way to make sure a bug fix happens is to submit a support incident. If multiple people report the problem, it's even more likely to be prioritized by the development teams. Although it's possible developers may read this forum, a support incident captures all the information the developers need for the fix.

So please do report bugs like this, and if the bug is logged feel free to post the NIM# here in the forums to further grease the wheels. (this saves time for other users reporting the same bug).

Re: arcpy.RemoveJoin_management error (bug?)

PaulMcCombs — Tue, 11 Jun 2013 22:08:27 GMT

Solution

I was having the same problem. The join table is a 10.0 SDE feature class. Using "db.owner.feature_class_Name" as the second parameter in arcpy.RemoveJoin_management worked in 10.0 but failed after upgrading client to 10.1. After reading this thread and the arcpy documentation, and discussing how to leave out optional parameters with a more experienced python user, I decided to try opting out of the second parameter by leaving it off entirely. Like so: arcpy.RemoveJoin_management("layername")

There was only one table joined to the layer in my specific case that this worked.