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) :

Pentaho BI Platform Tracking | Wolfgang Schulze-Zachau | 9 years ago
  1. 0

    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.

    Pentaho BI Platform Tracking | 9 years ago | Wolfgang Schulze-Zachau
    org.pentaho.di.core.exception.KettleValueException: StartDate String : couldn't convert string [2000-01-01] to a date Unparseable date: "2000-01-01"
  2. 0

    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.

    Pentaho BI Platform Tracking | 9 years ago | Wolfgang Schulze-Zachau
    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) :
  3. 0

    Date Format for GTC?

    Oracle Community | 8 years ago | 645631
    java.text.ParseException: Unparseable date: "11/13/2006"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Gson java.sql.Date conversion Issue

    coderclubs.com | 11 months ago
    com.google.gson.JsonSyntaxException: java.text.ParseException: Unparseable date: "2014-09-26"
  6. 0

    "java.text.ParseException: Unparseable date" from Static

    GitHub | 2 years ago | geakstr
    java.text.ParseException: Unparseable date: "B, 12 A5= 2014 09:00:51 UTC"

  1. DoktorDoener666 1 times, last 2 weeks ago
  2. Alexandru Popa 1 times, last 2 weeks ago
  3. maxxi 1 times, last 1 month ago
  4. iridic 5 times, last 1 month ago
  5. ivotje50 33 times, last 1 month ago
23 more registered users
10 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. java.text.ParseException

    Unparseable date: "2000-01-01"

    at java.text.DateFormat.parse()
  2. Java RT
    DateFormat.parse
    1. java.text.DateFormat.parse(Unknown Source)
    1 frame
  3. org.pentaho.di
    SelectValues.run
    1. org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:549)
    2. org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1498)
    3. org.pentaho.di.trans.steps.selectvalues.SelectValues.metadataValues(SelectValues.java:304)
    4. org.pentaho.di.trans.steps.selectvalues.SelectValues.processRow(SelectValues.java:346)
    5. org.pentaho.di.trans.steps.selectvalues.SelectValues.run(SelectValues.java:406)
    5 frames