topic Re: tSchemaComplianceCheck - wrong date validation in Talend Studio

tSchemaComplianceCheck - wrong date validation

Anonymous — Thu, 22 Dec 2016 15:56:45 GMT

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...

Re: tSchemaComplianceCheck - wrong date validation

Anonymous — Thu, 22 Dec 2016 16:12:07 GMT

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.

Re: tSchemaComplianceCheck - wrong date validation

Anonymous — Thu, 22 Dec 2016 16:23:03 GMT

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.

Re: tSchemaComplianceCheck - wrong date validation

Anonymous — Thu, 22 Dec 2016 16:29:56 GMT

That could be a defect you have discovered there.