topic Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs in Geoprocessing Questions

10.1 arcpy.CopyFeatures_management fails when using joined inputs

MarkWilloughby — Thu, 11 Oct 2012 19:35:09 GMT

Scenario:

-fresh File Geodatabase created using ArcCatalog 10.1;
-one feature class in FGDB;
-one table in the same FGDB;
-make a feature layer from feature class;
-make a table view from table;
-add join using feature layer and tableview as inputs, KEEP_COMMON;
-execute copyfeatures to write new featureclass into the same FGDB and preserve joined data in output;

This works (sometimes) in modelbuilder but doesnt work in a standalone python script. It doesn't seem to matter if join columns are indexed or not.

Is this a known defect and if so, is it going to be fixed soon as I have dozens of scripts that use this workflow that work just fine in earlier releases?

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

NobbirAhmed — Fri, 10 Dec 2021 22:42:40 GMT

I cannot reproduce it in 10.1. I can test if you can share your data (or part of data).

Here is my script:

import arcpy
import os

wks = os.getcwd()
arcpy.env.workspace = os.path.join(wks, "joins.gdb")

in_fc = "states_few"
in_id = "geocompID"
join_table = "table1"
join_id = "ID"
join_type = "KEEP_COMMON"

try:

    # note the output layer name is states_layer
    # use this output layer in subsequent tools
    arcpy.MakeFeatureLayer_management(in_fc, "states_layer")

    arcpy.AddJoin_management("states_layer", in_id, join_table, join_id, join_type)

    arcpy.CopyFeatures_management("states_layer", "states_joined")

    print arcpy.GetMessages()

except:
    print arcpy.GetMessages(2)

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

DanPatterson_Retired — Wed, 31 Oct 2012 22:15:48 GMT

Try to add the intermediate step of exporting the joined file to a new one and see if it fails as well

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

KimOllivier — Thu, 08 Nov 2012 08:49:13 GMT

Fails for me every time in a script, but not interactively. A complete pain.

Even if I run it successfully interactively, copy-as-python-snippet and repeat in a script it fails to populate the joined fields.
There is no error message, just blank (not null) fields.

Running 10.0 SP5 but a test on 10.1 SP1 had the same result.

My (terrible) workaround is to create a dictionary of the joined feature content, add the fields and then run an updatecursor with the dictionary.

Alternatively I just open the results the next month and run it again while I surf the net watching the election.....

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

JonathanCusick — Wed, 10 Jul 2013 12:10:24 GMT

I feel like I'm missing something obvious, but I'm having trouble with the CopyFeatures_management command as well.

My script creates a new file gdb into which I would then like to copy feature classes. The script works fine when I define the name of the new gdb ahead of time within the code, but I'd rather have the name generated using GetParametersAsText to make the script more interactive. I'm very new to python so I don't know if I'm I just formatting my CopyFeatures command wrong?

As of now I get TypeError: unsupported operand type (s) for +: 'Result' and 'str'

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

JonathanCusick — Wed, 10 Jul 2013 12:50:38 GMT

Turns out it was a simple fix. I added:

output_str = str (output)

after making my new gdb to convert it to a string. This (I think?) allows it to be read by other commands down the line.

Re: 10.1 arcpy.CopyFeatures_management fails when using joined inputs

NobbirAhmed — Wed, 10 Jul 2013 15:51:12 GMT

The '+' operand works when both are string (or of same type). Your output is an object of type 'Result'. When you converted it to a str your code worked 🙂

A better practice is to call getOutput to get the whole path of the geodatabase:

output.getOutput(0)