ERROR DB Writer Execute failed: Duplicate entry '' for key 'PRIMARY'

KNIME Analytics Platform
1

Hey KNIME community

I need help please !

Indeed, I try to insert rows into an MySQL table with the “DB Writer” node
The table in destination is empty and without primary key only index
But each time I execute my dataflow the same error coming:

ERROR DB Writer Execute failed: Duplicate entry ‘’ for key ‘PRIMARY’

dataflow
dataflow1345×489 81 KB

How is it possible ? Have you any idea ?

Thanks a lot !

2

Hi and welcome -
This specific forum is for writing new extensions and nodes for the KNIME platform - but it seems like your question has to do with using existing nodes on the platform, so you should probably re-ask this here.

When you do, it would be helpful to people if you perhaps included the data leaving node 26 and the configuration of node 27 since it appears that a column leaving your node 26 contains empty values and this column is being mapped to a primary key column in your DB writer perhaps.

1 Like
3

Thx quaeler I have made a new topic