Fatal error starting FrontlineSMS!

[Moises P Ramirez]

In a laptop with Vista, a start up error ocurred with current version 1.6.16.1. These are the logs reported:

class java.lang.RuntimeException :: Problem initialising application context.
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:144)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)
Caused by: class org.springframework.beans.factory.BeanCreationException :: Error creating bean with name 'dataSource' defined in URL
[file:C:/Users/moises/AppData/Roaming/Microsoft/Windows/FrontlineSMS/properties/hsql.database.xml]:
Error setting property values; nested exception is
org.springframework.beans.PropertyBatchUpdateException; nested
PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property
'driverClassName' threw exception; nested exception is
java.lang.IllegalStateException: Could not load JDBC driver class
[org.hsqldb.jdbcDriver]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1279)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at net.frontlinesms.FrontlineSMS.initApplicationContext(FrontlineSMS.java:175)
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:136)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)
Caused by: class org.springframework.beans.PropertyBatchUpdateException ::
Failed properties: Property 'driverClassName' threw exception; nested
exception is java.lang.IllegalStateException: Could not load JDBC driver
class [org.hsqldb.jdbcDriver]
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:104)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1276)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at net.frontlinesms.FrontlineSMS.initApplicationContext(FrontlineSMS.java:175)
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:136)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)

Please, help us solve it.

[Alex Anderson]

Hi Moises,

The quick way to fix this problem is to rename the ~/FrontlineSMS directory. This will mean your database will appear empty, but we can discuss how to recover your data if that is necessary.

This is a problem with connecting to the database, and I'm sorry the error is not more user-friendly. If we can, we will put in some more handling so that you should be able to edit the database settings to fix the problem at this stage.

It would be very helpful if you could send us your logs, as this will help us understand the exact cause of the issue.

Also, when did this problem occur? Had you just installed a new version of FrontlineSMS? Had you just changed the database settings?

Alex

[Moises P Ramirez]

Thank you Alex!
Should we rename that directory with a specific name or could it be any name? We'd like to install most recent version of FL from scratch, so there is no problem with databases.

Warm regards,



Moises.

[kiwanja]

Hi Moises

You can rename it anything - go for something like FrontlineSMS-Old so you can retrieve it easily if you need to. Make sure FrontlineSMS is shut down when you do this, and once you've done the rename and restarted the software it should create a new folder for you.

Ken

[Morgan Belkadi]

Did that solve your problem, Moises?

[Moises P Ramirez]

Morgan,
Thanks for asking. I have tried several times changing the name of the directory with no success. I'm not sure if I was doing it right. I will try again.
Warm regards,


Moises.

[Morgan Belkadi]

What about now? :)

[Sarah Iribarren]

Hi Ken or whoever may be able to help.

I have been trying to search for solution for a fatal error.  The prior entry looks similar and looks like the individual was unable to fix.  I ended up trying to uninstall FrontlineSMS program and reinstall, however get the same fatal error message. Have not made any changes in the computer since the last time we used program.  Luckily I recently saved all of the patient messages.  However I assume I have lost all contacts, reminder files etc.  We are using program daily so I am a bit concerned at the moment.  We have been using since last October...

 The following is the message.  If you have any suggestions I would be grateful.

thank you Sarah

Fatal error starting FrontlineSMS!

A problem occurred during FrontlineSMS startup.

class java.lang.RuntimeException :: Problem initialising application context.
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:144)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)
Caused by: class org.springframework.beans.factory.BeanCreationException :: Error creating bean with name 'dataSource' defined in URL [file:C:/Users/EstudioPiloto/AppData/Roaming/Microsoft/Windows/FrontlineSMS/properties/hsql.database.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.hsqldb.jdbcDriver]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1279)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at net.frontlinesms.FrontlineSMS.initApplicationContext(FrontlineSMS.java:175)
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:136)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)
Caused by: class org.springframework.beans.PropertyBatchUpdateException :: Failed properties: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [org.hsqldb.jdbcDriver]
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:104)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1276)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at net.frontlinesms.FrontlineSMS.initApplicationContext(FrontlineSMS.java:175)
    at net.frontlinesms.DesktopLauncher.initFrontline(DesktopLauncher.java:136)
    at net.frontlinesms.DesktopLauncher.main(DesktopLauncher.java:94)

[Kavita Rajah]

Hi Sarah,

Did you by chance try renaming the database as suggested to Moises above? I can suggest you give that a try. In the meantime, can you please send us your logs - I can have the developers take a look at it to determine the exact problem.

Thanks!

Kavita

[Sarah Iribarren]

Hi Kavita,

I did try renaming but like Moises with no luck either. What I pasted above is the log that was produced within the error message window. I attempted to send by email through the error message window but it appeared to not be sending.  I did not receive a confirmation that it was sent after attempting a number of times.

Ultimately I ended up restoring computer to prior date loosing data but at least getting the program to function again. But would still like to know what happened in order to avoid or not lose data in the future.

Thank you

Sarah

[Kavita Rajah]

Thanks for letting me know Sarah. Ill check in with the developer team and get back to you.

Kavita

[Alex Anderson]

Hi Sarah,

This seems to be a problem with your database configuration.  Did you recently update FrontlineSMS, or remove any associated files?

The following should allow FrontlineSMS to start normally, although I am not sure if it will read your old data:

Can you try editing the file app.properties in C:/Users/EstudioPiloto/AppData/Roaming/Microsoft/Windows/FrontlineSMS/properties/.

Change the line:

database.config=hsqldb.database.xml

to:

database.config=h2.database.xml

If this works and FrontlineSMS can start, please let us know if you can access your old data.

Alex

[Sarah Iribarren]

Hi Alex,

Thank you for your assistance.  I did not recently update FrontlineSMS or remove any associated files at least intentionally. 

Prior to getting your message I ended up restoring computer to prior date and was able to get it to work again thankfully and appeared to keep the data even a few days after the selected restore date?  I had also exported/saved messages so I have not lost data.  I attempted to find the app.properties in case I need to change name again and was unable to identify the listing above.  That is, I did not find AppData after selecting all options within 'EstudioPiloto'. Not sure if this route would have been reconfigured with the restore? 

Another issue with our program, that I have mentioned in a previous post, is reminders we set up are only automatically sent when the date is set for the same day for which it was programed.  Any date in the future is not being sent automatically and we need to manually select 'resend' for each reminder.  Could there be something in our settings in which once the program is closed down for the day will not retain settings or is there another possible issue that you can think of?

Thank you again for your time and assistance.  Overall FrontlineSMS working great for us and our patients!

Sarah