Pentaho Data Integration - Kettle
  1. Pentaho Data Integration - Kettle
  2. PDI-6768

Test button on the database connection dialog for plugin connections (like OpenERP, Palo) returns ClassNotFoundException

    Details

    • 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.

      Description

      This doesn't happen on the development environment using Eclipse but it happens on a finished build.

      To reproduce:
      1. Download the latest version from the CI server, for example pdi-ce-4.3.0-M1-r15785.tar.gz; or do a build on the current trunk and run kettle from the distrib directory.
      2. Create a new Palo or OpenERP connection and enter anything in the connection parameters. It doesn't need to be valid.
      3. Press the test button.

      Then you get the errors listed below. Interestingly the steps still work that make use of the connections (as far as I've tested). It only seems to affect the database connection dialog.
      OpenERP Connection
      I'm sorry, we can't create a test report for this database.

      Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
      java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
      	at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
      	at java.security.AccessController.doPrivileged(Native Method)
      	at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
      	at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
      	at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
      	at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
      	at java.lang.Class.forName0(Native Method)
      	at java.lang.Class.forName(Class.java:186)
      	at org.pentaho.di.core.database.DatabaseMeta.getDatabaseFactory(DatabaseMeta.java:2471)
      	at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2454)
      	at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:616)
      	at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
      	at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
      	at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
      	at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
      	at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
      	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.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:378)
      	at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
      	at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104)
      	at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
      	at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:78)
      	at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2778)
      	at org.pentaho.di.ui.spoon.Spoon.access$1900(Spoon.java:299)
      	at org.pentaho.di.ui.spoon.Spoon$24.widgetDefaultSelected(Spoon.java:5258)
      	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:1169)
      	at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6938)
      	at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:616)
      	at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      

      Palo Error:
      I'm sorry, we can't create a test report for this database.

      Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
      java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
      	(Same stack trace as before)
      

      It didn't happen when I last tested (around 10 builds ago?), but I didn't have enough time to check at which revision it broke.

        Activity

        Pieter van der Merwe (De Bortoli Wines, Australia) created issue -
        Jared Cornelius made changes -
        Field Original Value New Value
        Status Open [ 1 ] Open [ 1 ]
        Affects Version/s 4.3.0 GA (Platform Release 4.5 - Sugar) [ 11033 ]
        Affects Version/s 4.3.0-M1 [ 11238 ]
        Severity Blocker [ 1 ] Severe [ 3 ]
        Assignee Triage [ project admin ] Jens Bleuel [ jbleuel ]
        Fix Version/s 4.3.0-M1 [ 11238 ]
        Jared Cornelius made changes -
        Status Open [ 1 ] Open [ 1 ]
        Fix Version/s 4.3.0 GA (Platform Release 4.5 - Sugar) [ 11033 ]
        Marc Batchelor made changes -
        Workflow Pentaho Engineering 8.0 Workflow [ 556475 ] Pentaho Engineering 9.0 Workflow [ 570342 ]
        Pieter van der Merwe (De Bortoli Wines, Australia) made changes -
        Assignee Jens Bleuel [ jbleuel ] Pieter van der Merwe [ pvanderm ]
        Pieter van der Merwe (De Bortoli Wines, Australia) made changes -
        CI Build Build 4058, pdi-ce-4.3.0-M1-r15958.tar.gz, pdi-ce-4.3.0-M1-r15958.zip
        Pieter van der Merwe (De Bortoli Wines, Australia) made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Jens Bleuel made changes -
        Affects Version/s 4.4 / 5.0 Reservoir [ 11432 ]
        Affects Version/s 4.4.0 GA (5.0.0 GA Suite Release - Sugar) [ 11033 ]
        Fix Version/s 4.4 / 5.0 Reservoir [ 11432 ]
        Fix Version/s 4.4.0 GA (5.0.0 GA Suite Release - Sugar) [ 11033 ]
        Jens Bleuel made changes -
        Assignee Pieter van der Merwe (De Bortoli Wines, Australia) [ pvanderm ] Unassigned User [ unassigned ]
        Fix Version/s 4.4.0 GA (5.0.0 GA Suite Release - Sugar) [ 11433 ]
        Fix Version/s 4.4 / 5.0 Reservoir [ 11432 ]
        Jens Bleuel made changes -
        Affects Version/s 5.0.0 GA (5.0.0 GA Suite Release - Sugar) [ 11433 ]
        Affects Version/s 5.x / 6.0 Reservoir [ 11432 ]
        Brandon Bruce made changes -
        Fix Version/s 5.0.0 M2 [ 11622 ]
        Fix Version/s 5.0.0 GA (5.0.0 GA Suite Release - Sugar) [ 11433 ]
        Jens Bleuel made changes -
        Fix Version/s 5.0.0 GA (5.0.0 GA Suite Release) [ 11433 ]
        Fix Version/s 5.0.0 M2 [ 11622 ]
        Brandon Bruce made changes -
        Assignee Unassigned User [ unassigned ] Curtis Boyden [ cboyden ]
        Brandon Bruce made changes -
        Assignee Curtis Boyden [ cboyden ] Unassigned User [ unassigned ]
        Bryan Rosander (Inactive) made changes -
        Assignee Unassigned User [ unassigned ] Bryan Rosander [ brosander ]
        Bryan Rosander (Inactive) made changes -
        Assignee Bryan Rosander [ brosander ] Unassigned User [ unassigned ]
        Bryan Rosander (Inactive) made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        CI Build Build 4058, pdi-ce-4.3.0-M1-r15958.tar.gz, pdi-ce-4.3.0-M1-r15958.zip http://release.pentaho.com/sugar-nightly/318/pdi-ee-5.0.0.1.zip
        Jens Bleuel made changes -
        Fix Version/s Backlog [ 11432 ]
        Fix Version/s 5.0.0 GA (5.0.0 GA Suite Release) [ 11433 ]
        Jira Service Acct made changes -
        Workflow Pentaho Engineering 9.0 Workflow [ 570342 ] Pentaho Bug 1.0 Workflow [ 632502 ]
        Jira Service Acct made changes -
        Workflow Pentaho Bug 1.0 Workflow [ 632502 ] Pentaho Engineering 9.0 Workflow [ 654475 ]
        Old Triage User (Inactive) made changes -
        Status Reopened [ 4 ] Reopened [ 4 ]
        Marc Batchelor made changes -
        Severity Severe [ 3 ] Urgent [ 10000 ]
        Marc Batchelor made changes -
        Rank Ranked lower
        Marc Batchelor made changes -
        Bug Ranking Ranked higher
        Marc Batchelor made changes -
        Bug Ranking Ranked higher
        Marc Batchelor made changes -
        Bug Ranking Ranked higher
        Marc Batchelor made changes -
        Bug Ranking Ranked higher
        Marc Batchelor made changes -
        Bug Ranking Ranked lower
        Marc Batchelor made changes -
        Bug Ranking Ranked higher
        Andrey Khayrutdinov (Inactive) made changes -
        Assignee Unassigned User (Do not use) [ unassigned ] Andrey Khayrutdinov [ andrey.khayrutdinov ]
        Andrey Khayrutdinov (Inactive) made changes -
        Assignee Andrey Khayrutdinov [ andrey.khayrutdinov ]
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Marc Batchelor made changes -
        Description This doesn't happen on the development environment using Eclipse but it happens on a finished build.

        To reproduce:
        1. Download the latest version from the CI server, for example pdi-ce-4.3.0-M1-r15785.tar.gz; or do a build on the current trunk and run kettle from the distrib directory.
        2. Create a new Palo or OpenERP connection and enter anything in the connection parameters. It doesn't need to be valid.
        3. Press the test button.

        Then you get the errors listed below. Interestingly the steps still work that make use of the connections (as far as I've tested). It only seems to affect the database connection dialog.

        OpenERP Connection
        I'm sorry, we can't create a test report for this database.
        Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
        java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
        at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:186)
        at org.pentaho.di.core.database.DatabaseMeta.getDatabaseFactory(DatabaseMeta.java:2471)
        at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2454)
        at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
        at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
        at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
        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.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:378)
        at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
        at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104)
        at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
        at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:78)
        at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2778)
        at org.pentaho.di.ui.spoon.Spoon.access$1900(Spoon.java:299)
        at org.pentaho.di.ui.spoon.Spoon$24.widgetDefaultSelected(Spoon.java:5258)
        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:1169)
        at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6938)
        at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)

        Palo Error:
        I'm sorry, we can't create a test report for this database.
        Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
        java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
        (Same stack trace as before)

        It didn't happen when I last tested (around 10 builds ago?), but I didn't have enough time to check at which revision it broke.
        This doesn't happen on the development environment using Eclipse but it happens on a finished build.

        To reproduce:
        1. Download the latest version from the CI server, for example pdi-ce-4.3.0-M1-r15785.tar.gz; or do a build on the current trunk and run kettle from the distrib directory.
        2. Create a new Palo or OpenERP connection and enter anything in the connection parameters. It doesn't need to be valid.
        3. Press the test button.

        Then you get the errors listed below. Interestingly the steps still work that make use of the connections (as far as I've tested). It only seems to affect the database connection dialog.
        OpenERP Connection
        I'm sorry, we can't create a test report for this database.
        {noformat}
        Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
        java.lang.ClassNotFoundException: org.pentaho.di.openerp.core.OpenERPHelper
        at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:186)
        at org.pentaho.di.core.database.DatabaseMeta.getDatabaseFactory(DatabaseMeta.java:2471)
        at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2454)
        at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:511)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
        at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
        at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
        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.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:378)
        at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
        at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:104)
        at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
        at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:78)
        at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2778)
        at org.pentaho.di.ui.spoon.Spoon.access$1900(Spoon.java:299)
        at org.pentaho.di.ui.spoon.Spoon$24.widgetDefaultSelected(Spoon.java:5258)
        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:1169)
        at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6938)
        at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
        {noformat}

        Palo Error:
        I'm sorry, we can't create a test report for this database.
        {noformat}
        Error connecting to database [dbw_openerp1] : java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
        java.lang.ClassNotFoundException: org.pentaho.di.palo.core.PaloHelper
        (Same stack trace as before)
        {noformat}

        It didn't happen when I last tested (around 10 builds ago?), but I didn't have enough time to check at which revision it broke.
        Aliaksandr Bialkevich made changes -
        Assignee Aliaksandr Bialkevich [ aliaksandr ]
        Aliaksandr Bialkevich made changes -
        Fix Version/s 6.1.0 GA [ 13790 ]
        Fix Version/s Backlog [ 11432 ]
        Aliaksandr Bialkevich made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Jira Service Acct made changes -
        Workflow Pentaho Engineering 9.0 Workflow [ 654475 ] Pentaho Engineering 9.1 Workflow [ 754572 ]

          People

          • Assignee:
            Aliaksandr Bialkevich
            Reporter:
            Pieter van der Merwe (De Bortoli Wines, Australia)
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: