No announcement yet.

How to process remaining rows even if one fails

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to process remaining rows even if one fails


    I have a channel that reads data from one database and uses that data to send an email.

    This means, I have following:

    Source --> Database Reader
    Destination1 --> SMTP Sender
    Destination2 --> Database Writer

    In Source I will fetch data like email address.
    Then in Destination1 I will send a message to the email address obtained from Source.
    If nothing goes wrong, then in Destination2 i will reconnect to the same database and change the status from 0 to 1.

    Let's now assume I have 10 rows in my database that need to be processed. Let's assume that row 1 doesn't contain a valid email address. It will fail to send the email and the other 9 rows will not be processed.

    Is there a way to modify this channel that in case if one row fails, the other ones will be processed anyway?

    Thank you.

  • #2
    Normally each row from a database reader is processed as a separate message, so what would prevent the other 9 rows from processing in your scenario?