Skip to main content

Hello, I’m new to FME and I’m encountering a problem where the same rows of data aren’t being saved to both writers. I have two writers connected to the same database but with different tables. When the data is processed, the one saved in the shp_db_b table and can be seen, but there’s no output for the dashboard table (Even though it said ‘Translation was SUCCESSFUL’). I think the issue might be with the Aggregator transformer, but I'm not completely sure. I've attached the relevant pictures for reference. 

 

Do you have the geometry type set in the dashboards feature type? Many databases require that and if you supply geometry of a different type it'll reject the feature (you may see a warning in the log about that)

Mismatching attribute types can also be a reason, I've had a PostGIS writer dropping features because one attribute was a string rather than an integer value.