Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-1297

unable to load transformation from 3.0.2 based repository due to date format

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.0.2, 3.1.0 GA
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      repository runnning windows XP and PDI 3.0.2
      clients with PDI 3.1 on windows and PDI 3.0.2 on Linux
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      SuSE Enterprise 10, Windows XP

      Description

      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


        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sean.pieper Sean Pieper
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: