java.lang.ClassCastException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Running my transformation with kettle 2.5.x works, current svn trunk throws the following: 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : Unexpected error : 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1284) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2788) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2861) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:387) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246)
    via by Markus Kaemmerer,
  • Running my transformation with kettle 2.5.x works, current svn trunk throws the following: 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : Unexpected error : 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1284) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2788) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2861) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:387) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198) 2007/10/29 19:14:10 - Dimension lookup/update.0 - ERROR (version 3.0.0-RC2, build 11 from 2007/08/15 15:56:20) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246)
    via by Markus Kaemmerer,
  • SUMMARY: Adding the "Last version (without stream field as source)" dimension type incombination with both insert and punch through dimension fields causes the step to crash on second run. TO REPRODUCE: 1. Open dim_lookup_test_latestflag.ktr 2. Create empty table in PostgreSQL or MySQL as preferred 3. Run transformation (not that there are now four rows in the table) 4. Run transformation again EXPECTED RESULT No updates/changes made in table because source data (CSV file) is unchanged ACTUAL RESULT: Crash!! see logging below. 2009/10/06 15:25:16 - dim_lookup_latestflag - Dispatching started for transformation [dim_lookup_latestflag] 2009/10/06 15:25:16 - dim_lookup_latestflag - Natural sort of steps executed in 0ms (2 time previous steps calculated) 2009/10/06 15:25:16 - dim_lookup_latestflag - This transformation can be replayed with replay date: 2009/10/06 15:25:16 2009/10/06 15:25:16 - CSV file input.0 - Header row skipped in file 'file:///c:/colt/desktop/test/PDI/data1.txt' 2009/10/06 15:25:16 - CSV file input.0 - Finished processing (I=4, O=0, R=0, W=3, U=0, E=0) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Because of an error this step can't continue: 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : String(8)<binary-string> : Unable to compare with value [Date] 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Unable to verify if [CarOwner String(8)<binary-string>] is null or not because of an error:java.lang.ClassCastException: java.lang.String cannot be cast to [B 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : org.pentaho.di.core.exception.KettleValueException: 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : String(8)<binary-string> : Unable to compare with value [Date] 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Unable to verify if [CarOwner String(8)<binary-string>] is null or not because of an error:java.lang.ClassCastException: java.lang.String cannot be cast to [B 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:3025) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:522) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:202) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1594) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Caused by: java.lang.RuntimeException: Unable to verify if [CarOwner String(8)<binary-string>] is null or not because of an error:java.lang.ClassCastException: java.lang.String cannot be cast to [B 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.core.row.ValueMeta.isNull(ValueMeta.java:2834) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2869) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:3021) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : ... 4 more 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to [B 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : at org.pentaho.di.core.row.ValueMeta.isNull(ValueMeta.java:2813) 2009/10/06 15:25:16 - Dimension lookup/update.0 - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : ... 6 more 2009/10/06 15:25:16 - Dimension lookup/update.0 - Finished processing (I=1, O=0, R=1, W=0, U=0, E=1) 2009/10/06 15:25:16 - Spoon - The transformation has finished!! 2009/10/06 15:25:16 - dim_lookup_latestflag - ERROR (version 3.2.3 from 2009/10/06 15:12:56.522) : Errors detected! 2009/10/06 15:25:16 - dim_lookup_latestflag - Transformation detected one or more steps with errors. 2009/10/06 15:25:16 - dim_lookup_latestflag - Transformation is killing the other steps!
    via by Phillip Cole,
  • I am new to Kettle. I have a Kettle transformation that works flawlessly. When I edit one of the "Database Value Lookup" steps, and check "Load all data from table" (Enable cache was already checked), it doesn't work. Here is the log: 2009/10/15 18:56:56 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened. 2009/10/15 18:56:56 - Spoon - Launching transformation [generic]... 2009/10/15 18:56:56 - Spoon - Started the transformation execution. 2009/10/15 18:56:56 - generic - Dispatching started for transformation [generic] 2009/10/15 18:56:56 - generic - Natural sort of steps executed in 0ms (34 time previous steps calculated) 2009/10/15 18:56:56 - generic - This transformation can be replayed with replay date: 2009/10/15 18:56:56 2009/10/15 18:56:56 - Set category.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to buy-options.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Intermediate table.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to offline.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to products.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Couldn't compile javascript: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:289) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1427) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.createOriginalValue(ValueMeta.java:3301) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.RowMeta.createOriginalRow(RowMeta.java:845) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:196) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1372) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 6 more 2009/10/15 18:56:57 - calc fields.0 - Finished processing (I=0, O=0, R=1646, W=1645, U=0, E=0) 2009/10/15 18:56:57 - canonize GTIN.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2009/10/15 18:56:57 - generic - Transformation detected one or more steps with errors. 2009/10/15 18:56:57 - generic - Transformation is killing the other steps! 2009/10/15 18:56:57 - Table input.0 - Finished reading query, closing connection. 2009/10/15 18:56:57 - new fields.0 - Finished processing (I=0, O=0, R=3593, W=3593, U=0, E=0) 2009/10/15 18:56:57 - cleanup.0 - Finished processing (I=0, O=0, R=367, W=366, U=0, E=0) 2009/10/15 18:56:57 - get cat_id.0 - Finished processing (I=2217, O=0, R=146, W=146, U=0, E=0) 2009/10/15 18:56:57 - Table input.0 - Finished processing (I=3795, O=0, R=0, W=3793, U=0, E=0) 2009/10/15 18:56:57 - Spoon - The transformation has finished!! 2009/10/15 18:56:57 - generic - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
    via by Ron Gross,
  • I am new to Kettle. I have a Kettle transformation that works flawlessly. When I edit one of the "Database Value Lookup" steps, and check "Load all data from table" (Enable cache was already checked), it doesn't work. Here is the log: 2009/10/15 18:56:56 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened. 2009/10/15 18:56:56 - Spoon - Launching transformation [generic]... 2009/10/15 18:56:56 - Spoon - Started the transformation execution. 2009/10/15 18:56:56 - generic - Dispatching started for transformation [generic] 2009/10/15 18:56:56 - generic - Natural sort of steps executed in 0ms (34 time previous steps calculated) 2009/10/15 18:56:56 - generic - This transformation can be replayed with replay date: 2009/10/15 18:56:56 2009/10/15 18:56:56 - Set category.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to buy-options.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Intermediate table.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to offline.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to products.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Couldn't compile javascript: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:289) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1427) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.createOriginalValue(ValueMeta.java:3301) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.RowMeta.createOriginalRow(RowMeta.java:845) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:196) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1372) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 6 more 2009/10/15 18:56:57 - calc fields.0 - Finished processing (I=0, O=0, R=1646, W=1645, U=0, E=0) 2009/10/15 18:56:57 - canonize GTIN.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2009/10/15 18:56:57 - generic - Transformation detected one or more steps with errors. 2009/10/15 18:56:57 - generic - Transformation is killing the other steps! 2009/10/15 18:56:57 - Table input.0 - Finished reading query, closing connection. 2009/10/15 18:56:57 - new fields.0 - Finished processing (I=0, O=0, R=3593, W=3593, U=0, E=0) 2009/10/15 18:56:57 - cleanup.0 - Finished processing (I=0, O=0, R=367, W=366, U=0, E=0) 2009/10/15 18:56:57 - get cat_id.0 - Finished processing (I=2217, O=0, R=146, W=146, U=0, E=0) 2009/10/15 18:56:57 - Table input.0 - Finished processing (I=3795, O=0, R=0, W=3793, U=0, E=0) 2009/10/15 18:56:57 - Spoon - The transformation has finished!! 2009/10/15 18:56:57 - generic - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
    via by Alex K,
  • I am new to Kettle. I have a Kettle transformation that works flawlessly. When I edit one of the "Database Value Lookup" steps, and check "Load all data from table" (Enable cache was already checked), it doesn't work. Here is the log: 2009/10/15 18:56:56 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened. 2009/10/15 18:56:56 - Spoon - Launching transformation [generic]... 2009/10/15 18:56:56 - Spoon - Started the transformation execution. 2009/10/15 18:56:56 - generic - Dispatching started for transformation [generic] 2009/10/15 18:56:56 - generic - Natural sort of steps executed in 0ms (34 time previous steps calculated) 2009/10/15 18:56:56 - generic - This transformation can be replayed with replay date: 2009/10/15 18:56:56 2009/10/15 18:56:56 - Set category.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to buy-options.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Intermediate table.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to offline.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to products.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Couldn't compile javascript: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:289) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1427) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.createOriginalValue(ValueMeta.java:3301) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.RowMeta.createOriginalRow(RowMeta.java:845) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:196) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1372) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 6 more 2009/10/15 18:56:57 - calc fields.0 - Finished processing (I=0, O=0, R=1646, W=1645, U=0, E=0) 2009/10/15 18:56:57 - canonize GTIN.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2009/10/15 18:56:57 - generic - Transformation detected one or more steps with errors. 2009/10/15 18:56:57 - generic - Transformation is killing the other steps! 2009/10/15 18:56:57 - Table input.0 - Finished reading query, closing connection. 2009/10/15 18:56:57 - new fields.0 - Finished processing (I=0, O=0, R=3593, W=3593, U=0, E=0) 2009/10/15 18:56:57 - cleanup.0 - Finished processing (I=0, O=0, R=367, W=366, U=0, E=0) 2009/10/15 18:56:57 - get cat_id.0 - Finished processing (I=2217, O=0, R=146, W=146, U=0, E=0) 2009/10/15 18:56:57 - Table input.0 - Finished processing (I=3795, O=0, R=0, W=3793, U=0, E=0) 2009/10/15 18:56:57 - Spoon - The transformation has finished!! 2009/10/15 18:56:57 - generic - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
    via by Ron Gross,
  • I am new to Kettle. I have a Kettle transformation that works flawlessly. When I edit one of the "Database Value Lookup" steps, and check "Load all data from table" (Enable cache was already checked), it doesn't work. Here is the log: 2009/10/15 18:56:56 - org.pentaho.di.ui.spoon.trans.TransGraph - Transformation opened. 2009/10/15 18:56:56 - Spoon - Launching transformation [generic]... 2009/10/15 18:56:56 - Spoon - Started the transformation execution. 2009/10/15 18:56:56 - generic - Dispatching started for transformation [generic] 2009/10/15 18:56:56 - generic - Natural sort of steps executed in 0ms (34 time previous steps calculated) 2009/10/15 18:56:56 - generic - This transformation can be replayed with replay date: 2009/10/15 18:56:56 2009/10/15 18:56:56 - Set category.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to buy-options.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Intermediate table.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to offline.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:56 - Insert to products.0 - Connected to database [seeding] (commit=100) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected error : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Couldn't compile javascript: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:289) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleValueException: 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Unexpected conversion error while converting value [cat_id Number] to a Number 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1427) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.createOriginalValue(ValueMeta.java:3301) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.RowMeta.createOriginalRow(RowMeta.java:845) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:196) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 3 more 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1372) 2009/10/15 18:56:57 - canonize GTIN.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : ... 6 more 2009/10/15 18:56:57 - calc fields.0 - Finished processing (I=0, O=0, R=1646, W=1645, U=0, E=0) 2009/10/15 18:56:57 - canonize GTIN.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2009/10/15 18:56:57 - generic - Transformation detected one or more steps with errors. 2009/10/15 18:56:57 - generic - Transformation is killing the other steps! 2009/10/15 18:56:57 - Table input.0 - Finished reading query, closing connection. 2009/10/15 18:56:57 - new fields.0 - Finished processing (I=0, O=0, R=3593, W=3593, U=0, E=0) 2009/10/15 18:56:57 - cleanup.0 - Finished processing (I=0, O=0, R=367, W=366, U=0, E=0) 2009/10/15 18:56:57 - get cat_id.0 - Finished processing (I=2217, O=0, R=146, W=146, U=0, E=0) 2009/10/15 18:56:57 - Table input.0 - Finished processing (I=3795, O=0, R=0, W=3793, U=0, E=0) 2009/10/15 18:56:57 - Spoon - The transformation has finished!! 2009/10/15 18:56:57 - generic - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : Errors detected!
    via by Alex K,
    • java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double at org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1284) at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2788) at org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2861) at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:387) at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:198) at org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1246)
    No Bugmate found.