beccon4 opened a new issue, #3759: URL: https://github.com/apache/hop/issues/3759
### Apache Hop version? 2.8 ### Java version? "11.0.22" 2024-01-16 ### Operating system Linux ### What happened? Reading data from a MySQL/MariaDB table containing a datetime field fails with the following message for every row read: ``` 2024/03/25 17:26:50 - Row Preview - ERROR: org.apache.hop.core.exception.HopValueException: 2024/03/25 17:26:50 - Row Preview - zeit_d None : Unknown type 0 specified. 2024/03/25 17:26:50 - Row Preview - 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:2133) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.getDataForRow(PreviewRowsDialog.java:373) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.lambda$getData$7(PreviewRowsDialog.java:342) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:5040) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4520) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.open(PreviewRowsDialog.java:244) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.preview(TableInputDialog.java:574) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.lambda$open$3(TableInputDialog.java:327) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.open(TableInputDialog.java:336) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:174) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3400) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.mouseDoubleClick(HopGuiPipelineGraph.java:597) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:200) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:473) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:351) 2024/03/25 17:26:50 - Row Preview - ERROR: org.apache.hop.core.exception.HopValueException: 2024/03/25 17:26:50 - Row Preview - zeit_d None : Unknown type 0 specified. 2024/03/25 17:26:50 - Row Preview - 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:2133) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.getDataForRow(PreviewRowsDialog.java:373) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.lambda$getData$7(PreviewRowsDialog.java:342) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:5040) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4520) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.open(PreviewRowsDialog.java:244) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.preview(TableInputDialog.java:574) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.lambda$open$3(TableInputDialog.java:327) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.open(TableInputDialog.java:336) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:174) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3400) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.mouseDoubleClick(HopGuiPipelineGraph.java:597) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:200) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065) 2024/03/25 17:26:50 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:473) 2024/03/25 17:26:50 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:351) 2024/03/25 17:26:50 - Row Preview - ERROR: org.apache.hop.core.exception.HopValueException: 2024/03/25 17:26:50 - Row Preview - zeit_d None : Unknown type 0 specified. 2024/03/25 17:26:50 - Row Preview - ``` In the result set all rows have <NULL> values in that field. Table Definition from database schema: ``` | i_log | CREATE TABLE `i_log` ( `logid_i` int(10) unsigned NOT NULL AUTO_INCREMENT, `saveid_i` int(10) unsigned NOT NULL DEFAULT '0', `bewid_i` mediumint(8) unsigned NOT NULL DEFAULT '0', `userid_i` smallint(5) unsigned NOT NULL DEFAULT '0', `actid_i` tinyint(3) unsigned NOT NULL DEFAULT '0', `tabid_i` tinyint(3) unsigned NOT NULL DEFAULT '0', `zeit_d` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `prkey_i` int(10) unsigned NOT NULL DEFAULT '0', `userid_i_portal` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`logid_i`), KEY `bewid_i` (`bewid_i`), KEY `tabid_i` (`tabid_i`), KEY `prkey_i` (`prkey_i`), KEY `userid_i` (`userid_i`), KEY `userid_i_portal` (`userid_i_portal`), KEY `action` (`tabid_i`,`actid_i`), KEY `saveid_i` (`saveid_i`), KEY `zeit_d` (`zeit_d`), KEY `tabid_i_2` (`tabid_i`,`actid_i`,`bewid_i`,`prkey_i`), KEY `actid_i` (`actid_i`,`tabid_i`,`bewid_i`), KEY `tabid_i_3` (`tabid_i`,`actid_i`,`bewid_i`,`zeit_d`), KEY `tabid_i_4` (`tabid_i`,`bewid_i`), KEY `zeit_d_2` (`prkey_i`,`zeit_d`,`userid_i`,`tabid_i`,`actid_i`), KEY `actid_i_2` (`actid_i`,`tabid_i`,`prkey_i`), KEY `bewid_i_2` (`bewid_i`,`tabid_i`), KEY `tabid_i_5` (`tabid_i`,`zeit_d`,`bewid_i`,`saveid_i`) ) ENGINE=InnoDB AUTO_INCREMENT=164262970 DEFAULT CHARSET=latin1 PACK_KEYS=1 | ``` What's wrong? ### Issue Priority Priority: 1 ### Issue Component Component: Database, Component: Hop Gui, Component: Hop Run -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@hop.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org