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

Pentaho BI Platform Tracking | Jens Bleuel | 10 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error inserting row Duplicate entry '0' for key 1 ERROR 28-09 16:27:59,882 (LogWriter.java:println:394) -dimProduct.0 - 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

    Pentaho BI Platform Tracking | 10 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: Error inserting row Duplicate entry '0' for key 1
  2. 0

    Error inserting row Duplicate entry '0' for key 1 ERROR 28-09 16:27:59,882 (LogWriter.java:println:394) -dimProduct.0 - 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

    Pentaho BI Platform Tracking | 10 years ago | Jens Bleuel
    org.pentaho.di.core.exception.KettleDatabaseException: Error inserting row Duplicate entry '0' for key 1
  3. 0

    java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails

    Stack Overflow | 7 years ago | skip
    java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`springmvc/businesslocation`, CONSTRAINT `FK5CB747B5A26ED80E` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (Object Relational Mapping forum at JavaRanch)

    coderanch.com | 1 year ago
    java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails (`springmvc/businesslocation`, CONSTRAINT `FK5CB747B5A26ED80E` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`))
  6. 0

    The following error occurs when importing the attached large repository within Kettle's DB Repository org.pentaho.di.core.exception.KettleException: Unable to save directory [/import/folder 4/folder 3] in the repository Error inserting/updating row Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK' at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.saveRepositoryDirectory(KettleDatabaseRepositoryDirectoryDelegate.java:269) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.createRepositoryDirectory(KettleDatabaseRepositoryDirectoryDelegate.java:343) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.createRepositoryDirectory(KettleDatabaseRepository.java:474) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog.importTransformation(RepositoryImportProgressDialog.java:256) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog.transformationElementRead(RepositoryImportProgressDialog.java:568) at org.pentaho.di.ui.repository.dialog.RepositoryExportSaxParser.endElement(RepositoryExportSaxParser.java:83) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:277) at org.pentaho.di.ui.repository.dialog.RepositoryExportSaxParser.parse(RepositoryExportSaxParser.java:55) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog.importAll(RepositoryImportProgressDialog.java:549) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog.access$000(RepositoryImportProgressDialog.java:84) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog$3.run(RepositoryImportProgressDialog.java:191) at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.repository.dialog.RepositoryImportProgressDialog.open(RepositoryImportProgressDialog.java:196) at org.pentaho.di.ui.spoon.Spoon.importDirectoryToRepository(Spoon.java:4525) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:325) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27) at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77) at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1147) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6583) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:544) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error inserting/updating row Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK' at org.pentaho.di.core.database.Database.insertRow(Database.java:1381) at org.pentaho.di.core.database.Database.insertRow(Database.java:1295) at org.pentaho.di.core.database.Database.insertRow(Database.java:1283) at org.pentaho.di.core.database.Database.insertRow(Database.java:1266) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.insertDirectory(KettleDatabaseRepositoryDirectoryDelegate.java:132) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.saveRepositoryDirectory(KettleDatabaseRepositoryDirectoryDelegate.java:263) ... 48 more Caused by: java.sql.SQLException: Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK' 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:1330) ... 53 more

    Pentaho BI Platform Tracking | 7 years ago | Will Gorman
    org.pentaho.di.core.exception.KettleException: Unable to save directory [/import/folder 4/folder 3] in the repository Error inserting/updating row Duplicate entry '15-folder 3' for key 'IDX_DIRECTORY_AK'

  1. zbalint 2 times, last 2 weeks ago
  2. ivanszkypeter 4 times, last 3 weeks ago
  3. Hronom 1 times, last 4 months ago
  4. kid 2 times, last 7 months ago
  5. kuldeep 4 times, last 8 months ago
1 more registered users
32 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Duplicate entry '0' for key 1

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
    3. com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
    4. com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
    5. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
    7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
    7 frames
  3. org.pentaho.di
    DimensionLookup.run
    1. org.pentaho.di.core.database.Database.insertRow(Database.java:1260)
    2. org.pentaho.di.core.database.Database.insertRow(Database.java:1205)
    3. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.dimInsert(DimensionLookup.java:790)
    4. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:337)
    5. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198)
    6. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1249)
    6 frames