Neil,
the application tries to upgrade the database to latest version when
it detects a difference in the database_version value but it looks
like your database already contains tables its trying to create.
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)
Have you done your own database upgrade process and then tried to
deploy 'newer' version of mifos
Regards,
KeithW.
On Thu, Jul 1, 2010 at 10:28 AM, Neil De la Cruz
<[email protected]> wrote:
> 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
>
>
------------------------------------------------------------------------------
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
