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

Pentaho BI Platform Tracking | Jens Bleuel | 9 years ago
  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 | 9 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 | 9 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 | 6 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 | 11 months 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. kid 2 times, last 1 month ago
  2. kuldeep 4 times, last 2 months ago
  3. mortalman7 1 times, last 5 months ago
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