topic Re: tSchemaComplianceCheck Follows Reject Path but with Zero Rows in Talend Studio

tSchemaComplianceCheck Follows Reject Path but with Zero Rows

ml1662663516 — Fri, 15 Nov 2024 21:41:10 GMT

I am checking the schema of an Excel file.

If the schema is rejected I have a simple tJava that just outputs

"Schema Failed"

The issue I am having is all 6 of my sample data rows are being processed. Zero are failing. But, the

"Schema Failed" output is being displayed in my Run console.

You can see 6 successes and 0 rejects in the screenshot here.

Any idea why the "Schema Failed" would output no matter what?

Thank you!

Re: tSchemaComplianceCheck Follows Reject Path but with Zero Rows

anselmopeixoto — Wed, 14 Jun 2023 01:43:31 GMT

Hi @Mark Lammert

This is the expected behavior of tJava component. The code you write on it is not bound to the flow and it will run even if there is no input row.

For this case, try using tJavaRow instead of tJava.

Re: tSchemaComplianceCheck Follows Reject Path but with Zero Rows

Anonymous — Wed, 14 Jun 2023 07:16:54 GMT

Hello,

If you would like to define some condition ( If the schema is rejected I have a simple tJava that just outputs "Schema Failed), please have a look at RunIf condition instead which triggers a subJob or component in case the condition defined is met.

https://help.talend.com/r/en-US/8.0/studio-user-guide/run-if-connection-settings

Here is a scenario which presents a Job that checks the type, nullability, and length of data from an incoming flow against a defined reference schema, and displays the validation results on the Run console.

https://help.talend.com/r/en-US/8.0/validation/tschemacompliancecheck-tlogrow-tfileinputdelimited-tfileinputdelimited-validating-data-against-schema-standard-component-enterprise-this

Best regards

Sabrina