web stats
DB Writer Destination issue ASAP - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2019, 01:17 PM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 948
StickyBandit is on a distinguished road
Unhappy DB Writer Destination issue ASAP

How can I get mirth to keep going when it runs into a statement that should just fail. But, the channel gets stuck in reading... and never finishes.

So if you look at this SQL below, sometimes the row_mem_id is there but
sometimes it is not, when it is not, Mirth is hosed/stuck.

How do I fix this. I just want it to keep going, I don't care some update statements don't find any rows to update.

UPDATE membership SET last_send_date = TO_DATE(${row_last_send_date}, 'MM/DD/YYYY HH:MI:SS AM') WHERE mem_id = ${row_mem_id}

Am I missing something here?

Mirth Connect Server 3.6.1
Built on July 13, 2018
Java version: 1.8.0_181
Reply With Quote
  #2  
Old 06-19-2019, 02:47 PM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 948
StickyBandit is on a distinguished road
Question

Okay. Someone had the table or row locked via the database tool Toad.

So, let me update the question. How do we get mirth to just skip or queue a message for later, when it is not able to execute SQL because the column or table is locked?
Reply With Quote
  #3  
Old 06-20-2019, 05:36 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,283
cory_cole is on a distinguished road
Default

Select 'Use JavaScript'. Then put a try catch around it.
Reply With Quote
  #4  
Old 06-20-2019, 10:08 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 967
agermano is on a distinguished road
Default

You would likely have to set a timeout on the connection if you want it to error instead of waiting for a lock to free.
Reply With Quote
  #5  
Old 06-20-2019, 11:46 AM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 948
StickyBandit is on a distinguished road
Default

In the Mirth application, is there a way to do this?
Reply With Quote
  #6  
Old 06-20-2019, 04:56 PM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 967
agermano is on a distinguished road
Default

This problem sounded familiar, and I realized I never answered your question the last time. See your other post https://www.mirthcorp.com/community/...868#post266868
Reply With Quote
Reply

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 08:49 AM.


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