Error in an ETL job

[fn_guennoun]

Hey,

I have an ETL job in Talend Open Studio 7.3 that consists of two PostgreSQL components (input and an output) connected via a tMap component.

The Input component (PrepDimLivraison) is created from another job, the data was brought from a MySQL database, some types were converted in order to populate the PostgreSQL database correctly.

See picture below of the job generating the error, knowing that no specific chages are done on the data, just a simple mapping, but I keep getting this error :

Starting job Create_Dim_DW at 11:01 12/07/2020.

[statistics] connecting to socket on port 3652

[statistics] connected

Exception in component tDBOutput_1 (Create_Dim_DW)

org.postgresql.util.PSQLException: ERROR: syntax error on or near "'," id_echange "INT4," type_lv "INT4 default 1," source_validation "INT4," email "VARCHAR (50)," display "INT4 default 0, "return" INT4 default 0, "return_call" INT4 default 0, "comission" INT4 default 0, "tel" VARCHAR (50), "id_tache_ramassage" INT4, "id_tache_retour" INT4, "sav_traite" BOOL default '»

Position: 1176

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:2505)

at org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:2241)

at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java:310)

at org.postgresql.jdbc.PgStatement.executeInternal (PgStatement.java:447)

at org.postgresql.jdbc.PgStatement.execute (PgStatement.java:368)

at org.postgresql.jdbc.