web stats
Intermittent - Invalid state, the Connection object is closed errors - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2016, 06:20 AM
rts rts is offline
Mirth Guru
 
Join Date: Feb 2008
Posts: 215
rts is an unknown quantity at this point
Default Intermittent - Invalid state, the Connection object is closed errors

I realize this isn't a specific Mirth Issue but I am looking for ideas here. We have a Mirth 3.3.2 server running on Linux configured to use a SQL Server DB. We are seeing intermittent "Connection Object Closed" errors. Restarting Mirth seems to resolve the issue but eventually it reoccurs. I have worked with some IT folks who manage the network and as far as they are concerned there are no network connectivity issues.
Anyone have any thoughts on troubleshooting the error below? The current connection timeout value is 15 seconds which seems like a sufficient value.

Thanks in advance !

Destination Connector (Channel Writer) error ERROR MESSAGE: Error routing message to channel id: 3b01d56e-a62e-4570-9dfe-c2396ab7ca7b
com.mirth.connect.donkey.server.channel.ChannelExc eption: com.mirth.connect.donkey.server.channel.ChannelExc eption: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: java.sql.SQLException: Invalid state, the Connection object is closed.
at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1216)
at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:192)
at com.mirth.connect.server.controllers.DonkeyEngineC ontroller.dispatchRawMessage(DonkeyEngineControlle r.java:529)
at com.mirth.connect.connectors.vm.VmDispatcher.send( VmDispatcher.java:157)
at com.mirth.connect.donkey.server.channel.Destinatio nConnector.handleSend(DestinationConnector.java:73 8)
at com.mirth.connect.donkey.server.channel.Destinatio nConnector.process(DestinationConnector.java:436)
at com.mirth.connect.donkey.server.channel.Destinatio nChain.call(DestinationChain.java:155)
at com.mirth.connect.donkey.server.channel.Channel.pr ocess(Channel.java:1653)
at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1156)
at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:192)
at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:170)
at com.mirth.connect.connectors.file.FileReceiver.pro cessFile(FileReceiver.java:351)
at com.mirth.connect.connectors.file.FileReceiver.pro cessFiles(FileReceiver.java:247)
at com.mirth.connect.connectors.file.FileReceiver.pol l(FileReceiver.java:203)
at com.mirth.connect.donkey.server.channel.PollConnec torJob.execute(PollConnectorJob.java:47)
at org.quartz.core.JobRunShell.run(JobRunShell.java:2 13)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:557)
Caused by: com.mirth.connect.donkey.server.channel.ChannelExc eption: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: java.sql.SQLException: Invalid state, the Connection object is closed.
at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1174)
... 16 more
Caused by: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: java.sql.SQLException: Invalid state, the Connection object is closed.
at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. close(JdbcDao.java:2000)
at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.executeTasks(BufferedDao.java:141)
at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:77)
at com.mirth.connect.donkey.server.data.buffered.Buff eredDao.commit(BufferedDao.java:64)
at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1150)
... 16 more
Caused by: java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.JtdsConnection.checkOpen (JtdsConnection.java:1744)
at net.sourceforge.jtds.jdbc.JtdsConnection.getAutoCo mmit(JtdsConnection.java:2187)
at com.zaxxer.hikari.proxy.ConnectionProxy.close(Conn ectionProxy.java:187)
at com.mirth.connect.donkey.server.data.jdbc.JdbcDao. close(JdbcDao.java:1997)
... 20 more
Reply With Quote
  #2  
Old 08-16-2017, 02:52 AM
Jurjan Jurjan is offline
OBX.1 Kenobi
 
Join Date: Feb 2011
Posts: 37
Jurjan is on a distinguished road
Default

Hi RTS,
did you resolve this?

One of my customers is having quite similar issues:

ERROR 2017-08-14 15:40:53,519 [Timer-8] com.mirth.connect.donkey.server.channel.Channel: Error processing message in channel P_ALG_LOKO_LEV01 (b4dc7f64-4e09-4208-bf8a-56a94a9b2e44).
com.mirth.connect.donkey.server.channel.ChannelExc eption: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: java.sql.SQLException: Invalid state, the Connection object is closed.
at com.mirth.connect.donkey.server.channel.Channel.di spatchRawMessage(Channel.java:1173)
at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:191)
at com.mirth.connect.donkey.server.channel.SourceConn ector.dispatchRawMessage(SourceConnector.java:169)
at com.mirth.connect.connectors.file.FileReceiver.pro cessFile(FileReceiver.java:325)
at com.mirth.connect.connectors.file.FileReceiver.pro cessFiles(FileReceiver.java:221)
at com.mirth.connect.connectors.file.FileReceiver.pol l(FileReceiver.java:177)
at com.mirth.connect.donkey.server.channel.PollConnec tor$PollConnectorTask.run(PollConnector.java:131)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)


It is in Mirth 3.2.1 (old, I know...)

This started happening since they moved from the embedded database to a (remote) MS SQL database.
As with you: their network people say there are NO network issues.

I do hope you can hint in the direction of a solution.
Reply With Quote
  #3  
Old 08-17-2017, 01:51 PM
rts rts is offline
Mirth Guru
 
Join Date: Feb 2008
Posts: 215
rts is an unknown quantity at this point
Default

I wish I had an answer but this problem has gone away on it's own. I'm sure it was network related but I have no proof !
Sorry about that
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 11:57 AM.


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