org.pentaho.di.core.exception.KettleDatabaseException

Error inserting row Duplicate entry '0' for key 1

Solutions on the web351

  • via Pentaho BI Platform Tracking by Jens Bleuel, 9 months ago
    Error inserting row Duplicate entry '0' for key 1
  • via Pentaho BI Platform Tracking by Jens Bleuel, 1 year ago
    Error inserting row Duplicate entry '0' for key 1
  • 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'
  • Stack trace

    • org.pentaho.di.core.exception.KettleDatabaseException: Error inserting row Duplicate entry '0' for key 1 at org.pentaho.di.core.database.Database.insertRow(Database.java:1310) 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) Caused by: 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) ... 5 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    3 times, 3 weeks ago
    Once, 1 month ago
    Once, 1 month ago
    2 times, 2 months ago
    4 times, 2 months ago
    42 more bugmates