error to load using tpostgresoutput duplicate key

[Anonymous]

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.

[lojdr]

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

[Anonymous]

the database is empty already

[lojdr]

Hello,

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

Regards

Lojdr