Announcement

Collapse

Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Mirth does not log messages anymore

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • chrisl
    replied
    Re:Mirth does not log messages anymore

    You should switch to one of the external databases (we recommend Postgre). The Derby database is not recommended for high message volume or large loads.

    -Chris

    Leave a comment:


  • pitchfork
    started a topic Mirth does not log messages anymore

    Mirth does not log messages anymore

    Hello.

    After some weeks working with Mirth with different applications, Mirth doesn`t log messages anymore. Although it still works, when I go to the "view messages" (right click in a channel) window in the dashboard, it is empty.

    Opening the wrapper.log I get this error.

    can anyone help me?

    INFO | jvm 1 | 2007/06/11 17:22:25 | ERROR 2007-06-11 17:22:25,138 [c509a154-b844-454c-a88f-df8d137ed619_source_connector._jdbcEndpoint#-512262688.receiver.3] com.webreach.mirth.server.controllers.MessageObjec tController: could not log message: id=9fbe7c90-e4e4-44d6-84f1-bd81a063548d
    INFO | jvm 1 | 2007/06/11 17:22:25 | com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
    INFO | jvm 1 | 2007/06/11 17:22:25 | --- The error occurred in derby/derby-message.xml.
    INFO | jvm 1 | 2007/06/11 17:22:25 | --- The error occurred while applying a parameter map.
    INFO | jvm 1 | 2007/06/11 17:22:25 | --- Check the Message.insert-message-param.
    INFO | jvm 1 | 2007/06/11 17:22:25 | --- Check the statement (update failed).
    INFO | jvm 1 | 2007/06/11 17:22:25 | --- Cause: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL070524042827070' defined on 'MESSAGE'.
    INFO | jvm 1 | 2007/06/11 17:22:25 | Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL070524042827070' defined on 'MESSAGE'.
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeUpdate(GeneralStatement.java:91)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.insert(SqlMapExecutorDelegate.java:447)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.in sert(SqlMapSessionImpl.java:82)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.ins ert(SqlMapClientImpl.java:59)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.webreach.mirth.server.controllers.MessageObjec tController.writeMessageToDatabase(MessageObjectCo ntroller.java:178)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.webreach.mirth.server.controllers.MessageObjec tController.updateMessage(MessageObjectController. java:153)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.transform(JavaScriptTransformer.ja va:283)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.transformers.AbstractEventAwareTransforme r.doTransform(AbstractEventAwareTransformer.java:4 8)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:200)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:200)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.routing.inbound.SelectiveConsumer.isMatch (SelectiveConsumer.java:61)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:79)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:492)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:271)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:234)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageReceiver.processMessage(JdbcMessageReceiver .java:149)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.providers.TransactedPollingMessageReceive r$MessageProcessorWorker.doInTransaction(Transacte dPollingMessageReceiver.java:159)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:72)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.providers.TransactedPollingMessageReceive r$MessageProcessorWorker.run(TransactedPollingMess ageReceiver.java:149)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at java.lang.Thread.run(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL070524042827070' defined on 'MESSAGE'.
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at org.apache.derby.impl.jdbc.EmbedPreparedStatement. execute(Unknown Source)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteUpdate(SqlExecutor.java:81)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteUpdate(GeneralStatement.java:2 00)
    INFO | jvm 1 | 2007/06/11 17:22:25 | at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeUpdate(GeneralStatement.java:78)
    INFO | jvm 1 | 2007/06/11 17:22:25 | ... 24 more
Working...
X