Hi there,
I'm trying to upgrade from Mifos 2.0.0 to 2.1.3, but I'm getting the error below (full stack attached). Here's what I'm doing (which is likely wrong): 1) Creating new mifos database, following the 2.1.3 instructions as if I were creating a new clean installation. I.e., I'm creating the 'mifos' database, a 'mifos' user, and loading the three sql files (new schema etc) which comes with 2.1.3. After doing this, Mifos will start and is working nicely (but contains no data, of course). 2) Then I dump the mifos volcano from my 2.0.0 installation (mysqldump) and load it into my new 2.1.3 installation. 3) When firing up mifos 2.1.3, I now see the error below. I've looked at the 2.1 upgrade instructions: http://mifosforge.jira.com/wiki/display/MIFOS/Mifos+2.1+Upgrade+Instructions and I do have known issue Mifos-4892 about question groups, but I think that's unrelated - it looks like I can fix that problem by following the instructions. Any help is greatly appreciated. Thanks a lot! - Henrik - CreoCore, www.creocore.org ============================================================================ ==== Mifos Database Error A database error occurred. Correct the error and restart the application. Details: Failed to upgrade database. Unable to apply database upgrades More details: Not implemented - check local.properties file for local overrides Stack trace: java.sql.BatchUpdateException: Table 'variable_installment_details' already exists at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1067) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.ja va:743) at org.mifos.framework.persistence.SqlExecutor.execute(SqlExecutor.java:57) at org.mifos.framework.persistence.SqlUpgrade.runScript(SqlUpgrade.java:46)Title: Mifos Database Error
Mifos Database Error
A database error occurred. Correct the error and restart the application. Details:
Failed to upgrade database. Unable to apply database upgrades
More details:
Not implemented - check local.properties file for local overrides
Stack trace:
java.sql.BatchUpdateException: Table 'variable_installment_details' 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.DatabaseMigrator.applyUpgrade(DatabaseMigrator.java:311) at org.mifos.framework.persistence.DatabaseMigrator.upgrade(DatabaseMigrator.java:158) at org.mifos.framework.persistence.DatabaseMigrator.upgrade(DatabaseMigrator.java:168) at org.mifos.framework.ApplicationInitializer.dbUpgrade(ApplicationInitializer.java:179) at org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java:135) at org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationInitializer.java:122) at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:640) at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:229) at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1208) at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:586) at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:449) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58) at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:36) at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:180) at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:482) at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:135) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:137) at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:50) at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:601) at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:531) at org.eclipse.jetty.util.Scanner.scan(Scanner.java:394) at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:329) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58) at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:114) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58) at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:543) at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:218) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58) at org.eclipse.jetty.util.component.AggregateLifeCycle.doStart(AggregateLifeCycle.java:41) at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:50) at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90) at org.eclipse.jetty.server.Server.doStart(Server.java:258) at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58) at org.eclipse.jetty.xml.XmlConfiguration$1.run(XmlConfiguration.java:1197) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1120) 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.eclipse.jetty.start.Main.invokeMain(Main.java:469) at org.eclipse.jetty.start.Main.start(Main.java:604) at org.eclipse.jetty.start.Main.parseCommandLine(Main.java:265) at org.eclipse.jetty.start.Main.main(Main.java:79)
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
