DateTimeParseException, unable to Display current time

Hi, I am trying to do data reflection but unable to do so, due to mapping issue.

Below is the Sample Data and Mapping Format;

date Samples;
27/02/2020T00:00:00+08:00

Mapping Format;
{
“format”: “DD/MM/YYYY’T’HH:mm:ssZZZZZ”
}

Below is the output;

FYI, I am using Siren 10.5 and ES 7.3.2

This is related to Elasticsearch’s migration from joda time to java.time. If you change the date format from dd-MM-yyyy'T'HH:mm:ssZ to dd-MM-yyyy'T'HH:mm:ssX then it would work on 7.3.2. Let me know if you face any other issue.

Regards
Manu Agarwal

Hi Manu.

I have followed the steps you have given and It works! Thanks for your help!

Regards,
Farhan