Topic Datacleaner Failed to execute runnable (java.lang.NullPointerException)

Fati started the topic:
2017-04-16 10:23

Datacleaner Failed to execute runnable (java.lang.NullPointerException)

Hi,

Installed datacleaner plugin for spoon 7.0 from the Marketplace.
I configured the dataCleaner configuration as follows: C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner
I copied the file 'commons-vfs2-2.1-20150824.jar' from Pentaho 'data-integration/lib' installation folder to DataCleaner 'lib' installation folder and removed 'commons-vfs2-2.0.jar'.

i have 2 databases running on a VM(monetdb and Mysql) both are up and running. I hope somenone can help me with this issue I cant find the solution

But I still get this error my pentaho.log looks as follows
2017/04/16 12:07:38 - DataCleaner - DataCleaner launch commands : C:\Pentaho\java/bin/java -cp C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/DataCleaner.jar;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/modules/*;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/lib/*;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/../../lib/kettle-core-7.0.0.0-25.jar;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/../../lib/commons-vfs2-2.1-20150824.jar;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/../../lib/scannotation-1.0.2.jar;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/../../lib/javassist-3.20.0-GA.jar;C:\Pentaho\design-tools\data-integration\plugins\kettle6-profiling-datacleaner/DataCleaner-PDI-plugin.jar -Ddatacleaner.ui.visible=true -Ddatacleaner.embed.client=Kettle org.datacleaner.Main
2017/04/16 12:07:38 - DataCleaner - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : DC: Error: Could not find or load main class org.datacleaner.Main
2017/04/16 12:07:38 - Spoon - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Er heeft zich een onverwachte fout in Spoon voorgadaan. Waarschijnlijke oorzaak: Sluit eerst alle vensters alvorens Spoon te beeindgen!
2017/04/16 12:07:38 - Spoon - Failed to execute runnable (java.lang.NullPointerException)
2017/04/16 12:07:38 - Spoon - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.SWT.error(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.SWT.error(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1359)
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7990)
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9290)
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:685)
2017/04/16 12:07:38 - Spoon - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2017/04/16 12:07:38 - Spoon - at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
2017/04/16 12:07:38 - Spoon - at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
2017/04/16 12:07:38 - Spoon - at java.lang.reflect.Method.invoke(Unknown Source)
2017/04/16 12:07:38 - Spoon - at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
2017/04/16 12:07:38 - Spoon - Caused by: java.lang.NullPointerException
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.ui.core.dialog.ErrorDialog.<init>(ErrorDialog.java:83)
2017/04/16 12:07:38 - Spoon - at org.pentaho.di.profiling.datacleaner.ModelerHelper$1.run(ModelerHelper.java:287)
2017/04/16 12:07:38 - Spoon - at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
2017/04/16 12:07:38 - Spoon - ... 12 more
org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
at org.eclipse.swt.SWT.error(Unknown Source)
at org.eclipse.swt.SWT.error(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:1359)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7990)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9290)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:685)
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: java.lang.NullPointerException
at org.pentaho.di.ui.core.dialog.ErrorDialog.<init>(ErrorDialog.java:83)
at org.pentaho.di.profiling.datacleaner.ModelerHelper$1.run(ModelerHelper.java:287)
at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
... 12 more
org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
at org.eclipse.swt.SWT.error(Unknown Source)
at org.eclipse.swt.SWT.error(Unknown Source)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source)
at org.eclipse.swt.widgets.Display.syncExec(Unknown Source)
at org.pentaho.di.profiling.datacleaner.ModelerHelper.showErrorMessage(ModelerHelper.java:283)
at org.pentaho.di.profiling.datacleaner.ModelerHelper.launchDataCleaner(ModelerHelper.java:251)
at org.pentaho.di.profiling.datacleaner.ModelerHelper$3.run(ModelerHelper.java:314)
Caused by: java.lang.NullPointerException
at org.pentaho.di.ui.core.dialog.ErrorDialog.<init>(ErrorDialog.java:83)
at org.pentaho.di.profiling.datacleaner.ModelerHelper$1.run(ModelerHelper.java:287)
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:1359)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7990)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9290)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:685)
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)
Dennis replied:
2017-04-16 19:12
Hi Fati,

It looks a bit (though not exactly) like the error I get when the path to DataCleaner isn't configured correctly in Spoon.

When does it happen? During Spoon startup, when you're doing "profile with DataCleaner" from the context menu, or when you're executing a DataCleaner job as a Pentaho job step?
Fati replied:
2017-04-18 10:39
Hi Dennis,

It happens in both situations. I configured the path in Spoon datacleaner configuration. And gave the path where I have installed the datacleaner plugin as mentioned.

Hope you can help me but at this moment I am clueless. I have other plugins installed and these all work except datacleaner.

Thanks.
Dennis replied:
2017-04-19 07:05
Hi Fati,

I'll ask around to see if anyone else has seen this before. I'm unfortunately just as clueless as you, and I can't reproduce it.

Something that might help narrow it down: Try with a stupid simple transformation, like a "generate rows" and a "generate random value", then try to profile that. Then at least we'll see if it's related to the specific job, or if it's something general.
Dennis replied:
2017-04-19 09:20
Hi Fati,

My colleague took a look, and immediately spotted something I missed: You need to provide the path to DataCleaner itself, not to the DataCleaner plugin.

Download and install DataCleaner (community or the pro trial, depending on your needs), and then point the configuration to it. That should fix it.

You're not the first that make this mistake, so I'll create an issue in our tracker about improving the dialog.

BR,
Dennis
Fati replied:
2017-04-20 12:00
Hi Dennis,

Thank you for your help. It works!!!

Fati
Dennis replied:
2017-04-21 07:45
Good to hear! :)
You are not signed in.
You need to be signed in to participate in the discussion.