web stats
All messages disappeared from Mirth dashboard - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2011, 12:30 PM
ramji1501 ramji1501 is offline
Mirth Newb
 
Join Date: Dec 2010
Posts: 19
ramji1501 is on a distinguished road
Unhappy All messages disappeared from Mirth dashboard

Hi, I'm running MirthConnect 2.1.1.5490.
We had some network issues this morning, and I had to restart all services on our linux machines.

I issued './mcservice restart'.
I've done this safely before without any problems.

Then I loaded the Mirthconnect client from my PC.

Everything looked good until I checked the message log from the dashboard. (clicked on deployed channels to view messages)

Everything previous message has disappeared and no new messages are displayed either !


I would greatly appreciate your help in solving this.

Here is part of the exception I get:

[2011-12-14 14:26:09,463] ERROR (com.mirth.connect.server.controllers.DefaultMessa geObjectController:248): could not log message: id=35cf5689-1e69-4f77-a1ea-45b7696f9323
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: No class was registered for identifier 0.
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.DefaultMessag eObjectController.writeMessageToDatabase(DefaultMe ssageObjectController.java:245)
at com.mirth.connect.server.controllers.DefaultMessag eObjectController.updateMessage(DefaultMessageObje ctController.java:185)
at com.mirth.connect.server.controllers.DefaultMessag eObjectController.setStatus(DefaultMessageObjectCo ntroller.java:894)
at com.mirth.connect.server.controllers.DefaultMessag eObjectController.setSuccess(DefaultMessageObjectC ontroller.java:818)
at com.mirth.connect.connectors.jdbc.JdbcMessageDispa tcher.doDispatch(JdbcMessageDispatcher.java:106)
at com.mirth.connect.connectors.jdbc.JdbcMessageDispa tcher.doSend(JdbcMessageDispatcher.java:162)
at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:164)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:191)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:130)
at org.mule.routing.outbound.AbstractOutboundRouter.s end(AbstractOutboundRouter.java:85)
at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:54)
at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:176)
at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:143)
at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:487)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:266)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:225)
at com.mirth.connect.connectors.file.FileMessageRecei ver.processBatchMessage(FileMessageReceiver.java:1 65)
at com.mirth.connect.server.mule.adaptors.DelimitedAd aptor.processBatch(DelimitedAdaptor.java:79)
at com.mirth.connect.connectors.file.FileMessageRecei ver.processBatch(FileMessageReceiver.java:309)
at com.mirth.connect.connectors.file.FileMessageRecei ver.processFile(FileMessageReceiver.java:218)
at com.mirth.connect.connectors.file.FileMessageRecei ver.poll(FileMessageReceiver.java:118)
at org.mule.providers.PollingMessageReceiver.run(Poll ingMessageReceiver.java:97)
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:636)Caused by: java.sql.SQLException: No class was registered for identifier 0.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.g etSQLException(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 .
.
.
.
.
.
Reply With Quote
  #2  
Old 12-14-2011, 04:16 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

I'm not sure what the issue is, but I will be the first to say that you shouldn't be using derby if you're using this in production with messages flowing through. That database in Mirth Connect is only meant for a dev/test/demo environment.
__________________
Jacob Brauer
Director, Software Development
NextGen Healthcare

Reply With Quote
Reply

Tags
dashboard, empty, log, mirthconnect

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 11:36 PM.


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