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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.