I'm working in ArcGIS Pro 2.2 and I have a feature class from a geodatabase called "Seating." There is an empty field called "TSP_UID." I have joined another table from my local drive to this table.
Next, I wanted to calculate the seating.TSP_UID from the joinedtable.TSP_UID.
In ArcGIS Pro - calculate field fails and gives me a 999999 error. In ArcMap - it says calculate field is successful, but it doesn't actually alter any of the attributes.
Here's the python snippet from ArcMap:
# Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script
# The following inputs are layers or table views: "TDEC_GIS_TSP.Seating"
arcpy.CalculateField_management(in_table="TDEC_GIS_TSP.Seating", field="TDEC_GIS_TSP.Seating.TSP_UID", expression="(!TDEC_GIS_TSP_JoinedTable.TSP_UID!)", expression_type="PYTHON", code_block="")
UPDATE: So I closed everything out and opened ArcGIS Pro back up and MAGICALLY the field in question was suddenly populated?! So - now this is even more annoying because I can't figure out when this occurred or why it finally worked, and I've got a handful of other feature classes to do this with. Yayyyyyy. ESRI MAGIC.