Append tool in Model Builder not keeping my field mapping settings

[MichaelTorbett]

ArcGIS Pro 2.4.1. I am using the append tool in model builder to append a file geodatabase feature class to an sde feature class. The schemas do not match so I  am using the field map to reconcile the differences. I will set the fields in my file GDB feature class to match fields in my sde feature class, all of which have the same data type. However when I close the model and reopen it, the field mapping resets. Has anyone else had this issue?

Thanks,

Michael 

[ShitijMehta]

We fixed append in 2.5. Let me check and get back to you. 

[MichelleWilliams1]

My troubleshooting:
Brought in MB from earlier ArcPro to ArcPro 2.5.1
Created a new MB in my old project (from above)
Created a new project and a new MB
I'm still getting NULLS : (

[ShitijMehta]

Hi, Sorry the case with SDE is broken at 2.5.1
I just added an internal ticket to help resolve this. I am sorry for this. 
Meanwhile can you bring both input and target to gdb and give it a try?

ty

[JosephRoberts2]

Running into the same problem with the table to table tool.  Any updates?

[MichelleWilliams1]

Here's a workaround -

I used a python script and then added the script to ModelBuilder. It works for me. 

Here are the steps:

1. Run the APPEND tool in ArcPro
2. Once complete, right mouse click APPEND in History and Copy Python Command (This will keep the mapped data)
3. Paste into any python editor
4. Save it
5. Go back into ArcPro and create a Python Script tool in your project Tool Box (Use the script you just saved)
6. Then I believe you can drag it into your ModelBuilder. I did it last week so I'm not positive.

[MichelleWilliams1]

Try Copy Features instead of Table to Table (that's how I fixed it).

[JosephRoberts2]

Thanks Michele. I'm considering your python option. 

Unfortunately copy features does not accept tables as an input. 

[MichelleWilliams1]

Sorry about that, I misread your post. Maybe you can find something that works in this link.

arcgis desktop - ModelBuilder not adding output feature class to Table of Contents? - Geographic Inf... 

[Anonymous User]

Would "copy rows" work instead of "copy features" if your input is table?

[Anonymous User]

I don't even get a chance to map fields when I am using append in modelbuilder. It works fine outside of modelbuilder.