Announcement

Collapse
No announcement yet.

DefaultEventController error adding event ERROR: relation "event" does not exist

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

  • DefaultEventController error adding event ERROR: relation "event" does not exist

    I keep seeing this error in the Mirth server logs. We recently upgraded from 2.0.1.5389 to 2.1.0.5164. We have it installed on RHEL 5.4 and use Postgres as the local database for Mirth. Did the upgrade require some database scripting? If it did, it didn't fire off during the install using the .sh file.

    [2011-06-17 16:48:34,474] ERROR (com.mirth.connect.server.controllers.DefaultEvent Controller:94): Error adding event.
    com.ibatis.common.jdbc.exception.NestedSQLExceptio n: --- The error occurred in postgres/postgres-event.xml. --- The error occurred while applying a parameter map. --- Check the Event.insert-event-param. --- Check the statement (update failed). --- Cause: org.postgresql.util.PSQLException: ERROR: relation "event" does not exist
    at com.ibatis.sqlmap.engine.mapping.statement.MappedS tatement.executeUpdate(MappedStatement.java:107)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.insert(SqlMapExecutorDelegate.java:393)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.in sert(SqlMapSessionImpl.java:82)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.ins ert(SqlMapClientImpl.java:58)
    at com.mirth.connect.server.controllers.DefaultEventC ontroller.addEvent(DefaultEventController.java:92)
    at com.mirth.connect.server.mule.ExceptionStrategy.lo gException(ExceptionStrategy.java:55)
    at org.mule.impl.DefaultComponentExceptionStrategy.de faultHandler(DefaultComponentExceptionStrategy.jav a:76)
    at com.mirth.connect.server.mule.ExceptionStrategy.de faultHandler(ExceptionStrategy.java:27)
    at org.mule.impl.DefaultExceptionStrategy.handleRouti ngException(DefaultExceptionStrategy.java:40)
    at org.mule.impl.AbstractExceptionListener.exceptionT hrown(AbstractExceptionListener.java:87)
    at org.mule.providers.AbstractMessageReceiver.handleE xception(AbstractMessageReceiver.java:169)
    at com.mirth.connect.connectors.mllp.MllpMessageRecei ver$TcpWorker.run(MllpMessageReceiver.java:360)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor.runWorker(ThreadPoolExecutor.java: 1061)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :575)
    at java.lang.Thread.run(Thread.java:619)Caused by: org.postgresql.util.PSQLException: ERROR: relation "event" does not exist
    at org.postgresql.core.v3.QueryExecutorImpl.receiveEr rorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processRe sults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(Q ueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execut eWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:381)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.execute(DelegatingPreparedStatement.java:172)
    at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteUpdate(SqlExecutor.java:80)
    at com.ibatis.sqlmap.engine.mapping.statement.MappedS tatement.sqlExecuteUpdate(MappedStatement.java:216 )
    at com.ibatis.sqlmap.engine.mapping.statement.MappedS tatement.executeUpdate(MappedStatement.java:94)
    ... 15 more

  • #2
    The schema should have been automatically upgraded when you first started 2.1.0. Was there an error in the log the first time you started 2.1.0? If so, can you post that?
    Jacob Brauer
    Director, Software Development
    NextGen Healthcare

    sigpic

    Comment

    Working...
    X