Hello guys!
I just wonder what this error is all about and what could be the fix. I got
this error after I inserted the Mifos Server data that I got from
http://www.mifos.org/knowledge/resources/qa-testing/mifos_demo_backup.sql.zip/view.
I'm using Mifos 1.5.x.
Failed to upgrade database. Database Version = 220 Application Version =
240.
More details:
java.sql.BatchUpdateException: Table 'imported_transactions_files' already
exists
Using Mifos database connection settings from file(s):
[/home/microbizone/Dev/apache-tomcat-6.0.26/webapps/mifos-webapp/WEB-INF/classes/org/mifos/config/resources/mainDatabase.properties]
Connection
URL=jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8.
Username=mifos. Password=********
Stack trace:
java.lang.RuntimeException: error in upgrading to 221
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(DatabaseVersionPersistence.java:494)
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(DatabaseVersionPersistence.java:472)
at
org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java:160)
at
org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationInitializer.java:126)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:905)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:740)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:500)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:519)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.sql.BatchUpdateException: Table
'imported_transactions_files' already exists
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1067)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.java:743)
at
org.mifos.framework.persistence.SqlExecutor.execute(SqlExecutor.java:57)
at
org.mifos.framework.persistence.SqlUpgrade.runScript(SqlUpgrade.java:46)
at
org.mifos.framework.persistence.SqlUpgrade.upgrade(SqlUpgrade.java:53)
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(DatabaseVersionPersistence.java:492)
... 27 more
Thanks a lot!
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
