web stats
My database reader channel is only working sporadically - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 01-07-2016, 12:14 PM
AndyB_HeGRC AndyB_HeGRC is offline
Mirth Newb
Join Date: Dec 2011
Location: Olathe, KS
Posts: 10
AndyB_HeGRC is on a distinguished road
Exclamation My database reader channel is only working sporadically

We are using Mirth and I have a database reader channel which is only working sporadically.

The channel performs
a database reader SQL query against 3 SQL tables A,B,C which have NOT been processed and may return multiple rows
a source transformer that takes the SQL results and formats a SQL Insert into table D
a database writer which opens the database connection, takes the SQL Insert statement from the source transformer, and performs the SQL insert
A post-process SQL statement which updates the rows retrieved as processed

The problem is
only half or so of the inserts into table D are made
no errors appear in the Mirth dashboard
The messages associated to the missing inserts do NOT appear in the dashboard, yet the messages are flagged as processed
This channel is the only process that will update rows in A,B,C as processed

There is no trail to follow in Mirth for the missing messages, so Im not sure what to try next other than inserting multiple loggers to narrow down the problem.

Any and all suggestions are solicited.

Reply With Quote

database reader

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 06:13 AM.

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