error to load using tpostgresoutput duplicate key

Four Stars

error to load using tpostgresoutput duplicate key

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.

 

Eight Stars

Re: error to load using tpostgresoutput duplicate key

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

Four Stars

Re: error to load using tpostgresoutput duplicate key

the database is empty already
Eight Stars

Re: error to load using tpostgresoutput duplicate key

Hello,

 

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

 

Regards

Lojdr