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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 1 year 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. Hronom 52 times, last 1 month ago
  2. DoktorDoener666 1 times, last 3 months ago
  3. Alexandru Popa 1 times, last 3 months ago
  4. maxxi 8 times, last 3 months ago
  5. iridic 5 times, last 4 months ago
23 more registered users
11 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