Hi,
i have a workspace which reads a featureclass from ArcSDE with MSSQL Server 2012 with many fields, where one field is named “Post_Processing_Status”. I validate and check the data, do some calculations and create a csv from the data. Is the data from the feature class not valid I update the field “Post_Processing_Status” with the value “mangelhaft” or when it’s OK with “MNA” (originally “erfasst” is in Post_Processing_Status) and write it to the featureclass in the SQL Server.
However when I check the data, the value for Post_Processing_Status is written, but in some rows other field values are now missing, they are filled with blanks. In the original all fields were filled with values.
My procedure is I delete with an AttributeManager all other Attributes, except the OBJECTID and the Post_Processing_Status assign the value “mangelhaft” or “MNA” and link it to an Esri Geodatabase (ArcSDE Geodb) writer with the configuration “UPDATE”, the Transaction Type is set to “Transactions”.I cannot reproduce this error, sometimes it happens, sometimes not. 99% of all data is correct, but some values are deleted.
Anybody knows something, why are some fields now filled with blanks?
Thanks for your help
I use FME Desktop 2016.1.3.0 to create the workspace and is executed by FME Server 2016.1.3.1
Best answer by david_r
View original