topic Re: ArcPy Append Error: Object: Error in executing tool in ArcGIS Notebooks Questions

ArcPy Append Error: Object: Error in executing tool

schwad — Thu, 28 Jan 2021 15:33:38 GMT

Hello,

I am trying to append an ArcGIS Online layer to an ArcGIS Enterprise layer using a Jupyter Notebook within ArcGIS Pro but I'm faced with the error in the heading.

my code is as follows:

# Get ArcGIS Online Grouped Feature Layer gis1 = GIS(agol_url, agol_name, agol_pass) agol_item = gis1.content.get(agol_item_id) agollyr = agol_item.layers[0] #Get ArcGIS Enterprise Feature Layer gis = GIS(ent_url, user_name, password) group_item = gis.content.get(group_item_id) grouplyr = group_item.layers arcpy.env.overwriteOutput = False ArcGISOnlineLayer = agollyr ArcGISEnterpriseLayer1 = grouplyr # Process: Append (Append) ArcGISEnterpriseLayer = arcpy.Append_management(inputs=[ArcGISOnlineLayer], target=ArcGISEnterpriseLayer1, schema_type="TEST", field_mapping="", subtype="", expression="")

We do not have geoanalytics server hence why I'm doing this work around, very new to python and have hit a brick wall!

Re: ArcPy Append Error: Object: Error in executing tool

Anonymous User — Thu, 28 Jan 2021 18:58:35 GMT

It might be that you have not imported arcpy into your notebook.

I haven't played with the notebooks in Pro yet, and I don't know if it automagically imports it for you so I could be wrong but it is my first thought looking at your code.

edit: Also, it might be that you have the schema_type parameter set to Test. from the docs: "TEST —Fields from the input dataset must match the fields of the target dataset. An error will be returned if the fields do not match." If there are any fields with different names between the two, the process will fail.

Re: ArcPy Append Error: Object: Error in executing tool

schwad — Fri, 29 Jan 2021 17:15:28 GMT

I have imported arcpy... it's not that

Re: ArcPy Append Error: Object: Error in executing tool

Anonymous User — Fri, 29 Jan 2021 17:46:17 GMT

ok, ... did you try changing the schema from Test to No_Test ?

ArcGISEnterpriseLayer = arcpy.Append_management(inputs=[ArcGISOnlineLayer], target=ArcGISEnterpriseLayer1, schema_type="No_Test")

Re: ArcPy Append Error: Object: Error in executing tool

schwad — Mon, 01 Feb 2021 10:06:02 GMT

I have just changed this, i am presented with the same problem, could it be because I'm using hosted layers instead of them being on client?

that being said it works fine if I am running it using the tool within pro.

Re: ArcPy Append Error: Object: Error in executing tool

Anonymous User — Mon, 01 Feb 2021 13:13:40 GMT

That could be. You can open up your geoprocessing history and export the successful completion of the tool as a python script. Then compare it to what you have in this script for ideas.

There is also an append in the arcpy for python api that might be what you need to use within Notebooks.

Append

keeping-layers-updated-by-appending-features-using-the-arcgis-api-for-python