Error when trying to test connection to Palo MOLAP Server with Spoon 3.0.1

[apak]

Hello, friends,

I have a problem with connection to Palo-Server useng Spoon 3.0.1.
Do you have any messages like that?

Error message text:
I'm sorry, we can't create a test report for this database.
Error connecting to database [Palo connection] : java.lang.ClassNotFoundException: plugin.palo.core.PaloHelper
java.lang.ClassNotFoundException: plugin.palo.core.PaloHelper
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.pentaho.di.core.database.DatabaseMeta.getDatab aseFactory(DatabaseMeta.java:2490)
at org.pentaho.di.core.database.DatabaseMeta.testConn ection(DatabaseMeta.java:2473)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.test(DatabaseDialog.java:1919)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.test(DatabaseDialog.java:1901)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log$4.handleEvent(DatabaseDialog.java:311)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unkno wn 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(Un known Source)
at org.pentaho.di.ui.core.database.dialog.DatabaseDia log.open(DatabaseDialog.java:386)
at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate. newConnection(SpoonDBDelegate.java:505)
at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree( Spoon.java:2252)
at org.pentaho.di.ui.spoon.Spoon.access$500(Spoon.jav a:240)
at org.pentaho.di.ui.spoon.Spoon$8.widgetDefaultSelec ted(Spoon.java:1311)
at org.eclipse.swt.widgets.TypedListener.handleEvent( Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unkno wn 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(Un known Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoo n.java:841)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:558 9)
at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:5685)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:371)

Thanks,
Alexey

[MattCasters]

The forgot to set the correct helper class (factory) in the Palo plugins.

[apak]

Thank you, Matt,

But I am a novice in java technologies, so could you please, explain me what does it mean or what should I do?
I didn't used any Palo plugins yet. Thought that I would be able to connect to Palo server since Palo MOLAP Server is in the connection list of PDI.

Thanks alot,
Alexey

[MattCasters]

Alexey, it doesn't mean anything. It just means that the test-button doesn't work.
Everything else should work fine as far as I know. (tested the Palo plugins myself a while ago).

For more information I suggest you go to the Palo plugin project on sourceforge.

Matt

[jku]

Alexey,
i had the same issue when testing with:

- kettle 3.0.1
- palo server 2.0
- jpalo.jar from jpalo api version 2.0


I switched to the jpalo.jar from jpalo api version 1.5 (copy it to kettle's libext directory). Then it worked ..
Well, you still cannot use the test button or use the db explorer but you can use the palo plugins like dimension/cells input / output .

Hope that helps.
Joerg