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

mickeye

• March 10, 2015 00:00

• Answered

Follow

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

• DateProblem.grf

• 

  dpavlis

  • March 11, 2015 12:50

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.