java.lang.IllegalArgumentException: Could not parse date: Unparseable date: "2008-09-23"

Oracle Community | 793177 | 5 years ago
  1. 0

    OIA import user from file (EndDate issue)

    Oracle Community | 5 years ago | 793177
    java.lang.IllegalArgumentException: Could not parse date: Unparseable date: "2008-09-23"
  2. 0

    developed a transformation on 3.0.2, saved it, and now I can't load it. Tried opening with 3.1, and also with 3.0.1, but no luck. The transformation was still very "in progress" when I saved, and I would not expect it to execute successfully (full of bugs and uninitialized steps). I'm guessing the culprit is a filter rows step that I added where I checked for a date field before 2007-12-20. Not sure whether PDI was unhappy from all the other bad things I was doing and didn't manage to check that my date format was good or if it just didn't save the right format for use, but either way it's no good. I'd be happy to send the transformation in if it would help debugging, but I'm not sure how to get at it now. Anyway, here's the error according to 3.1 (seems a little more informative than the error from 3.0.2) ---- An error occured reading a transformation from the repository Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" ---- Details: --- java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3420) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3387) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42) at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52) at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117) at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77) at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:921) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6189) at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:6285) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:397) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2473) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2309) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77) ... 28 more Caused by: org.pentaho.di.core.exception.KettleException: Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.trans.steps.filterrows.FilterRowsMeta.readRep(FilterRowsMeta.java:340) at org.pentaho.di.trans.step.StepMeta.<init>(StepMeta.java:632) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2381) ... 30 more Caused by: org.pentaho.di.core.exception.KettleException: Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.core.Condition.<init>(Condition.java:848) at org.pentaho.di.trans.steps.filterrows.FilterRowsMeta.readRep(FilterRowsMeta.java:295) ... 32 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.repository.RepositoryUtil.loadValueMetaAndData(RepositoryUtil.java:210) at org.pentaho.di.core.Condition.<init>(Condition.java:829) ... 33 more Caused by: org.pentaho.di.core.exception.KettleValueException: constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:594) at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1619) at org.pentaho.di.core.row.ValueMeta.convertDataUsingConversionMetaData(ValueMeta.java:3056) at org.pentaho.di.repository.RepositoryUtil.loadValueMetaAndData(RepositoryUtil.java:197) ... 34 more Caused by: java.text.ParseException: Unparseable date: "2007-12-20" at java.text.DateFormat.parse(Unknown Source) at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:589) ... 37 more -----

    Pentaho BI Platform Tracking | 9 years ago | Sean Pieper
    java.lang.reflect.InvocationTargetException: Error loading transformation
  3. 0

    developed a transformation on 3.0.2, saved it, and now I can't load it. Tried opening with 3.1, and also with 3.0.1, but no luck. The transformation was still very "in progress" when I saved, and I would not expect it to execute successfully (full of bugs and uninitialized steps). I'm guessing the culprit is a filter rows step that I added where I checked for a date field before 2007-12-20. Not sure whether PDI was unhappy from all the other bad things I was doing and didn't manage to check that my date format was good or if it just didn't save the right format for use, but either way it's no good. I'd be happy to send the transformation in if it would help debugging, but I'm not sure how to get at it now. Anyway, here's the error according to 3.1 (seems a little more informative than the error from 3.0.2) ---- An error occured reading a transformation from the repository Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" ---- Details: --- java.lang.reflect.InvocationTargetException: Error loading transformation at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:81) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313) at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3420) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3387) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42) at org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52) at org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117) at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77) at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:921) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6189) at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:6285) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:397) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116) Caused by: org.pentaho.di.core.exception.KettleException: An error occured reading a transformation from the repository Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2473) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2309) at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77) ... 28 more Caused by: org.pentaho.di.core.exception.KettleException: Unexpected error reading step information from the repository Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.trans.steps.filterrows.FilterRowsMeta.readRep(FilterRowsMeta.java:340) at org.pentaho.di.trans.step.StepMeta.<init>(StepMeta.java:632) at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2381) ... 30 more Caused by: org.pentaho.di.core.exception.KettleException: Error loading condition from the repository (id_condition=14) Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.core.Condition.<init>(Condition.java:848) at org.pentaho.di.trans.steps.filterrows.FilterRowsMeta.readRep(FilterRowsMeta.java:295) ... 32 more Caused by: org.pentaho.di.core.exception.KettleException: Unable to load Value from repository with id_value=13 constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.repository.RepositoryUtil.loadValueMetaAndData(RepositoryUtil.java:210) at org.pentaho.di.core.Condition.<init>(Condition.java:829) ... 33 more Caused by: org.pentaho.di.core.exception.KettleValueException: constant String : couldn't convert string [2007-12-20] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] Unparseable date: "2007-12-20" at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:594) at org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1619) at org.pentaho.di.core.row.ValueMeta.convertDataUsingConversionMetaData(ValueMeta.java:3056) at org.pentaho.di.repository.RepositoryUtil.loadValueMetaAndData(RepositoryUtil.java:197) ... 34 more Caused by: java.text.ParseException: Unparseable date: "2007-12-20" at java.text.DateFormat.parse(Unknown Source) at org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:589) ... 37 more -----

    Pentaho BI Platform Tracking | 9 years ago | Sean Pieper
    java.lang.reflect.InvocationTargetException: Error loading transformation
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SimpleDateFormat is not thread safe

    GitHub | 4 years ago | dkocher
    java.text.ParseException: Unparseable date: &quot;2011-09-02T09:37:03Z&quot;

  1. DoktorDoener666 1 times, last 2 weeks ago
  2. Alexandru Popa 1 times, last 3 weeks ago
  3. maxxi 8 times, last 4 days 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: "2008-09-23"

    at java.text.DateFormat.parse()
  2. Java RT
    DateFormat.parse
    1. java.text.DateFormat.parse(DateFormat.java:337)
    1 frame
  3. Spring Beans
    AbstractPropertyAccessor.setPropertyValues
    1. org.springframework.beans.propertyeditors.CustomDateEditor.setAsText(CustomDateEditor.java:106)
    2. org.springframework.beans.TypeConverterDelegate.doConvertTextValue(TypeConverterDelegate.java:382)
    3. org.springframework.beans.TypeConverterDelegate.doConvertValue(TypeConverterDelegate.java:358)
    4. org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:173)
    5. org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:138)
    6. org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:832)
    7. org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:651)
    8. org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:78)
    9. org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
    10. org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:55)
    10 frames
  4. com.vaau.rbacx
    AbstractFileReader.run
    1. com.vaau.rbacx.iam.file.csv.UserFileReader.createGlobalUser(UserFileReader.java:315)
    2. com.vaau.rbacx.iam.file.csv.UserFileReader.readInternal(UserFileReader.java:115)
    3. com.vaau.rbacx.iam.file.support.AbstractFileReader.read(AbstractFileReader.java:138)
    4. com.vaau.rbacx.iam.file.support.AbstractFileReader.run(AbstractFileReader.java:79)
    4 frames
  5. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    3. java.lang.Thread.run(Thread.java:619)
    3 frames