Append cannot open data in Modelbuilder

[CarolineChanEEC]

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?

[lah]

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?