org.pentaho.di.core.exception.KettleDatabaseException: Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008]

Pentaho BI Platform Tracking | Maxx Awada | 7 years ago
  1. 0

    I've configured Spoon as well as ERP and POS such that: a) All Synchronization Job is working just fine. b) Orders Job is working fine (AT THE BEGINNING ie. with fresh database (no items sold) But when I Test-Sell a product, Executing Orders results in this: 1st - Error on "Update" step 2nd - error logging (Mentioned at the bottom of the description) 3rd - The items in the POS inventory show: a) Main Warehouse = 20 products which is my original number of products b) General Warehouse = -2 which is the number of items I've sold (which shouldn't happen I believe) 4th - In the "Import Data" section in ERP: a)Two Items are shown (the ones I sold using POS) b)Processing them results in creating the same products, in the same warehouse (Main Warehouse) with the number -2 (as their count) c)Same used products in the Main warehouse (the original 20) seem to be intact. Stock Report: Product-Category1 Article Quantity Unit Attribute X Y Z Other unit Warehouse Product1 20,00 Unit 100 100 10 20,00 Unit Main Warehouse Product1 -2,00 Unit 100 100 10 Main Warehouse 5th - When I execute Orders AGAIN, without altering the POS with any new purchases Two new products are shown in the Import Data (Same as the ones before but not processed) and this goes on forever, the more I execute Orders the more items there is in Import Data (this shouldn't happen as well) This problem has been driving me crazy for the past 4 days or so, I'd appreciate any true help Thanks... Error Log for Orders Job: 2010/03/23 10:58:32 - ORDERS - Dispatching started for transformation [ORDERS] 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Error in step, asking everyone to stop because of: 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : org.pentaho.di.core.exception.KettleDatabaseException: 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008] 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.lookupValues(Update.java:111) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.processRow(Update.java:248) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.run(Update.java:469) 2010/03/23 10:58:33 - ORDERS - Transformation detected one or more steps with errors. 2010/03/23 10:58:33 - ORDERS - Transformation is killing the other steps! 2010/03/23 10:58:33 - Spoon - The transformation has finished!! Any other information you require to help, please comment or contact me on: mia@starlinkqatar.com Thanks!

    Pentaho BI Platform Tracking | 7 years ago | Maxx Awada
    org.pentaho.di.core.exception.KettleDatabaseException: Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008]
  2. 0

    I've configured Spoon as well as ERP and POS such that: a) All Synchronization Job is working just fine. b) Orders Job is working fine (AT THE BEGINNING ie. with fresh database (no items sold) But when I Test-Sell a product, Executing Orders results in this: 1st - Error on "Update" step 2nd - error logging (Mentioned at the bottom of the description) 3rd - The items in the POS inventory show: a) Main Warehouse = 20 products which is my original number of products b) General Warehouse = -2 which is the number of items I've sold (which shouldn't happen I believe) 4th - In the "Import Data" section in ERP: a)Two Items are shown (the ones I sold using POS) b)Processing them results in creating the same products, in the same warehouse (Main Warehouse) with the number -2 (as their count) c)Same used products in the Main warehouse (the original 20) seem to be intact. Stock Report: Product-Category1 Article Quantity Unit Attribute X Y Z Other unit Warehouse Product1 20,00 Unit 100 100 10 20,00 Unit Main Warehouse Product1 -2,00 Unit 100 100 10 Main Warehouse 5th - When I execute Orders AGAIN, without altering the POS with any new purchases Two new products are shown in the Import Data (Same as the ones before but not processed) and this goes on forever, the more I execute Orders the more items there is in Import Data (this shouldn't happen as well) This problem has been driving me crazy for the past 4 days or so, I'd appreciate any true help Thanks... Error Log for Orders Job: 2010/03/23 10:58:32 - ORDERS - Dispatching started for transformation [ORDERS] 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Error in step, asking everyone to stop because of: 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : org.pentaho.di.core.exception.KettleDatabaseException: 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008] 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.lookupValues(Update.java:111) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.processRow(Update.java:248) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664) 2010/03/23 10:58:33 - Update.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : at org.pentaho.di.trans.steps.update.Update.run(Update.java:469) 2010/03/23 10:58:33 - ORDERS - Transformation detected one or more steps with errors. 2010/03/23 10:58:33 - ORDERS - Transformation is killing the other steps! 2010/03/23 10:58:33 - Spoon - The transformation has finished!! Any other information you require to help, please comment or contact me on: mia@starlinkqatar.com Thanks!

    Pentaho BI Platform Tracking | 7 years ago | Maxx Awada
    org.pentaho.di.core.exception.KettleDatabaseException: Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008]
  3. 0

    See attached ktr. Simple mondrian input. If I use replace variables it causes this exception. Same query but without variable replacement works fine. {noformat} 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Unexpected error 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : org.pentaho.di.core.exception.KettleDatabaseException: 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : Unhandled data type found 'class mondrian.olap.fun.MondrianEvaluationException' 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.steps.mondrianinput.MondrianHelper.createRectangularOutput(MondrianHelper.java:237) 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.steps.mondrianinput.MondrianInput.processRow(MondrianInput.java:54) 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40) 2011/05/10 09:15:02 - Get Budget.0 - ERROR (version 4.2.0-M1, build 15030 from 2011-04-13 17.23.00 by tomcat) : at java.lang.Thread.run(Thread.java:662) {noformat}

    Pentaho BI Platform Tracking | 6 years ago | Dan Keeley (codek)
    org.pentaho.di.core.exception.KettleDatabaseException: Unhandled data type found 'class mondrian.olap.fun.MondrianEvaluationException'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Value '0000-00-0' can not be represented as java.sql.Date

    Google Groups | 2 years ago | Tomo Suryolaksono
    org.pentaho.di.core.exception.KettleDatabaseException: 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Couldn't get row from result set 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : Value '0000-00-00' can not be represented as java.sql.Timestamp 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 11:32:36) : 2014/10/30 10:19:47 - Transaksi.0 - ERROR (version 3.1.0, build 826 from
  6. 0

    Apache thrift transportaion TTransportException error while using Hive data integration using Pentaho

    Stack Overflow | 2 years ago | Jiten Patel
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database</p> <p>Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver) org.apache.thrift.transport.TTransportException</p> <pre><code>at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)

    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. org.pentaho.di.core.exception.KettleDatabaseException

      Entry to update with following key could not be found: [ 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008]

      at org.pentaho.di.trans.steps.update.Update.lookupValues()
    2. org.pentaho.di
      Update.run
      1. org.pentaho.di.trans.steps.update.Update.lookupValues(Update.java:111)
      2. org.pentaho.di.trans.steps.update.Update.processRow(Update.java:248)
      3. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
      4. org.pentaho.di.trans.steps.update.Update.run(Update.java:469)
      4 frames