Rejects option unavailable on tMySQLOutput (Update action)

[Rimvis]

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.

[Anonymous]

Hello,

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

Best regards

Sabrina

[Rimvis]

Hi @xdshi ,

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

Thanks,

Rimvis

[Anonymous]

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

[Rimvis]

Hi @xdshi 

Talend Open Studio for Data Integration

Version: 7.1.1

[Anonymous · Accepted solution]

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

[Rimvis]

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

[Anonymous]

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