org.pentaho.di.core.exception.KettleValueException: Couldn't compile javascript: Unexpected conversion error while converting value [cat_id Number] to a Number java.lang.Long cannot be cast to java.lang.Double

Pentaho BI Platform Tracking | Ron Gross | 7 years ago
  1. 0

    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!

    Pentaho BI Platform Tracking | 7 years ago | Ron Gross
    org.pentaho.di.core.exception.KettleValueException: Couldn't compile javascript: Unexpected conversion error while converting value [cat_id Number] to a Number java.lang.Long cannot be cast to java.lang.Double
  2. 0

    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!

    Pentaho BI Platform Tracking | 6 years ago | Alex K
    org.pentaho.di.core.exception.KettleValueException: Couldn't compile javascript: Unexpected conversion error while converting value [cat_id Number] to a Number java.lang.Long cannot be cast to java.lang.Double
  3. 0

    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!

    Pentaho BI Platform Tracking | 7 years ago | Ron Gross
    org.pentaho.di.core.exception.KettleValueException: Couldn't compile javascript: Unexpected conversion error while converting value [cat_id Number] to a Number java.lang.Long cannot be cast to java.lang.Double
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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!

    Pentaho BI Platform Tracking | 6 years ago | Alex K
    org.pentaho.di.core.exception.KettleValueException: Couldn't compile javascript: Unexpected conversion error while converting value [cat_id Number] to a Number java.lang.Long cannot be cast to java.lang.Double
  6. 0

    getting error while scrolling the webpage

    GitHub | 2 months ago | vishruth143
    java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Long

    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.lang.ClassCastException

      java.lang.Long cannot be cast to java.lang.Double

      at org.pentaho.di.core.row.ValueMeta.getNumber()
    2. org.pentaho.di
      ScriptValuesMod.run
      1. org.pentaho.di.core.row.ValueMeta.getNumber(ValueMeta.java:1372)
      2. org.pentaho.di.core.row.ValueMeta.createOriginalValue(ValueMeta.java:3301)
      3. org.pentaho.di.core.row.RowMeta.createOriginalRow(RowMeta.java:845)
      4. org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:196)
      5. org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:667)
      6. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
      7. org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.run(ScriptValuesMod.java:730)
      7 frames