Skip to main content
Question

FeatureWritter not inserting data with no errors

  • October 26, 2022
  • 2 replies
  • 200 views

Forum|alt.badge.img+1

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):

AttributeBelow is the Feature Writer:

FeatureWriter 

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.

2 replies

JennaKAtSafe
Safer
Forum|alt.badge.img+8
  • Safer
  • 192 replies
  • October 26, 2022

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?


Forum|alt.badge.img+1
  • Author
  • 20 replies
  • October 27, 2022

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.