Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Capture tSchemaComplianceCheck rejects

Highlighted
One Star

Capture tSchemaComplianceCheck rejects

Why does putting a tFileOutputDelimited or a tLogRow on the rejects output of a tSchemaComplianceCheck produces dud code that wont compile?

Highlighted
Moderator

Re: Capture tSchemaComplianceCheck rejects

Hi,
Have you tried to click "Sync column" on tLogrow component to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Capture tSchemaComplianceCheck rejects

Yup, tried that sync thing & also tried upgrading to TOS v6.2.1. 
Still no success.
Highlighted
Moderator

Re: Capture tSchemaComplianceCheck rejects

Hi,
We cannot repro your issue on our side. Can you replace tlogrow with tfileoutputdelimited component or re-drag a new tlogrow component to see if this issue still repro?
How did you set your tSchemaComplianceCheck component?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Capture tSchemaComplianceCheck rejects

Thank you.  I tried deleting & creating a new tLogRow with same results.
No luck with a tFileOutputDelimited either ( this is what I really want to use, the tLogRow was just for debugging ).
With the tFileOutputDelimited i left the schema as it suggested, and have tried to show it in the screen grab. 



 


*I did erase a few column names from the image though.
Highlighted
Moderator

Re: Capture tSchemaComplianceCheck rejects

Hi,
How did you set your tSchemaComplianceCheck component? Did you use any custom defined in it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Capture tSchemaComplianceCheck rejects

I used the schema from the Metadata Table schemas, out of the database. 
No custom fields defined.
Highlighted
Moderator

Re: Capture tSchemaComplianceCheck rejects

Hi,
We have received your .zip file and will come back to you asap.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Moderator

Re: Capture tSchemaComplianceCheck rejects

Hi,
The issue of “Rejects” row from tschemacompliancecheck component is caused by the custom java code in tjavaflex.

The tschemacompliancecheck component can work if disable tjavaflex component in work flow.
Could you please take a look at your job to see if it is Ok with you?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog