Uploaded image for project: '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

        pvanderm Pieter van der Merwe (De Bortoli Wines, Australia) created issue -
        jcornelius 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 ]
        jcornelius Jared Cornelius made changes -
        Status Open [ 1 ] Open [ 1 ]
        Fix Version/s 4.3.0 GA (Platform Release 4.5 - Sugar) [ 11033 ]
        mbatchelor Marc Batchelor made changes -
        Workflow Pentaho Engineering 8.0 Workflow [ 556475 ] Pentaho Engineering 9.0 Workflow [ 570342 ]
        pvanderm Pieter van der Merwe (De Bortoli Wines, Australia) made changes -
        Assignee Jens Bleuel [ jbleuel ] Pieter van der Merwe [ pvanderm ]
        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
        pvanderm Pieter van der Merwe (De Bortoli Wines, Australia) made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        jbleuel 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 ]
        jbleuel 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 ]
        jbleuel 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 ]
        bbruce Brandon Bruce (Inactive) 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 ]
        jbleuel 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 ]
        bbruce Brandon Bruce (Inactive) made changes -
        Assignee Unassigned User [ unassigned ] Curtis Boyden [ cboyden ]
        bbruce Brandon Bruce (Inactive) made changes -
        Assignee Curtis Boyden [ cboyden ] Unassigned User [ unassigned ]
        brosander Bryan Rosander (Inactive) made changes -
        Assignee Unassigned User [ unassigned ] Bryan Rosander [ brosander ]
        brosander Bryan Rosander (Inactive) made changes -
        Assignee Bryan Rosander [ brosander ] Unassigned User [ unassigned ]
        brosander 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
        jbleuel Jens Bleuel made changes -
        Fix Version/s Backlog [ 11432 ]
        Fix Version/s 5.0.0 GA (5.0.0 GA Suite Release) [ 11433 ]
        jiraservice Jira Service Acct made changes -
        Workflow Pentaho Engineering 9.0 Workflow [ 570342 ] Pentaho Bug 1.0 Workflow [ 632502 ]
        jiraservice Jira Service Acct made changes -
        Workflow Pentaho Bug 1.0 Workflow [ 632502 ] Pentaho Engineering 9.0 Workflow [ 654475 ]
        Former Triage User Old Triage User (Inactive) made changes -
        Status Reopened [ 4 ] Reopened [ 4 ]
        mbatchelor Marc Batchelor made changes -
        Severity Severe [ 3 ] Urgent [ 10000 ]
        mbatchelor Marc Batchelor made changes -
        Rank Ranked lower
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked higher
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked higher
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked higher
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked higher
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked lower
        mbatchelor Marc Batchelor made changes -
        Bug Ranking Ranked higher
        jiraservice Jira Service Acct made changes -
        Special Flags Maintenance_Board [ 11870 ]
        andrey.khayrutdinov Andrey Khayrutdinov (Inactive) made changes -
        Assignee Unassigned User (Do not use) [ unassigned ] Andrey Khayrutdinov [ andrey.khayrutdinov ]
        andrey.khayrutdinov Andrey Khayrutdinov (Inactive) made changes -
        Assignee Andrey Khayrutdinov [ andrey.khayrutdinov ]
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        mbatchelor 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 Aliaksandr Bialkevich made changes -
        Assignee Aliaksandr Bialkevich [ aliaksandr ]
        aliaksandr Aliaksandr Bialkevich made changes -
        Fix Version/s 6.1.0 GA [ 13790 ]
        Fix Version/s Backlog [ 11432 ]
        aliaksandr Aliaksandr Bialkevich made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        jiraservice Jira Service Acct made changes -
        Workflow Pentaho Engineering 9.0 Workflow [ 654475 ] Pentaho Engineering 9.1 Workflow [ 754572 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved: