tSchemaComplianceCheck Follows Reject Path but with Zero Rows

[ml1662663516]

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!

[anselmopeixoto]

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.

[Anonymous · Accepted solution]

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

Best regards

Sabrina