org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [id String] to an Integer id String : couldn't convert String to Integer id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba]

Pentaho BI Platform Tracking | Alexander | 2 years ago
  1. 0

    While adding row in database it generate a unique id(primiry key), of type uuid, consisting the characters. Generating function is uuid_generate_v1(). When i try to return the value of the generated id(enable checkbox "Return auto-generated key"), Kettle tries to convert it to integer and returns an error: "could not convert String to Integral." "2014/09/12 16:22:17 - Table output 2.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Because of an error, this step can't continue: 2014/09/12 16:22:17 - Table output 2.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - Unexpected conversion error while converting value [id String] to an Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1815) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.RowMeta.getInteger(RowMeta.java:254) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:312) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2014/09/12 16:22:17 - Table output 2.0 - at java.lang.Thread.run(Thread.java:745) 2014/09/12 16:22:17 - Table output 2.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1039) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1748) 2014/09/12 16:22:17 - Table output 2.0 - ... 5 more 2014/09/12 16:22:17 - Table output 2.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1031) 2014/09/12 16:22:17 - Table output 2.0 - ... 6 more"

    Pentaho BI Platform Tracking | 2 years ago | Alexander
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [id String] to an Integer id String : couldn't convert String to Integer id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba]
  2. 0

    While adding row in database it generate a unique id(primiry key), of type uuid, consisting the characters. Generating function is uuid_generate_v1(). When i try to return the value of the generated id(enable checkbox "Return auto-generated key"), Kettle tries to convert it to integer and returns an error: "could not convert String to Integral." "2014/09/12 16:22:17 - Table output 2.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : Because of an error, this step can't continue: 2014/09/12 16:22:17 - Table output 2.0 - ERROR (version 5.1.0.0, build 1 from 2014-06-19_19-02-57 by buildguy) : org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - Unexpected conversion error while converting value [id String] to an Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1815) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.RowMeta.getInteger(RowMeta.java:254) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:312) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2014/09/12 16:22:17 - Table output 2.0 - at java.lang.Thread.run(Thread.java:745) 2014/09/12 16:22:17 - Table output 2.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to Integer 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1039) 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:1748) 2014/09/12 16:22:17 - Table output 2.0 - ... 5 more 2014/09/12 16:22:17 - Table output 2.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 2014/09/12 16:22:17 - Table output 2.0 - id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba] 2014/09/12 16:22:17 - Table output 2.0 - 2014/09/12 16:22:17 - Table output 2.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1031) 2014/09/12 16:22:17 - Table output 2.0 - ... 6 more"

    Pentaho BI Platform Tracking | 2 years ago | Alexander
    org.pentaho.di.core.exception.KettleValueException: Unexpected conversion error while converting value [id String] to an Integer id String : couldn't convert String to Integer id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba]
  3. 0

    decimal mark - 必应

    bing.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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 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]

    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

      id String : couldn't convert String to number : non-numeric character found at position 1 for value [eeec091d-a056-4117-984c-74894ce644ba]

      at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger()
    2. org.pentaho.di
      ValueMetaBase.convertStringToInteger
      1. org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1031)
      1 frame