Skip to main content

Does anyone know if it's possible to suppress or otherwise fix the following warning which comes up when writing features to an MS SQL server database?

 

The column in the database is "nvarchar(max)" but FME always flags this warning when the workspace runs, because it uses "nvarchar_max".

 

It's only a warning, but when we then deploy this to FME Server/Flow - we regularly check the job logs and these always show the exclamation icon - so just an annoyance as it's not actually an issue.

in 2023, the latest version of AttributeManager has the ability to assign the data type for each attribute. This would be where you could set how FME interprets the nvarchar length, but there is no Max option like SQL. You could try making it nvarchar(4000) width

attributemanager_typeimageYou might be able to turn off "Log Warnings" under workbench FME options > Translation

Then publish the workspace to Flow

log filter message options 

 


Reply