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.

Pentaho BI Platform Tracking | Jem Matzan | 7 years ago
  1. 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.
  2. 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.
  3. 0

    Issue is not regression. Steps to reproduce: 1) Create new "MS SQL Server" repository from the beginning and connect. Actual result: org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:160) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:191) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:180) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:269) at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:218) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleException: The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:219) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:146) ... 5 more Expected result: Able to connect to repository.

    Pentaho BI Platform Tracking | 2 years ago | Aliaksandr Bialkevich
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hi, I'm new to this forum and the product. I've installed mysql 5.5.37. I've installed Java Ive installed Kettle -Spoon General Availability Release - 5.0.1-stable I've copied JDBC driver(mysql-connector-java-5.1.30-bin.jar) into the lib directory. I've created a sql account, schema and Repository and set the bind-address to 0.0.0.0 The problem lies with when I try and connect to a repository. My very first time I've added a repository, I was able to do a "Dry run". During the Dry Run Execution, some of the scripts came back with errors. After the script, I tried to log in but I'm not able to. The User Name and Password I'm using is admin, admin and an Error comes up saying Repository login failed. Detailed error follows: __________________________________________________________________________ org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:165) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:194) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:180) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:249) at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:216) at java.lang.Thread.run(Thread.java:701) Caused by: org.pentaho.di.core.exception.KettleException: The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:217) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:145) ... 5 more ____________________________________________________________________________ When I try and use the Create or Upgrade button again, It comes back to "Confirm the password" - "Give the password of the admin user!". I've tried to use admin as the password, but no luck.

    Pentaho BI Platform Tracking | 3 years ago | Lunen
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version.
  6. 0

    Issue is not regression. Steps to reproduce: 1) Create new "MS SQL Server" repository from the beginning and connect. Actual result: org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:160) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:191) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:180) at org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:269) at org.pentaho.di.ui.repository.controllers.RepositoriesController$3.run(RepositoriesController.java:218) at java.lang.Thread.run(Unknown Source) Caused by: org.pentaho.di.core.exception.KettleException: The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version. at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:219) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:146) ... 5 more Expected result: Able to connect to repository.

    Pentaho BI Platform Tracking | 2 years ago | Aliaksandr Bialkevich
    org.pentaho.di.core.exception.KettleException: Error connecting to the repository! The version of the repository is -1.-1. This Kettle edition requires it to be at least version 5.0 and as such an upgrade is required. To upgrade, backup your database and export the repository to XML for additional safety. Then select the 'Edit' button followed by the 'Create or Upgrade' button. Please consult the Upgrade Guide for eventually special instructions for this version.

    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 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()
    2. org.pentaho.di
      RepositoriesController.login
      1. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.verifyVersion(KettleDatabaseRepositoryConnectionDelegate.java:191)
      2. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.connect(KettleDatabaseRepositoryConnectionDelegate.java:120)
      3. org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:173)
      4. org.pentaho.di.repository.kdr.KettleDatabaseRepository.connect(KettleDatabaseRepository.java:163)
      5. org.pentaho.di.ui.repository.RepositoriesHelper.loginToRepository(RepositoriesHelper.java:211)
      6. org.pentaho.di.ui.repository.controllers.RepositoriesController.login(RepositoriesController.java:137)
      6 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. org.pentaho.ui
      SwtTextbox$2.handleEvent
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323)
      2. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:131)
      3. org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:119)
      4. org.pentaho.ui.xul.swt.tags.SwtTextbox.access$300(SwtTextbox.java:21)
      5. org.pentaho.ui.xul.swt.tags.SwtTextbox$2.handleEvent(SwtTextbox.java:70)
      5 frames
    5. 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
    6. JFace
      Window.open
      1. org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
      2. org.eclipse.jface.window.Window.open(Window.java:796)
      2 frames
    7. org.pentaho.ui
      SwtDialog.show
      1. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:313)
      2. org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:265)
      2 frames
    8. org.pentaho.di
      Spoon.main
      1. org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:79)
      2. org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6209)
      3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6357)
      4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:539)
      4 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. org.pentaho.commons
      Launcher.main
      1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)
      1 frame