Append cannot open data in Modelbuilder

Question

I'm working on a modelbuilder tool to append and update data. I have isolated an issue when the model gets to the append tool. I've isolated that portion of the model (just the tool with the inputs). It gives me

ERROR 000229: Cannot open D: \ProProjects\PFAS\Updates.gdb\xtabResultsHAtem_ExportTable

ERROR 000229: Cannot open GIS_DEP.PFAS_ResultsHA

and then

Failed to execute (Append).

The input table is in a geodatabase, while the target table is in an enterprise geodatabase.

If I run the tool with the same inputs and settings from the geoprocessing window, it runs fine.  Any ideas?

AppendIssue.JPG

lah · Answer

I'm getting this same "cannot open ..." error running the append tool with the Update Options - matching fields configured. If I remove the matching fields for update, the tool will run successfully; however, I need the data to update if the same record exists.

Did you ever figure this out?