Topic DATA CLEANER ERROR: Failed to execute runnable (java.lang.NullPointerException)

Mr. Xavo started the topic:
2016-07-12 21:10

DATA CLEANER ERROR: Failed to execute runnable (java.lang.NullPointerException)

HI !!

I INSTALLED, DATA CLEANER PLUG-IN 4.5.1 ON PENTAHO 5.4.0.1.

BUT WHEN I STARTED DATA CLEANER APPEARS THE FOLLOWING ERROR:




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:235)
at org.pentaho.di.profiling.datacleaner.ModelerHelper.launchDataCleaner(ModelerHelper.java:226)
at org.pentaho.di.profiling.datacleaner.ModelerHelper$3.run(ModelerHelper.java:266)
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:239)
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:1319)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)
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)

THIS IS DATA CLEANER APPLICATION DIRECTORY FOR CONFIGURATION
C:\Pentaho\design-tools\data-integration\plugins\profiling-datacleaner

JAVA VERSION: 1.8.0

SOMEBODY HELP ME!!!
Claudia replied:
2016-07-13 09:44
Hi Xavo,

Did you set the location of DataCleaner in the menu "Tools", "DataCleaner configuration" ?
You need to have DataCleaner installed locally on your machine.

Regards,
Claudia
Mr. Xavo replied:
2016-07-13 14:45
Hi Claudia !!

Thanks, I installed DC locally, now it works.

Regards
Xavo
Shoban replied:
2016-11-29 20:56
Hi,

When you say full version are you referring to this "DataCleaner-professional-5.1.5-install.jar"? I installed this and still facing the above issue.

I am using pentaho version 6.1 and Jave 1.7 update 79

Here is my error log
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:280)
at org.pentaho.di.profiling.datacleaner.ModelerHelper.launchDataCleaner(ModelerHelper.java:248)
at org.pentaho.di.profiling.datacleaner.ModelerHelper$3.run(ModelerHelper.java:311)
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:284)
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:1347)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7989)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9269)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:662)
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:606)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

Thanks in advance for your HELP ?
Claudia replied:
2016-11-30 08:21
Hi Shoban,

You need to have installed Java 1.8.

Regards,
Claudia

Claudia replied:
2016-11-30 09:17
Hi Shoban,

We are looking into it. I hope we will have a fix soon.

Regards,
Claudia

Shoban replied:
2016-11-30 15:08
Yes, I installed Java 1.8 update112. I tried replacing the org.eclipse.swt jar file. Still having the same issue.

Looking forward for the fix soon

-Shoban
Claudia replied:
2016-12-02 10:30
Hi Shoban,

A fix has been made. The newly updated plugin can be found in Pentaho marketplace, the version is 5.1.5 ("DataCleaner plugin for version 6 and 7").

Reinstall the plugin, restart PDI and you are good to go.

Regards,
Claudia



Renaud Levesque replied:
2017-01-27 21:20
Hi,

I had the same "Failed to execute runnable" problem preceded by the message "org.apache.commons.vfs2.FileObject.isFile()Z" (java 1.8, DC 5.1.5 and PDI 7). I replaced "commons-vfs2-2.0.jar" in "...\DataCleaner\lib" directory by "commons-vfs2-2.1-20150824.jar" coming from PDI under "...\data-integration\lib", and everything worked fine.

Hope this helps.
Renaud
Eric replied:
2017-03-29 18:55
+1 to Renaud. Thank you!
sai dileep replied:
2017-05-16 12:33
I have pentaho 7 installed in my machine and also the java 1.8.0_92. Now I installed the datacleaner plugin from marketplace and configured the path correctly. After that replaced the file common-cfs****.jar. But still facing issue like java null point error.

Renaud Levesque replied:
2017-05-16 21:25
Hi, it is "commons-Vfs*.jar" (note the "vfs" not "cfs").
My PDI version is 7.0.0.0-25.
Java -version gives :
----
Microsoft Windows [version 6.3.9600]
(c) 2013 Microsoft Corporation. Tous droits réservés.

C:\Windows\system32>java -version
java version "1.8.0_121"
Java(TM) SE Runtime Environment (build 1.8.0_121-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode)
----
And here are the list of "commons-vfs*.jar" in my directories ("répertoires"), and "Travail" is just my working directory where I install applications)
----
Répertoire de C:\Travail\DataCleaner\lib

2016-11-21 18:29 437 400 commons-vfs2-2.1-20150824.jar
1 fichier(s) 437 400 octets

Répertoire de C:\Travail\pdi\data-integration\lib

2016-11-21 18:29 437 400 commons-vfs2-2.1-20150824.jar
1 fichier(s) 437 400 octets

Répertoire de C:\Travail\pdi\data-integration\plugins\kettle6-profiling-datacleaner\lib

2017-01-23 14:35 415 578 commons-vfs2-2.0.jar
1 fichier(s) 415 578 octets

Répertoire de C:\Travail\pdi-ce6\data-integration\lib

2015-12-03 14:30 437 400 commons-vfs2-2.1-20150824.jar
1 fichier(s) 437 400 octets
----
And, still, everything works on my side.
Hope it helps.
Renaud
You are not signed in.
You need to be signed in to participate in the discussion.