Many people that have to manage data from different sources (DB2, MS Sql Server, MySql, Oracle, Excel, …) surely knows Pentaho Data Integration also known with the name Kettle.
It’s a fantastic ETL (Extract, Transform, Load).
But, because there is always a but, there is a little problem on Ubuntu 14.04 and Oracle Java: spoon, the UI of PDI, doesn’t work.
When I tried to execute spoon.sh I had the following java error:
paolo@paonote:~/kettle$ ./spoon.sh /home/paolo/kettle Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0 # # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007fd12026c2a1, pid=11634, tid=140538595305216 # # JRE version: Java(TM) SE Runtime Environment (8.0_05-b13) (build 1.8.0_05-b13) # Java VM: Java HotSpot(TM) 64-Bit Server VM (25.5-b02 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [libsoup-2.4.so.1+0x6c2a1] soup_session_feature_detach+0x11 # # Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again # # An error report file with more information is saved as: # /home/paolo/kettle/hs_err_pid11634.log # # If you would like to submit a bug report, please visit: # http://bugreport.sun.com/bugreport/crash.jsp # The crash happened outside the Java Virtual Machine in native code. # See problematic frame for where to report the bug. # Aborted (core dumped)
I had the same error with java version 1.7 che 1.8.
No panic!!!
I solved it editing spoon.sh script:
add the following option
-Dorg.eclipse.swt.browser.DefaultType=mozilla
to the following line:
OPT="$OPT $PENTAHO_DI_JAVA_OPTIONS -Djava.library.path=$LIBPATH -DKETTLE_HOME=$KETTLE_HOME -DKETTLE_REPOSITORY=$KETTLE_REPOSITORY -DKETTLE_USER=$KETTLE_USER -DKETTLE_PASSWORD=$KETTLE_PASSWORD -DKETTLE_PLUGIN_PACKAGES=$KETTLE_PLUGIN_PACKAGES -DKETTLE_LOG_SIZE_LIMIT=$KETTLE_LOG_SIZE_LIMIT -DKETTLE_JNDI_ROOT=$KETTLE_JNDI_ROOT"
then restart the script ./spoon.sh and magically everything works!
Comments
Thanks a ton! it worked
Author
I’m happy for you 😀
Help me
I have this mistake:
geova@linux-6v9r:~/fenicios/instaladores/data-integration> sh spoon.sh
/home/geova/fenicios/instaladores/data-integration
2015/09/01 14:27:27 – General – ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Error starting Spoon shell
2015/09/01 14:27:27 – General – ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : java.lang.ExceptionInInitializerError
2015/09/01 14:27:27 – General – at org.pentaho.di.ui.spoon.Spoon.init(Spoon.java:807)
2015/09/01 14:27:27 – General – at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:9170)
2015/09/01 14:27:27 – General – at org.eclipse.jface.window.Window.create(Window.java:426)
2015/09/01 14:27:27 – General – at org.eclipse.jface.window.Window.open(Window.java:785)
2015/09/01 14:27:27 – General – at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9201)
2015/09/01 14:27:27 – General – at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:648)
2015/09/01 14:27:27 – General – at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2015/09/01 14:27:27 – General – at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2015/09/01 14:27:27 – General – at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2015/09/01 14:27:27 – General – at java.lang.reflect.Method.invoke(Method.java:597)
2015/09/01 14:27:27 – General – at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
2015/09/01 14:27:27 – General – Caused by: java.util.MissingResourceException: Can’t find bundle for base name ui/laf, locale es_ES
2015/09/01 14:27:27 – General – at java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:1427)
2015/09/01 14:27:27 – General – at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1250)
2015/09/01 14:27:27 – General – at java.util.ResourceBundle.getBundle(ResourceBundle.java:952)
I have opensuse