java.lang.ClassCastException: java.lang.String cannot be cast to [B

Pentaho BI Platform Tracking | Phillip Cole | 7 years ago
  1. 0

    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!

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.lang.ClassCastException: java.lang.String cannot be cast to [B
  2. 0

    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!

    Pentaho BI Platform Tracking | 7 years ago | Phillip Cole
    java.lang.ClassCastException: java.lang.String cannot be cast to [B
  3. 0

    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)

    Pentaho BI Platform Tracking | 9 years ago | Markus Kaemmerer
    java.lang.ClassCastException: 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

    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)

    Pentaho BI Platform Tracking | 9 years ago | Markus Kaemmerer
    java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Double
  6. 0

    ClassCastException when trying to (string)args received

    GitHub | 2 years ago | dimitrilahaye
    java.lang.ClassCastException: [B cannot be cast to java.lang.String

    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.String cannot be cast to [B

      at org.pentaho.di.core.row.ValueMeta.isNull()
    2. org.pentaho.di
      DimensionLookup.run
      1. org.pentaho.di.core.row.ValueMeta.isNull(ValueMeta.java:2813)
      2. org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:2869)
      3. org.pentaho.di.core.row.ValueMeta.compare(ValueMeta.java:3021)
      4. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:522)
      5. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:202)
      6. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2889)
      7. org.pentaho.di.trans.steps.dimensionlookup.DimensionLookup.run(DimensionLookup.java:1594)
      7 frames