web stats
How to process remaining rows even if one fails - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Thread Tools Display Modes
Old 11-20-2018, 01:21 AM
Takuaraa Takuaraa is offline
Mirth Newb
Join Date: Jun 2018
Posts: 6
Takuaraa is on a distinguished road
Default 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.
Reply With Quote
Old 11-21-2018, 05:48 PM
agermano agermano is offline
Mirth Guru
Join Date: Apr 2017
Location: Indiana, USA
Posts: 1,175
agermano is on a distinguished road

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?
Reply With Quote

database reader, database writer, error, smtp sender

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 03:07 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation