Announcement

Collapse
No announcement yet.

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