Illegal instant due to time zone offset transition

[psysak]

Hey, hopefully this is a quick question. I'm trying to run a Data File CSV importer. I am importing data to a single point and it's all hourly data. When I tried to run the simple imported against my CSV I got this error

 org.joda.time.IllegalInstantException: Cannot parse "11-Mar-18 2": Illegal instant due to time zone offset transition (America/Toronto)

I've googled around and I'm not quite sure I understand what the error is. Is it because 2am does not exist on that day due to time change? Hmm. If that's the case can I just have this thing skip it somehow?

[Jared Wiltshire]

@psysak said in Illegal instant due to time zone offset transition:

Is it because 2am does not exist on that day due to time change?

Correct. There is no 2am on the 11th. It jumps straight to 3am.

@psysak said in Illegal instant due to time zone offset transition:

If that's the case can I just have this thing skip it somehow?

I dont think so. Can you delete it from the CSV?

[phildunlap]

You can easily skip it if you can modify the CSV importer, you would just put the call to the DateTimeFormat inside a try / catch instead of letting it get through, i.e.

long time;
try {
  time = dtf.parseDateTime(row[0]).getMillis();
} catch(IllegalInstantException e) {
  return; //Don't let the exception escape
}

[psysak]

@phildunlap Nice!

[psysak]

Interesting, can't compile cause it doesn't seem to understand IllegalInstantException

[phildunlap]

Did you put

import org.joda.time.IllegalInstantException;

around the other import statements at the top of the class?

[psysak]

................ yes?....

Thank you :)

I got around it by putting IllegalArgumentException since Instant extends it, but I will do it properly now