org.pentaho.di.core.exception.KettleValueException: islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean]

Pentaho BI Platform Tracking | Bryce Lobdell | 4 years ago
  1. 0

    presence of "Identify last row in a stream" seems to cause an exception in Mapreduce reducer transformation. The column emitted by the "Identify last row" step is called islastrow. It is not referenced anywhere else in the transformation. Upon deleting the "identify last row" step the mapreduce job completes without incident. Reducer is NOT run single threaded. The exception is as follows: FAILED java.io.IOException: java.lang.Exception: Errors were detected for reducer/combiner transformation: Identify last row in a stream - Unexpected error Identify last row in a stream - org.pentaho.di.core.exception.KettleValueException: islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean] at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1368) at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:194) at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:615) at org.pentaho.di.trans.steps.detectlastrow.DetectLastRow.processRow(DetectLastRow.java:89) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) at java.lang.Thread.run(Thread.java:662) ua-points-reducer - Errors detected! at org.pentaho.hadoop.mapreduce.GenericTransReduce.printException(GenericTransReduce.java:188) at org.pentaho.hadoop.mapreduce.GenericTransReduce.reduce(GenericTransReduce.java:178) at org.pentaho.hadoop.mapreduce

    Pentaho BI Platform Tracking | 4 years ago | Bryce Lobdell
    org.pentaho.di.core.exception.KettleValueException: islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean]
  2. 0

    presence of "Identify last row in a stream" seems to cause an exception in Mapreduce reducer transformation. The column emitted by the "Identify last row" step is called islastrow. It is not referenced anywhere else in the transformation. Upon deleting the "identify last row" step the mapreduce job completes without incident. Reducer is NOT run single threaded. The exception is as follows: FAILED java.io.IOException: java.lang.Exception: Errors were detected for reducer/combiner transformation: Identify last row in a stream - Unexpected error Identify last row in a stream - org.pentaho.di.core.exception.KettleValueException: islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean] at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1368) at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:194) at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:615) at org.pentaho.di.trans.steps.detectlastrow.DetectLastRow.processRow(DetectLastRow.java:89) at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50) at java.lang.Thread.run(Thread.java:662) ua-points-reducer - Errors detected! at org.pentaho.hadoop.mapreduce.GenericTransReduce.printException(GenericTransReduce.java:188) at org.pentaho.hadoop.mapreduce.GenericTransReduce.reduce(GenericTransReduce.java:178) at org.pentaho.hadoop.mapreduce

    Pentaho BI Platform Tracking | 4 years ago | Bryce Lobdell
    org.pentaho.di.core.exception.KettleValueException: islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean]
  3. 0

    Kettle - Read CSV with comma as decimal mark

    Stack Overflow | 2 years ago | LeonardoSibela
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [codigo_cliente String<binary-string>] to an Integer codigo_cliente String<binary-string> : couldn't convert String to Integer codigo_cliente String<binary-string> : couldn't convert String to number : non-numeric character found at position 7 for value [21.237,00]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [PDI-795] Unexpected conversion error while converting value - Pentaho BI Platform Tracking

    pentaho.com | 12 months ago
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value to an Integer Unexpected conversion error while converting value to an Integer
  6. 0

    Linux - Kettle - Read CSV with comma as decimal mark

    howtobuildsoftware.com | 12 months ago
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [codigo_cliente String<binary-string>] to an Integer codigo_cliente String<binary-string> : couldn't convert String to Integer codigo_cliente String<binary-string> : couldn't convert String to number : non-numeric character found at position 7 for value [21.237,00]

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

      islastrow Boolean : There was a data type error: the data type of java.lang.String object [Y] does not correspond to value meta [Boolean]

      at org.pentaho.di.core.row.ValueMeta.getString()
    2. org.pentaho.di
      RunThread.run
      1. org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1368)
      2. org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:194)
      3. org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:615)
      4. org.pentaho.di.trans.steps.detectlastrow.DetectLastRow.processRow(DetectLastRow.java:89)
      5. org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      5 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame