web stats
DefaultEventController error adding event ERROR: relation "event" does not exist - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2011, 01:11 PM
r_kerry r_kerry is offline
OBX.1 Kenobi
 
Join Date: Oct 2007
Posts: 45
r_kerry
Default 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
Reply With Quote
  #2  
Old 06-17-2011, 01:54 PM
jacobb jacobb is offline
Mirth Employee
 
Join Date: Aug 2006
Location: Irvine, CA
Posts: 1,218
jacobb is an unknown quantity at this point
Default

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

Reply With Quote
Reply

Tags
defaulteventcontroller, event, postgres, relation

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 05:05 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation