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
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    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
    Tags: None
  • #2
    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
    Chris Lang

    Comment

    Previous template Next
    Working...
    X

    We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

    By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

    I Agree