topic Re: Rejects option unavailable on tMySQLOutput (Update action) in Talend Studio

Rejects option unavailable on tMySQLOutput (Update action)

Rimvis — Sat, 16 Nov 2024 04:32:03 GMT

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.

Re: Rejects option unavailable on tMySQLOutput (Update action)

Anonymous — Mon, 30 Sep 2019 09:46:07 GMT

Hello,

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

Best regards

Sabrina

Re: Rejects option unavailable on tMySQLOutput (Update action)

Rimvis — Mon, 30 Sep 2019 09:48:31 GMT

Hi @xdshi ,

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

Thanks,

Rimvis

Re: Rejects option unavailable on tMySQLOutput (Update action)

Anonymous — Mon, 30 Sep 2019 09:51:45 GMT

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Rimvis — Mon, 30 Sep 2019 09:58:32 GMT

Hi @xdshi

Talend Open Studio for Data Integration

Version: 7.1.1

Re: Rejects option unavailable on tMySQLOutput (Update action)

Anonymous — Mon, 30 Sep 2019 09:59:33 GMT

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Rimvis — Mon, 30 Sep 2019 10:29:02 GMT

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

Re: Rejects option unavailable on tMySQLOutput (Update action)

Anonymous — Tue, 01 Oct 2019 02:01:19 GMT

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