tSchemaComplianceCheck - wrong date validation

One Star

tSchemaComplianceCheck - wrong date validation

Hello,
I am on Talend Open Studio for Data Integrtion (6.1.1.20151214_1327).
When I set tSchemaComplianceCheck to verify a date field (field is set to be not nullable) and I pass it value '0000-00-00' then I get following result:
- I get java IllegalArgumentException: YEAR thrown into console
- records is passed OK, and moves to Main flow
Use Fastest Date check option is selected.
Is there any workaround fot that? For me this makes tSchemaComplianceCheck completely useless...
Community Manager

Re: tSchemaComplianceCheck - wrong date validation

Can you show us how this is configured? This doesn't sound right but you haven't quite given enough info to work out what might be happening. A screenshot of your job and the configuration of the component generating the data (if any), the component before the schema check, the schema check and the component after the schema check would be great.
One Star

Re: tSchemaComplianceCheck - wrong date validation

I narrowed it down (I think) to "Use Fastest Date check" option". When I turn it off then validations seems to work correctly
I will test it further and if anything arises I will post here.
Community Manager

Re: tSchemaComplianceCheck - wrong date validation

That could be a defect you have discovered there.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download