java.sql.SQLException: I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: []

Mirth Project | john voigt | 5 years ago
  1. 0

    While 2 channel were pulling for messages from the SQL database, the sql server did a restart and on the Mirth side there was an exception on two channels as noted in the log "Exception occurred in channel" java.sql.SQLException: I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: [] at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399) at com.mirth.connect.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:266) at org.mule.providers.TransactedPollingMessageReceiver$1.doInTransaction(TransactedPollingMessageReceiver.java:91) at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:72) at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:104) at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:97) at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575) at java.lang.Thread.run(Unknown Source) This was recorder on both channels. The sql recovered but after that point the messages were not being pulled. We stopped the channels and the status of them read "Stopped" Trying to restart the channels we got messages "Error starting the channel due to a problem at one of the endpoints" org.mule.umo.provider.ConnectorException: There is already a listener registered on this connector on endpointUri: jdbc://query. Connector that caused exception is: com.mirth.connect.connectors.jdbc.JdbcConnector@6c1194fa at org.mule.providers.AbstractConnector.registerListener(AbstractConnector.java:500) at org.mule.impl.model.AbstractModel.registerListeners(AbstractModel.java:231) at org.mule.impl.model.AbstractModel.startComponent(AbstractModel.java:493) at org.mule.management.mbeans.ModelService.startComponent(ModelService.java:50) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(Unknown Source) at com.sun.jmx.mbeanserver.PerInterface.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MBeanSupport.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$200(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.GeneratedMethodAccessor674.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) The only way this stopped was to restart the entire service. The channels should have been able fail gracefully from the server stop and be able to pick up instead of leaving the listener "orphaned".

    Mirth Project | 5 years ago | john voigt
    java.sql.SQLException: I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: []
  2. 0

    While 2 channel were pulling for messages from the SQL database, the sql server did a restart and on the Mirth side there was an exception on two channels as noted in the log "Exception occurred in channel" java.sql.SQLException: I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: [] at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399) at com.mirth.connect.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:266) at org.mule.providers.TransactedPollingMessageReceiver$1.doInTransaction(TransactedPollingMessageReceiver.java:91) at org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:72) at org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:104) at org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:97) at org.mule.impl.work.WorkerContext.run(WorkerContext.java:290) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575) at java.lang.Thread.run(Unknown Source) This was recorder on both channels. The sql recovered but after that point the messages were not being pulled. We stopped the channels and the status of them read "Stopped" Trying to restart the channels we got messages "Error starting the channel due to a problem at one of the endpoints" org.mule.umo.provider.ConnectorException: There is already a listener registered on this connector on endpointUri: jdbc://query. Connector that caused exception is: com.mirth.connect.connectors.jdbc.JdbcConnector@6c1194fa at org.mule.providers.AbstractConnector.registerListener(AbstractConnector.java:500) at org.mule.impl.model.AbstractModel.registerListeners(AbstractModel.java:231) at org.mule.impl.model.AbstractModel.startComponent(AbstractModel.java:493) at org.mule.management.mbeans.ModelService.startComponent(ModelService.java:50) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(Unknown Source) at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(Unknown Source) at com.sun.jmx.mbeanserver.PerInterface.invoke(Unknown Source) at com.sun.jmx.mbeanserver.MBeanSupport.invoke(Unknown Source) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(Unknown Source) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.doOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.access$200(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(Unknown Source) at javax.management.remote.rmi.RMIConnectionImpl.invoke(Unknown Source) at sun.reflect.GeneratedMethodAccessor674.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source) at sun.rmi.transport.Transport$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Unknown Source) at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) The only way this stopped was to restart the entire service. The channels should have been able fail gracefully from the server stop and be able to pick up instead of leaving the listener "orphaned".

    Mirth Project | 5 years ago | john voigt
    java.sql.SQLException: I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: []
  3. 0

    How to solve "java.sql.SQLException: Feature not implemented Query"?

    Stack Overflow | 3 years ago | Ruhi Singh
    java.sql.SQLException: Feature not implemented Query: SELECT id, name, active, modified_time, create_time, version, last_modified_by, description, enc_type, settings_blob FROM projects WHERE active=true Parameters: []
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to get HL7 templates for Mirth Connect?

    Stack Overflow | 6 years ago | learner
    java.sql.SQLException: ORA-00911: invalid character Query: SELECT PATIENTINFO.PATIENTID AS PATIENTINFO_PATIENTID, PATIENTINFO.FIRSTNAME AS PATIENTINFO_FIRSTNAME, PATIENTINFO.LASTNAME AS PATIENTINFO_LASTNAME FROM PATIENTINFO; Parameters: []
  6. 0

    java commons dbutils: multi-part identifier could not be bound

    Stack Overflow | 3 years ago | bradvido
    java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier "zz.ps_id" could not be bound. Query: SELECT psq_id, question_text FROM presales_question WHERE psq_id IN(SELECT zz.psq_id FROM productservice_psq as zz WHERE zz.ps_id = ?) Parameters: [1]

    4 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: []

      at org.apache.commons.dbutils.QueryRunner.rethrow()
    2. Apache Commons DbUtils
      QueryRunner.query
      1. org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
      2. org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
      2 frames
    3. com.mirth.connect
      JdbcMessageReceiver.getMessages
      1. com.mirth.connect.connectors.jdbc.JdbcMessageReceiver.getMessages(JdbcMessageReceiver.java:266)
      1 frame
    4. org.mule.providers
      TransactedPollingMessageReceiver$1.doInTransaction
      1. org.mule.providers.TransactedPollingMessageReceiver$1.doInTransaction(TransactedPollingMessageReceiver.java:91)
      1 frame
    5. Mule Core
      TransactionTemplate.execute
      1. org.mule.transaction.TransactionTemplate.execute(TransactionTemplate.java:72)
      1 frame
    6. org.mule.providers
      PollingMessageReceiver.run
      1. org.mule.providers.TransactedPollingMessageReceiver.poll(TransactedPollingMessageReceiver.java:104)
      2. org.mule.providers.PollingMessageReceiver.run(PollingMessageReceiver.java:97)
      2 frames
    7. org.mule.impl
      WorkerContext.run
      1. org.mule.impl.work.WorkerContext.run(WorkerContext.java:290)
      1 frame
    8. Backport of JSR 166
      ThreadPoolExecutor$Worker.run
      1. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1061)
      2. edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:575)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame