org.pentaho.di.core.exception.KettleValueException: COEFFICIENT String(2) : There was a data type error: the data type of java.lang.Double object [-1.0] does not correspond to value meta [String(2)]

Pentaho BI Platform Tracking | Thibault CRUCY | 8 years ago
  1. 0

    Am having problems with the attached transformation and tab-delimited input file. Any suggestions? Results when running with lazy conversion checked: 2008/06/17 16:49:56 - Read New DRG File.0 - Finished processing (I=746, O=0, R=0, W=745, U=0, E=0) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Error writing field (0,1) : org.pentaho.di.core.exception.KettleValueException: 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>] 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleValueException: 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>] 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1317) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:279) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeField(ExcelOutput.java:203) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.writeRowToFile(ExcelOutput.java:174) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.processRow(ExcelOutput.java:108) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444) 2008/06/17 16:49:56 - Excel Output.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.exceloutput.ExcelOutput.run(ExcelOutput.java:630) Results when running with lazy conversion unchecked: 2008/06/17 16:50:54 - Read New DRG File.0 - Starting to run... 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Unexpected error : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : org.pentaho.di.core.exception.KettleFileException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.openNextFile(CsvInput.java:312) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.processRow(CsvInput.java:96) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2444) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.run(CsvInput.java:641) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Caused by: org.pentaho.di.core.exception.KettleFileException: 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Exception reading line using NIO 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.readOneRow(CsvInput.java:557) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.openNextFile(CsvInput.java:292) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : ... 3 more 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : Caused by: java.lang.ArrayIndexOutOfBoundsException: -1 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : at org.pentaho.di.trans.steps.csvinput.CsvInput.readOneRow(CsvInput.java:544) 2008/06/17 16:50:54 - Read New DRG File.0 - ERROR (version 3.1.0-M2, build 709 from 2008/06/17 10:48:07) : ... 4 more

    Pentaho BI Platform Tracking | 9 years ago | kdikken
    org.pentaho.di.core.exception.KettleValueException: new_drg_code String<binary-string> : There was a data type error: the data type of java.lang.String object [1] does not correspond to value meta [String<binary-string>]
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 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]
  4. 0

    Filter component throws strange error; from the message there should not be a problem at all (see below). In the error message the two data types mentioned are identical and the value (country name) should be convertible as well >>>>>>>>>> 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : Unexpected error found in evaluation function : 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : Unexpected error : 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : org.pentaho.di.core.exception.KettleValueException: 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : country_name String(100)<binary-string> : There was a data type error: the data type of java.lang.String object [AFGHANISTAN] does not correspond to value meta [String(100)<binary-string>] 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : at org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1317) 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:181) 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : at org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:579) 2008/08/19 08:23:58 - Filter rows.0 - ERROR (version 3.1.0-RC1, build 771 from 2008/07/08 11:57:26) : at org.pentaho.di.trans.steps.filterrows.FilterRows.keepRow(FilterRows.java:51)

    Pentaho BI Platform Tracking | 8 years ago | Michal Riedmueller
    org.pentaho.di.core.exception.KettleValueException: country_name String(100)<binary-string> : There was a data type error: the data type of java.lang.String object [AFGHANISTAN] does not correspond to value meta [String(100)<binary-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. org.pentaho.di.core.exception.KettleValueException

      COEFFICIENT String(2) : There was a data type error: the data type of java.lang.Double object [-1.0] does not correspond to value meta [String(2)]

      at org.pentaho.di.core.row.ValueMeta.getString()
    2. org.pentaho.di
      BaseStep.runStepThread
      1. org.pentaho.di.core.row.ValueMeta.getString(ValueMeta.java:1322)
      2. org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:181)
      3. org.pentaho.di.core.row.RowMeta.getString(RowMeta.java:579)
      4. org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:377)
      5. org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
      5 frames