I got this error while to load data to postgres database
Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_cop_company_profile"
Detail: Key (company_profile_id)=(0) already exists.
can you check if the record you want to insert uses primary key (pk_cop_company_profile) value that is not already in the database?
can you please post here the insert you are using and the table definition you are have in the database?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema