The Date datatype output from DataEventPoller cannot be passed directly to the input of the DataMerger activity when the database is MySQL 8.x.
Article ID: KB0071066
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 8.6.0 |
Description
(MySQL 8.x with native drivers only) If a field with Date datatype from the DataEventPoller activity output is provided as an input to the DataMerger activity, the following error occurs: "SQLException: Unparseable date.
Issue/Introduction
(MySQL 8.x with native drivers only) If a field with Date datatype from the DataEventPoller activity output is provided as an input to the DataMerger activity, following error occurs: "SQLException: Unparseable date
Environment
Product: TIBCO ActiveMatrix BusinessWorks(TM) Plug-in for Database
Version: 8.6.0
OS: All Supported Operating Systems
Resolution
Modify the XPath of the Date field in the input tab of DataMerger activity as below:
concat(substring-before($DateOutput, 'T'), " ", substring-after($DateOutput, 'T'), ":00")
concat(substring-before($DateOutput, 'T'), " ", substring-after($DateOutput, 'T'), ":00")
Feedback
Yes
No
Powered by
