Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   My database reader channel is only working sporadically (http://www.mirthcorp.com/community/forums/showthread.php?t=215376)

AndyB_HeGRC 01-07-2016 01:14 PM

My database reader channel is only working sporadically
 
We are using Mirth 3.2.2.7694 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.

Thanks!


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

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