Rejects option unavailable on tMySQLOutput (Update action)

Highlighted
Six Stars

Rejects option unavailable on tMySQLOutput (Update action)

Hi all,

 

I'm trying to obtain Rejects output out of tMySQLOutput component. No problem with Insert action. However, when I set it to Update, only output available is Main.

I've seen some suggestion to turn off "Use Batch", but I can't see it anywhere in the settings. Setting "Batch Size" to 0 or -1 does not help.

 

tMySQLOutput_basic_options.pngtMySQLOutput_adv_options.png

 

 


Accepted Solutions
Moderator

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hello @Rimvis 

Please try to use "Updata and insert" action on data instead of "Update" to see if this "Rejects" row is available?

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.

All Replies
Moderator

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hello,

Please un-check the "Extend Insert" in the Advanced Settings of component. Then the rejects link can be chosen.

1.png

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hi @xdshi ,

 

i'm sorry, but there is no "Extended Insert" option in my case. Please check the screenshot.

 

Thanks,

Rimvis

Moderator

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hello @Rimvis 

Please try to use "Updata and insert" action on data instead of "Update" to see if this "Rejects" row is available?

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hi @xdshi 

 

Talend Open Studio for Data Integration

Version: 7.1.1

Moderator

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hello @Rimvis 

Please try to use "Updata and insert" action on data instead of "Update" to see if this "Rejects" row is available?

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hi @xdshi ,

 

Yes, Rejects output appears if I switch it to "Update or Insert".

Technically it would work, event all I want to do is updates only.

Do you know if it's a bug on Talend side, or am i missing something in the configuration?

 

Thanks,

Rimvis

Moderator

Re: Rejects option unavailable on tMySQLOutput (Update action)

Hello,

If you are trying to insert or update data in the target database and the data violates any integrity constraints set by the database, you can use the Reject flow from the Output component to capture the records in error. Here’s an example of Retrieving data in error with a Reject link from Talend documentation. Depending on the Output component you use, you may need to disable its ability to process rows in batch.

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

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog