Wrapped org.joda.time.IllegalInstantException

Hi all,

i'm trying to import a file with a custom service based on a thing with "fileRepository" thing template.

The first filed is a date and, when I tested my service returns:

Wrapped org.joda.time.IllegalInstantException: Cannot parse "2010-03-28 02:01:34": Illegal instant due to time zone offset transition (Europe/Berlin) Cause: Cannot parse "2010-03-28 02:01:34": Illegal instant due to time zone offset transition (Europe/Berlin)

Here an example of my data:

2010-03-28 01:04:35

In my script I specified the date format as:

dateFormat: "yyyy-MM-dd HH:mm:ss" /* STRING */

I found a page in the support ptc portal that says (https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS192560&lang=en&source=snippet😞

• Use the GMT/UTC timezone for date times
• Add a Z directly after the time format without a space(Z is the zone indicator for the zero UTC offset)
  • yyyy-MM-dd'T'HH:mm:ssZ

But when i put "z" in my date format:

dateFormat: "yyyy-MM-dd HH:mm:ssZ" /* STRING */

I get a generic error:

Wrapped java.lang.StringIndexOutOfBoundsException: String index out of range: 20 Cause: String index out of range: 20

Could you please help?

Thanks in adivce

Fulvio

cc: Marco Pagliotta​ - Marco Gioia​