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
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
Comment