org.pentaho.di.core.exception.KettleValueException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Example transformation is attached. It consists of a simple table input, selecting the string '2000-01-01' into a field StartDate, then a SELECT step, which tries to convert this into a date. The conversion fails with this message: 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Unexpected error : 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : org.pentaho.di.core.exception.KettleValueException: 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : StartDate String : couldn't convert string [2000-01-01] to a date 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Unparseable date: "2000-01-01" 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:553) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1498) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.metadataValues(SelectValues.java:304) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:346) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.run(SelectValues.java:406) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Caused by: java.text.ParseException: Unparseable date: "2000-01-01" 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at java.text.DateFormat.parse(Unknown Source) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:549) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : ... 4 more Same behaviour on version 2.5.1, 2.5.2, 3.0.0RC1 and 3.0.0.RC2. '2000-01-01' is standard POSIX format and must be recognized by any string-to-date parser.
    via by Wolfgang Schulze-Zachau,
  • Example transformation is attached. It consists of a simple table input, selecting the string '2000-01-01' into a field StartDate, then a SELECT step, which tries to convert this into a date. The conversion fails with this message: 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Unexpected error : 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : org.pentaho.di.core.exception.KettleValueException: 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : StartDate String : couldn't convert string [2000-01-01] to a date 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Unparseable date: "2000-01-01" 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:553) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1498) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.metadataValues(SelectValues.java:304) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:346) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.trans.steps.selectvalues.SelectValues.run(SelectValues.java:406) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Caused by: java.text.ParseException: Unparseable date: "2000-01-01" 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at java.text.DateFormat.parse(Unknown Source) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:549) 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : ... 4 more Same behaviour on version 2.5.1, 2.5.2, 3.0.0RC1 and 3.0.0.RC2. '2000-01-01' is standard POSIX format and must be recognized by any string-to-date parser.
    via by Wolfgang Schulze-Zachau,
  • Date Format for GTC?
    via by 645631,
  • Gson java.sql.Date conversion Issue
    via by Unknown author,
  • date parse error
    via GitHub by anhalter42
    ,
    • org.pentaho.di.core.exception.KettleValueException: 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : StartDate String : couldn't convert string [2000-01-01] to a date 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : Unparseable date: "2000-01-01" 2007/10/25 18:05:39 - Select values.0 - ERROR (version 3.0.0-RC2, build 299029 from 2007/10/25 06:30:30) : at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:553) at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1498) at org.pentaho.di.trans.steps.selectvalues.SelectValues.metadataValues(SelectValues.java:304) at org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:346) at org.pentaho.di.trans.steps.selectvalues.SelectValues.run(SelectValues.java:406) Caused by: java.text.ParseException: Unparseable date: "2000-01-01" at java.text.DateFormat.parse(Unknown Source) at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:549) ... 4 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    derproggerderprogger
    271 times, last one,
    pulse00pulse00
    1 times, last one,
    oddodd
    1 times, last one,
    CasperCasper
    27 times, last one,
    41 more bugmates