Have a FeatureWriter to insert data into a SQL table. It ran successfully without any error. However, no data shown in the destination database table. Reviewed the log and it says Features not written (see below):
Below is the Feature Writer:
Both FME Desktop and Server are the same 2021 version. FeatureWriter insert works well in my other workspace. Not sure why it didn't work here.
Hi @fmesafejde, curious if you might have truncated the table you're writing to. Could you attempt it with the regular MSSQL writer to see if that makes a difference?
Hi @jennaatsafe
Upon reviewing log file, turns out one of the SQL table column does not allow nulls.
Added a blank space in Attribute Manger for that field and the inserts works now.
Thanks.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.