topic Re: Trying to use the append tool in ArcGIS Pro Questions

Trying to use the append tool

Zelong — Thu, 27 Jan 2022 19:40:08 GMT

I am trying to append an existing layer with the result of a GEOcoder.

I am getting this error code when trying to run it:

I did go into field mapping to try and make the fields match with each other but I am still not having any luck

When I try "Use the field Map to reconcile field differences"

This is what i see and I am wondering if the 0s by the field names are part of the problem.

Any help is welcome.

Also the process is working in Arc map, we are trying to get this process working in Pro.

Re: Trying to use the append tool

DanLee — Fri, 28 Jan 2022 15:49:32 GMT

It's either some fields are still not matching or it's a bug. If you think it's the latter, the best is to log a BUG with Esri Customer Care, which will get our attention quickly.

Re: Trying to use the append tool

DanPatterson — Thu, 27 Jan 2022 20:59:24 GMT

000466: <value> does not match the schema of target <value>.—ArcGIS Pro | Documentation

Append (Data Management)—ArcGIS Pro | Documentation

Your input datasets should be examined. Are they gdb tables? What are the actual field properties for each field? do they match between tables?

Re: Trying to use the append tool

JayantaPoddar — Fri, 28 Jan 2022 03:00:31 GMT

In Field Mapping section, for each of the output fields (in red), Click Add New Source and choose the appropriate field from Input table.

Also ensure that the Field DataType is same for the target table and the mapped field from input table.

Re: Trying to use the append tool

Zelong — Fri, 28 Jan 2022 13:27:35 GMT

Thanks everyone!

Re: Trying to use the append tool

Patricia_Foster — Tue, 10 May 2022 16:40:14 GMT

Has a BUG ever been found with the APPEND tool? I'm having an issue where even after I've made sure all fields are mapped (I've told each output field, which input field to use, etc.), the APPEND tool completes without errors, but when I look at my table, the tool only successfully appended ONE record, when it should've been many more. I use "Load Data" in Desktop, with Catalog, and the tool works fine.

Re: Trying to use the append tool

VictorGutzler — Tue, 04 Feb 2025 17:02:57 GMT

Patricia, did you ever resolve this issue? We recently upgraded our servers and now I'm getting the same result.

Append
=====================
Parameters

Input Datasets 'Park.EDLEASE_VIEW PROD'
Target Dataset https://gis1.city.arl/arcgis/rest/services/Hosted/Park_EDLEASE_VIEW/FeatureServer/14
Field Matching Type TEST
Field Map
Subtype
Updated Target Dataset https://gis1.city.arl/arcgis/rest/services/Hosted/Park_EDLEASE_VIEW/FeatureServer/14
Expression
Matching Fields for Update
Update Geometry NOT_UPDATE_GEOMETRY
Appended Row Count 13
Updated Row Count 0
=====================
Environments

Extent -10809521.0596322 3860937.99485472 -10806931.7358911 3863308.91617663 PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]]
=====================
Messages

Start Time: Tuesday, February 4, 2025 10:37:55 AM
WARNING 000595: C:\Users\gutzlerv\AppData\Local\Temp\ArcGISProTemp13328\Park.%EDLEASE_VIEW3.fid contains the full list of records not able to be processed.
WARNING 000594: Input feature 1: General function failure.
WARNING 000594: Input feature 2: General function failure.
WARNING 000594: Input feature 3: General function failure.
WARNING 000594: Input feature 4: General function failure.
WARNING 000594: Input feature 5: General function failure.
WARNING 000594: Input feature 6: General function failure.
WARNING 000594: Input feature 7: General function failure.
WARNING 000594: Input feature 8: General function failure.
WARNING 000594: Input feature 9: General function failure.
WARNING 000594: Input feature 10: General function failure.
13 row(s) from C:\Users\gutzlerv\AppData\Local\Temp\ArcGISProTemp13328\14b63ed3ab10a05fbd1b33a25976206e.sde\Park.EDLEASE_VIEW were appended to https://gis1.city.arl/arcgis/rest/services/Hosted/Park_EDLEASE_VIEW/FeatureServer/14
Succeeded at Tuesday, February 4, 2025 10:37:58 AM (Elapsed Time: 2.51 seconds)