Error with Upsert to Netteza connector IIS-CONN-NZ-01004

[Torn]

I have 2 same parallel job where read one table from DB2 iseries
and over stage "copy" load data to some Netezza tables.

One job run succesful. Another fail with message

S01_EMPL_51: Failed to execute SQL statement: UPDATE S01_EMPL t SET t.DPTCOD=s.DPTCOD, t.EMPBEG=s.EMPBEG, t.EMPEND=s.EMPEND, t.EMPFAM=s.EMPFAM, t.EMPNAM=s.EMPNAM, t.EMPPTR=s.EMPPTR, t.DPTCOD_WRK=s.DPTCOD_WRK FROM NZCC_TT_20130808135305648S01_EMPL AS s WHERE t.EMPNMB=s.EMPNMB. Reason: [SQLCODE=HY000][Native=46] ERROR: Update canceled: attempt to update a target row with values from multiple join rows

Properties for target tables are identical in this jobs.

[swades]

Verify data in your target table, may be there are duplicates (multiple records present with same update keys) in target table.

select count(*) , update_keys from table group by update_keys having count(*) > 1

[cipsy]

Hi everybody,

I have same issue. My table have 1 row. but i see same issue. Any idea baout this issue