org.pentaho.di.core.exception.KettleException: Unexpected error during transformation metadata load No repository defined!

Pentaho BI Platform Tracking | Dan Keeley (codek) | 3 years ago
  1. 0

    Open a transformation which uses "Get repository names" step when not connected to a repository and it crashes. I'd have at least expected it to open with a warning or something? In the same way that if you open a transformation which references a plugin you havent got installed etc. org.pentaho.di.core.exception.KettleException: Unexpected error during transformation metadata load No repository defined! at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1212) at org.pentaho.di.job.entries.trans.JobEntryTrans.loadReferencedObject(JobEntryTrans.java:1482) at org.pentaho.di.ui.spoon.job.JobGraph.loadReferencedObject(JobGraph.java:2316) at org.pentaho.di.ui.spoon.job.JobGraph$12.run(JobGraph.java:1780) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) 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:1227) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625) 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:134) Caused by: org.pentaho.di.core.exception.KettleException: No repository defined! at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1183) ... 20 more

    Pentaho BI Platform Tracking | 3 years ago | Dan Keeley (codek)
    org.pentaho.di.core.exception.KettleException: Unexpected error during transformation metadata load No repository defined!
  2. 0

    Open a transformation which uses "Get repository names" step when not connected to a repository and it crashes. I'd have at least expected it to open with a warning or something? In the same way that if you open a transformation which references a plugin you havent got installed etc. org.pentaho.di.core.exception.KettleException: Unexpected error during transformation metadata load No repository defined! at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1212) at org.pentaho.di.job.entries.trans.JobEntryTrans.loadReferencedObject(JobEntryTrans.java:1482) at org.pentaho.di.ui.spoon.job.JobGraph.loadReferencedObject(JobGraph.java:2316) at org.pentaho.di.ui.spoon.job.JobGraph$12.run(JobGraph.java:1780) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) 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:1227) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625) 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:134) Caused by: org.pentaho.di.core.exception.KettleException: No repository defined! at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1183) ... 20 more

    Pentaho BI Platform Tracking | 3 years ago | Dan Keeley (codek)
    org.pentaho.di.core.exception.KettleException: Unexpected error during transformation metadata load No repository defined!
  3. 0

    1. Download and unpack Kettle 2. Run start-servers.sh 3. Run spoon.sh 4. Create a DB-based repository 5. Quit Kettle 6. Delete the pdi-ee directory (remove Kettle, in other words) 7. Reinstall Kettle (or unpack a new PDI build) 8. Start the new instance of Kettle 9. The old repository you created is visible in the repo list upon startup 10. Select the old repository, then click the Delete button Result: The old repository is not removed from the list, and the following error occurs (the repository listing is in fact removed, but it stays in the list; restart Kettle and you'll see that it no longer appears): INFO 29-03 10:53:42,528 - SetElements on listbox called: collection has 1 rows Changed to: file:///home/valour/Desktop/pdi-ee/data-integration/docs/English/welcome/kettle_document_map.html org.pentaho.di.core.exception.KettleException: Error connecting to the repository! No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:141) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:173) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:163) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:211) at org.pentaho.di.ui.repository.controllers.RepositoriesController.login(RepositoriesController.java:137) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtTextbox.access$300(SwtTextbox.java:21) at org.pentaho.ui.xul.swt.tags.SwtTextbox$2.handleEvent(SwtTextbox.java:70) 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.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:313) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:265) at org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:79) at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6209) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6357) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:539) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: org.pentaho.di.core.exception.KettleException: No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:191) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:120) ... 30 more DEBUG 29-03 10:54:26,451 - updateMenu called. schedulingEnabled is false

    Pentaho BI Platform Tracking | 7 years ago | Jem Matzan
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    1. Download and unpack Kettle 2. Run start-servers.sh 3. Run spoon.sh 4. Create a DB-based repository 5. Quit Kettle 6. Delete the pdi-ee directory (remove Kettle, in other words) 7. Reinstall Kettle (or unpack a new PDI build) 8. Start the new instance of Kettle 9. The old repository you created is visible in the repo list upon startup 10. Select the old repository, then click the Delete button Result: The old repository is not removed from the list, and the following error occurs (the repository listing is in fact removed, but it stays in the list; restart Kettle and you'll see that it no longer appears): INFO 29-03 10:53:42,528 - SetElements on listbox called: collection has 1 rows Changed to: file:///home/valour/Desktop/pdi-ee/data-integration/docs/English/welcome/kettle_document_map.html org.pentaho.di.core.exception.KettleException: Error connecting to the repository! No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:141) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:173) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:163) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:211) at org.pentaho.di.ui.repository.controllers.RepositoriesController.login(RepositoriesController.java:137) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119) at org.pentaho.ui.xul.swt.tags.SwtTextbox.access$300(SwtTextbox.java:21) at org.pentaho.ui.xul.swt.tags.SwtTextbox$2.handleEvent(SwtTextbox.java:70) 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.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:313) at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:265) at org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:79) at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6209) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6357) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:539) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110) Caused by: org.pentaho.di.core.exception.KettleException: No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:191) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:120) ... 30 more DEBUG 29-03 10:54:26,451 - updateMenu called. schedulingEnabled is false

    Pentaho BI Platform Tracking | 7 years ago | Jem Matzan
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! No repository exists on the specified connection. To create a repository, select the Edit' button followed by the 'Create or upgrade' button.
  6. 0

    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

    Pentaho BI Platform Tracking | 1 year ago | Azucena Coronel
    org.pentaho.di.core.exception.KettleException: Transformation was unable to open [MetaInject 1] An error occured reading a transformation from the repository

    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. org.pentaho.di.core.exception.KettleException

      No repository defined!

      at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta()
    2. org.pentaho.di
      JobGraph$12.run
      1. org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1183)
      2. org.pentaho.di.job.entries.trans.JobEntryTrans.loadReferencedObject(JobEntryTrans.java:1482)
      3. org.pentaho.di.ui.spoon.job.JobGraph.loadReferencedObject(JobGraph.java:2316)
      4. org.pentaho.di.ui.spoon.job.JobGraph$12.run(JobGraph.java:1780)
      4 frames
    3. JFace
      ActionContributionItem$5.handleEvent
      1. org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
      2. org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
      3. org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
      4. org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
      4 frames
    4. 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
    5. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227)
      2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625)
      4 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.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      1 frame