UniversalDataReader throw an error trying to parse a date that is the start of Daylight Saving time

CloverDX Platform
1

The UniversalDataReader throws the following error when trying to parse a date that is the beginning of Daylight Saving time for US Eastern time:

Component [UniversalDataReader:UNIVERSAL_DATA_READER] finished with status ERROR. (Out0: 0 recs)
date (date) cannot be set to “2015-3-8 02:00” - doesn’t match defined format “yyyy-M-d HH:mm” in record 1, field 1 (“date”), metadata “date”; value: ‘2015-3-8 02:00’
Unparseable date: “2015-3-8 02:00” at position 14

This error is thrown for every time beginning with 2:00 through 2:59. I have attached a graph demonstrating the error.

I am using Designer Version: 4.0.3.007

2

Hi,

The explanation of the error is this (borrowed from other system):
----- snip ----
On the day of the daylight savings time transition (today, March 8, for
the US), the time of day goes:

01:59:59
03:00:00

There is no time range (today, Mar 8) which maps to 02:00:00 through
02:59:59. That range simply does not exist.

Which would explain what you see. March 8, 02:00:00 is an invalid time
value. The error message is not properly descriptive, but that is what
is happening.
-----

So similarly to what the “other” system is doing, the time you are trying to parse is
invalid in the time zone you are using. Unfortunately the lower level Java library which
Clover uses is not providing better error message than complaining about the format, which is
right. What is wrong is the date-time value itself in the given timezone.