Skip to main content
  • EN

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


Community Stats

30,351
Posts
115,342
Replies
38,082
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.