tSchemaComplianceCheck not validating dates with timezone

[Rimvis]

Hi all,

I'm facing a problem when using tSchemaComplianceCheck component to validate incoming date/time.

The data comes in the format "yyyy-MM-dd'T'HH:mm:ssXXX", for example "2019-10-02T21:45:33+01:00".

Schema check fails with the message "wrong DATE pattern or wrong DATE data"

However, when I'm parsing the same date using the same format, it's working without any issues:

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssXXX",... )

I have tried setting "Ignore TimeZone when check date" without any effect. 

Using Talend Open Studio for Data Integration, v7.1.1

Any ideas?

Thanks,

Rimvis

[Rimvis]

Hi @nthampi ,

I'm not changing the value, that's the point The same value is being validated if process is running in UTC+2 timezone, but fails if running in UTC.

I'm changing time zone in Date & Time settings on my computer:

[Anonymous]

Hi,

    I got your point now 🙂

    It looks like a bug and could you please create jira ticket for this issue https://jira.talendforge.org

   If you are an enterprise customer, please create a support case so that they can report the bug on your behalf and fast track the resolution. 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Rimvis]

Hi @nthampi ,

Sorry for not responding for a while. I was about to create a ticket, but I'm not sure which project should I pick. Can you please advise?

Thanks,

Rimvis

[Anonymous]

Hi,

    You can select Studio or Talend Data Integration.

    In case you selected wrong project accidentally, they will change it to right project 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Rimvis]

Thanks @nthampi ,

I have raised an issue: https://jira.talendforge.org/browse/TDI-43136 

Let's see how it will go.

Cheers,

Rimvis

[Rimvis · Accepted solution]

It appears that there is a check box called Use Strict Date Check (in Advanced settings). Validation is working correctly under UTC if this check box is enabled.

[Anonymous]

@nthampi 

Thanks, But if we use String as data type then invalid date like "0000-00-00T00:00:00.000" will be treated as valid date. how to capture this scenario then?

[Anonymous]

It appears that there is a check box called Use Strict Date Check (in Advanced settings). Validation is working correctly under UTC if this check box is enabled.