This ticket encompasses a couple issues I have.
System Info:
OS: MacOS 10.15.6
PDI: 9.0
Java: 1.8.0_262
When I try to run a job, I'm given this error:
2020/08/19 10:07:22 - Update_Start_ETL_Status - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : An error occurred executing this job entry : 2020/08/19 10:07:22 - Update_Start_ETL_Status - Error occurred while trying to connect to the database2020/08/19 10:07:22 - Update_Start_ETL_Status - 2020/08/19 10:07:22 - Update_Start_ETL_Status - Error connecting to database: (using class org.gjt.mm.mysql.Driver)2020/08/19 10:07:22 - Update_Start_ETL_Status - Communications link failure2020/08/19 10:07:22 - Update_Start_ETL_Status - 2020/08/19 10:07:22 - Update_Start_ETL_Status - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Originally, I was getting an error about not having a MySQL connector installed, so I added mysql-connector-java-5.1.49-bin.jar to the lib directory. However, I still receive this error. I can verify the connection settings are correct, as I can access the database through another program.
When I try to access the database info in Pentaho, however, I'm given this error.
org.pentaho.ui.xul.XulException: org.pentaho.ui.xul.XulException: java.lang.reflect.InvocationTargetExceptionat org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:135)at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:128)at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:122)at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:243)at org.pentaho.ui.database.DatabaseConnectionDialog.getSwtInstance(DatabaseConnectionDialog.java:60)at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.createDialog(XulDatabaseDialog.java:152)at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:106)at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:61)at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:96)at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:3140)at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:3075)at org.pentaho.di.ui.spoon.Spoon.access$1700(Spoon.java:373)at org.pentaho.di.ui.spoon.Spoon$26.widgetDefaultSelected(Spoon.java:6354)at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:123)at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4385)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1512)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1535)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1520)at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1324)at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3789)at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1385)at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7968)at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9350)at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:711)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:564)at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)Caused by: org.pentaho.ui.xul.XulException: java.lang.reflect.InvocationTargetExceptionat org.pentaho.ui.xul.impl.XulParser.getElement(XulParser.java:239)at org.pentaho.ui.xul.impl.XulParser.parse(XulParser.java:164)at org.pentaho.ui.xul.impl.XulParser.parseDocument(XulParser.java:85)at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:127)... 30 moreCaused by: java.lang.reflect.InvocationTargetExceptionat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Method.java:564)at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:2127)at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:2108)at org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(PropertyUtilsBean.java:1914)at org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUtilsBean.java:2021)at org.apache.commons.beanutils.BeanUtilsBean.setProperty(BeanUtilsBean.java:1018)at org.apache.commons.beanutils.BeanUtilsBean.populate(BeanUtilsBean.java:823)at org.apache.commons.beanutils.BeanUtils.populate(BeanUtils.java:431)at org.pentaho.ui.xul.impl.XulParser.getElement(XulParser.java:235)... 33 moreCaused by: java.lang.ClassCastException: class [Ljava.lang.Object; cannot be cast to class [Ljava.lang.String; ([Ljava.lang.Object; and [Ljava.lang.String; are in module java.base of loader 'bootstrap')at org.pentaho.ui.xul.swt.tags.SwtDialog.setButtons(SwtDialog.java:285)... 45 more
Any help would be greatly appreciated.
This was caused by my default kettle.properties file being bad. I ended up using one in my job's main ETL repo and that ended up fixing it.
Hopefully that'll help you if you have this problem.