Announcement

Collapse
No announcement yet.

Mirth does not log messages anymore

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

  • 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

  • #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

    Working...
    X