Hi,
I am getting this annoying warning - it seems to be with dynamic writer -
Using SQL Server 2017 / 10.9.1
GEODATABASE_SDE Writer: Renamed user attribute 'Shape.STArea()' to 'Shape_STArea__' based on format constraints for invalid characters, length, and case
GEODATABASE_SDE Writer: Renamed user attribute 'Shape.STLength()' to 'Shape_STLength__' based on format constraints for invalid characters, length, and caseNormal writer works fine
“.” , “(“ and “)” are not acceptable character values to use for an ESRI SDE Geodatabase field name.
FME knows this, so you are getting a message that FME is instead substituting the “_” in the field name being written instead since “_” is an acceptable character in ESRI Geodatabase field names.
Beyond that, if using the SDE Writer, don’t attempt to write the Area or Length values, SDE will do that for you so you don’t need to call Eg. STArea() from the upstream Reader/SQLCreator/SQLExecutor. From memory all that is needed is a blank shape_length and shape_area attribute within the Writer and this will reliably trigger SDE to calculate the value(s) within the SDE API itself during insert or update.
Similarly if really do need read in shape_length or shape_area in the workspace, change the SQL to ...Shape.STArea() AS shape_area and Shape.STLength() AS shape_length