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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
