org.pentaho.di.core.exception.KettleDatabaseException: Error inserting row Duplicate entry '0' for key 1

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Pentaho BI Platform Tracking by Jens Bleuel, 1 year ago
via Pentaho BI Platform Tracking by Jens Bleuel, 1 year ago
via Pentaho BI Platform Tracking by Cor Winckler, 1 year ago
2008/03/25 16:36:36 - LKU_MSISDN_FROM.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Error inserting row 2008/03/25 16:36:36 - LKU_MSISDN_FROM.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : ORA-00001: unique
via Pentaho BI Platform Tracking by Will Gorman, 1 year ago
Error inserting/updating row Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK'
via Pentaho BI Platform Tracking by Will Gorman, 1 year ago
Error inserting/updating row Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK'
via Stack Overflow by Jais Anasrulloh Ja'fari
, 5 months ago
2017/08/16 15:13:02 - Table output.0 - Error inserting/updating row 2017/08/16 15:13:02 - Table output.0 - Duplicate entry 'sonar.id' for key 'index_dashboard_domains_on_domain' 2017/08/16 15:13:02 - Table output.0 - 2017/08/16 15:13:02 - Table output.0 -
java.sql.SQLException: Duplicate entry '0' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
at org.pentaho.di.core.database.Database.insertRow(Database.java:1260)
at org.pentaho.di.core.database.Database.insertRow(Database.java:1205)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert(DimensionLookup.java:790)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:337)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198)
at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1249)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.