java.lang.reflect.InvocationTargetException: Error loading transformation

Pentaho BI Platform Tracking | Sean Pieper | 9 years ago
  1. 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
  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

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

    Automated exception search integrated into your IDE

  5. 0

    Gson java.sql.Date conversion Issue

    coderclubs.com | 12 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 8 times, last 2 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: "2007-12-20"

    at java.text.DateFormat.parse()
  2. Java RT
    DateFormat.parse
    1. java.text.DateFormat.parse(Unknown Source)
    1 frame
  3. org.pentaho.di
    TransLoadProgressDialog$1.run
    1. org.pentaho.di.core.row.ValueMeta.convertStringToDate(ValueMeta.java:589)
    2. org.pentaho.di.core.row.ValueMeta.getDate(ValueMeta.java:1619)
    3. org.pentaho.di.core.row.ValueMeta.convertDataUsingConversionMetaData(ValueMeta.java:3056)
    4. org.pentaho.di.repository.RepositoryUtil.loadValueMetaAndData(RepositoryUtil.java:197)
    5. org.pentaho.di.core.Condition.<init>(Condition.java:829)
    6. org.pentaho.di.trans.steps.filterrows.FilterRowsMeta.readRep(FilterRowsMeta.java:295)
    7. org.pentaho.di.trans.step.StepMeta.<init>(StepMeta.java:632)
    8. org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2381)
    9. org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2309)
    10. org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:77)
    10 frames
  4. JFace
    ProgressMonitorDialog.run
    1. org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
    2. org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
    3. org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495)
    3 frames
  5. org.pentaho.di
    Spoon.openFile
    1. org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:89)
    2. org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3420)
    3. org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3387)
    3 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  7. org.pentaho.xul
    MenuChoice.handleEvent
    1. org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
    2. org.pentaho.xul.swt.menu.MenuBar.handleMenuEvent(MenuBar.java:52)
    3. org.pentaho.xul.swt.menu.Menu.handleMenuEvent(Menu.java:117)
    4. org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
    5. org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
    5 frames
  8. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    2. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    4 frames
  9. org.pentaho.di
    Spoon.main
    1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:921)
    2. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6189)
    3. org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:6285)
    4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:397)
    4 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  11. org.pentaho.commons
    Launcher.main
    1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
    1 frame