Hello,
I have a workspace in FME Form that reads a large number of tables from a PostgreSQL database and writes them into another PostgreSQL database with the same schema structure but without data.
Workspace design
I use a FeatureWriter configured for PostgreSQL with the following settings:
-
Table name is dynamic and taken from the incoming feature type:
Table Name = fme_feature_type
-
Attribute Definition = Automatic
-
The destination database already contains the tables (same structure).
Each feature is therefore written to the corresponding table in the destination database.
Behaviour in FME 2023.2
With FME Form 2023.2, this workflow works perfectly, even though the tables do not all have the same attributes.
Behaviour in FME 2025.1.1
When running the exact same workspace in FME Form 2025.1.1, I now get the following error:
POSTGRES Writer: Cannot write to table 'enu_cad_caracteristique_constructive'. No valid columns provided
Writer failed in write() call
POSTGRES writer: An error has occurred. Check the logfile above for details
My suspicion
It seems that in FME 2025.1.1 the FeatureWriter no longer correctly handles the dynamic attributes, as if the writer does not recognize the incoming attributes when the table name is dynamic.
Question
Has there been a change in the behaviour of FeatureWriter between FME 2023 and FME 2025 regarding dynamic schemas or attributes?
Or is there now an additional parameter required when writing to multiple tables with different attribute structures?
Any guidance would be greatly appreciated.
