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

PDI 5.4 Error using ETL Metadata Injection Step in Database Repository

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Duplicate
    • Affects Version/s: 5.4.0 GA
    • Fix Version/s: None
    • Component/s: Repository (Database), Step
    • Labels:
      None
    • Environment:
      Database Repository on MySQL Community Server 5.5.8
    • Story Points:
      0
    • PDI Sub-component:
    • 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:
      Windows 7 (64-bit)
    • Steps to Reproduce:
      Hide

      1) Create in a database repository a transformation that injects metadata to a row denormalizer step.
      2) Run the transformation and error appears.

      Show
      1) Create in a database repository a transformation that injects metadata to a row denormalizer step. 2) Run the transformation and error appears.

      Description

      I have created a transformation that injects metadata to a row denormalizer step using PDI 5.4
      The transformation works perfectly when I am saving the files as .ktr, but if I create and save exactly the same in a database repository I obtain an error when running.
      If I close the transformation in the database repository I obtain as well an error and it's not possible to open it.

      Both error logs contain: ArrayIndexOutOfBoundsException

      I am attaching the ktr files for your review.
      EDIT: Sorry, I'm not being able to upload the file. Tried with .zip .ktr in Chrome and Mozilla and the file doesn't attach.
      Is it another bug or just me, nothing working today?

      Maybe something related to this bug came back:
      PDI-9152

      Error Log when running:

      org.pentaho.di.core.exception.KettleException:
      Transformation was unable to open [MetaInject 1]

      An error occured reading a transformation from the repository

      at org.pentaho.di.trans.Trans.<init>(Trans.java:592)
      at org.pentaho.di.ui.spoon.trans.TransGraph.start(TransGraph.java:3639)
      at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:880)
      at org.pentaho.di.ui.spoon.Spoon$31$1.run(Spoon.java:8464)
      at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
      at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319)
      at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
      at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190)
      at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)
      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:92)
      Caused by: org.pentaho.di.core.exception.KettleException:
      An error occured reading a transformation from the repository

      at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669)
      at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278)
      at org.pentaho.di.trans.Trans.<init>(Trans.java:568)
      ... 16 more
      Caused by: java.lang.ArrayIndexOutOfBoundsException

      Error log when opening:
      java.lang.reflect.InvocationTargetException: Error loading transformation
      at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:97)
      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:105)
      at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4237)
      at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4159)
      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.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
      at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
      at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
      at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton.access$100(SwtToolbarbutton.java:48)
      at org.pentaho.ui.xul.swt.tags.SwtToolbarbutton$1.widgetSelected(SwtToolbarbutton.java:96)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      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:1319)
      at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
      at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190)
      at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)
      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:92)
      Caused by: org.pentaho.di.core.exception.KettleException:
      An error occured reading a transformation from the repository

      at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:669)
      at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:278)
      at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:92)
      ... 29 more
      Caused by: java.lang.ArrayIndexOutOfBoundsException

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              azucena@panalysis.com Azucena Coronel
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: