topic error to load using tpostgresoutput duplicate key in Talend Studio

error to load using tpostgresoutput duplicate key

Anonymous — Wed, 24 Jan 2018 01:32:10 GMT

hi,

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.

Re: error to load using tpostgresoutput duplicate key

lojdr — Wed, 24 Jan 2018 14:38:31 GMT

Hello,

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?

Regards

Lojdr

Re: error to load using tpostgresoutput duplicate key

Anonymous — Thu, 25 Jan 2018 10:03:22 GMT

the database is empty already

Re: error to load using tpostgresoutput duplicate key

lojdr — Fri, 26 Jan 2018 17:19:26 GMT

Hello,

can you please post here the insert you are using and the table definition you are have in the database?

Regards

Lojdr