Announcement

Collapse

NextGen Connect 3.10.1 Released!

NextGen (Mirth) Connect 3.10.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes. See the release notes for the list of fixes.

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

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

Do not store the messages process in some channels

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

  • Do not store the messages process in some channels

    Hello, in some channels the messages are process not stored (all types).

    In mirth.log appears repeated the next error:

    ERROR 2007-07-04 16:37:09,726 [c4217319-d708-4913-9a02-2dc92eee3522_destination_1_connector.dispatcher.10] com.webreach.mirth.server.controllers.MessageObjec tController: could not log message: id=6fa07f4a-8bbf-496d-9a32-8a6aa610924b
    com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
    --- The error occurred in derby/derby-message.xml.
    --- The error occurred while applying a parameter map.
    --- Check the Message.insert-message-param.
    --- Check the statement (update failed).
    --- 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'.
    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'.
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeUpdate(GeneralStatement.java:91)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.insert(SqlMapExecutorDelegate.java:447)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.in sert(SqlMapSessionImpl.java:82)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.ins ert(SqlMapClientImpl.java:59)
    at com.webreach.mirth.server.controllers.MessageObjec tController.writeMessageToDatabase(MessageObjectCo ntroller.java:178)
    at com.webreach.mirth.server.controllers.MessageObjec tController.updateMessage(MessageObjectController. java:153)
    at com.webreach.mirth.server.controllers.MessageObjec tController.setStatus(MessageObjectController.java :517)
    at com.webreach.mirth.server.controllers.MessageObjec tController.setSuccess(MessageObjectController.jav a:493)
    at com.webreach.mirth.server.mule.providers.soap.axis .AxisMessageDispatcher.invokeWebService(AxisMessag eDispatcher.java:234)
    at com.webreach.mirth.server.mule.providers.soap.axis .AxisMessageDispatcher.doDispatch(AxisMessageDispa tcher.java:196)
    at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:257)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Thread.java:595)
    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'.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement. execute(Unknown Source)
    at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteUpdate(SqlExecutor.java:81)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteUpdate(GeneralStatement.java:2 00)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeUpdate(GeneralStatement.java:78)
    ... 14 more

    Caused by:
    ERROR 23505: 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'.
    at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
    at org.apache.derby.impl.sql.execute.IndexChanger.ins ertAndCheckDups(Unknown Source)
    at org.apache.derby.impl.sql.execute.IndexChanger.doI nsert(Unknown Source)
    at org.apache.derby.impl.sql.execute.IndexChanger.ins ert(Unknown Source)
    at org.apache.derby.impl.sql.execute.IndexSetChanger. insert(Unknown Source)
    at org.apache.derby.impl.sql.execute.RowChangerImpl.i nsertRow(Unknown Source)
    at org.apache.derby.impl.sql.execute.InsertResultSet. normalInsertCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.InsertResultSet. open(Unknown Source)
    at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement. execute(Unknown Source)
    at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteUpdate(SqlExecutor.java:81)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteUpdate(GeneralStatement.java:2 00)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeUpdate(GeneralStatement.java:78)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.insert(SqlMapExecutorDelegate.java:447)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.in sert(SqlMapSessionImpl.java:82)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.ins ert(SqlMapClientImpl.java:59)
    at com.webreach.mirth.server.controllers.MessageObjec tController.writeMessageToDatabase(MessageObjectCo ntroller.java:178)
    at com.webreach.mirth.server.controllers.MessageObjec tController.updateMessage(MessageObjectController. java:153)
    at com.webreach.mirth.server.controllers.MessageObjec tController.setStatus(MessageObjectController.java :517)
    at com.webreach.mirth.server.controllers.MessageObjec tController.setSuccess(MessageObjectController.jav a:493)
    at com.webreach.mirth.server.mule.providers.soap.axis .AxisMessageDispatcher.invokeWebService(AxisMessag eDispatcher.java:234)
    at com.webreach.mirth.server.mule.providers.soap.axis .AxisMessageDispatcher.doDispatch(AxisMessageDispa tcher.java:196)
    at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:257)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Thread.java:595)

    The mirth version is 1.5.0, so that it happens that error?

    Thank you.

  • #2
    Reo not store the messages process in some chann

    You've reached the message limit.

    You need to start with a new db: export your channels, and use a new derbydb

    Comment


    • #3
      Reo not store the messages process in some chann

      If you are reaching the message limit then we suggest you switch to a different database, such as PostgreSQL. Our Mirth Appliances use PostgreSQL and for high message volume it is more stable and faster than the embedded Derby DB.

      Jacob

      Post edited by: jacobb, at: 07/05/2007 12:10
      Jacob Brauer
      Director, Software Development
      NextGen Healthcare

      sigpic

      Comment


      • #4
        Reo not store the messages process in some chann

        message limit? I have process only 30.000 messages. What is the limit?

        Ohter question, Is possible to use a Informix database?

        Thank you.

        Comment


        • #5
          Reo not store the messages process in some chann

          AFAIk, you can create ibatis custom files to use Informix

          Comment

          Working...
          X