I have a workflow where I am truncating an existing gdb table and a single attribute value is not being constantly output.
The target attribute is a text field with a length of 50. The values that are supposed to be output to that field are all less than that length.
About half of the time I run the workspace, it correctly outputs the values as expected. The other half of the time many but not all of the values come across as an empty string. It seems to switch back and forth between outputting correctly and encountering the issue.
Regardless of if the issue occurs or not, the feature cache at the final transformer of the process always shows the field fully populated as it should be. The issue happens while the data is being truncated to the gdb table.
When the output is viewed in ArcGIS Catalog, the field has an asterisk next to it, and is the only field in the dataset that has it. From what I've seen while researching that means this field is indexed, but I'm not sure how that exactly correlates/causes the issue I have described. It is also the only field in the dataset where this issue occurs.
Edit: I should also note that the transaction type of the writer is an edit session, and the target gdb table participates in a relationship class with another feature class in the same gdb that also gets truncated in the same process.
Does anyone have any insight into how to fix this issue? I have an open support ticket but figured It could help to ask here as well.
Thanks in advance.