Kettle / Pentaho Data Integration - unable to create a Database Connection (XulException: java.lang.reflect.InvocationTargetException)

java pentaho kettle
Blew my stack picture Blew my stack · Jan 24, 2018 · Viewed 7.6k times · Source

Having finally got kettle to start and not hang, I still cannot use it to much avail, as when I try to create a new Database Connection (after creating a new Transformation) I get this error:

org.pentaho.ui.xul.XulException: java.lang.reflect.InvocationTargetException

Thereafter, I get this more general error for the same actions:

General error in dialog

In order to get the first 'java...TargetException' again, I have to close and restart kettle.
Note, this also happens when I load an existing kettle job and try to edit its database connection.

Could this be a configuration issue? A missing or misplaced file ? What is the Target that is failing to be Invoked? Thanks in advance for your help.

My config:

macos 10.12.6 (Sierra)
Pentaho Data Integration (or kettle) 7.1.0
java version "9.0.4"

Answer

Blew my stack picture Blew my stack · Jan 26, 2018

As I found out from the Pentaho Data Integration forum, it was a matter of my version of Java.
I uninstalled Java 9 and installed Java 8 and then no longer got this error.

Related questions

Not able to run spoon.bat or any other batch file in Pentaho Data Integration (Kettle)

Tried pdi-ce-4.1.0-stable and pdi-ce-4.2.0-stable My Machine - Windows 7 64 bit When I run Spoon.bat cmd line window appears and disappears and then nothing happens. When I tried to run it from command line, I get DEBUG: Using JAVA_…

Read More
Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' could not be found

Hi I've just installed Pentaho Data Integration v. 5.01 and I'm trying to connect to a database. However, I'm unable to test the connection as I get the error (pasted below). I have JDK 1.7 installed on the system as well, however …

Read More
Open Source Java Reporting Framework

i want to create few Reports which picks data from few SQL tables, So instead of creating different report's i want to create (or use any Open source) reporting framework, I googled about it but still didn't find enough information …

Read More