Hello all
I've been lurking for a month or so, running up a trial system for a
potential new MFI (NOT in New Zealand :).
I can't give out any details just now due to commercial sensitivities, but
will provide a full profile as soon as I can. It's a brand new operation, so
there will be no data migration component, targeted at starting in the
second half of the year.
My role is to provide advice and guidance on the IT systems. Mifos appears
to be a very good fit.
While I'm not a Java programmer, I have been in the business for over 30
years in a variety of training, technical, management, marketing and sales
roles. My current day job is project management.
We currently have a test system running in the following environment:
Web Server
----------
PIII 933 MHz, 2 GB memory, Debian etch, Apache 2.2.3, Tomcat 5.5, Java
1.5.0_13, ant 1.7.0
Database Server
---------------
PIII 500 MHz, 768 MB memory, Debian etch, MySQL 5.0.32
If anyone would like a Debian installation HOWTO let me know and I'll post
it once I've sorted out the last issue with Tomcat security.
The Problem
-----------
Connecting to Mifos after the upgrade returns the information below, rather
than the logon screen.
Searching the server for the file "upgrade_to_169.sql" returns no results.
It looks to me as if either the application dependency on database version
is incorrect or the database upgrade script is missing.
Can someone please advise if there is a problem, or have I done something
wrong?
The build completed OK (once I remembered to change the time zone to
US/Pacific - refer to issue 1491), passing all unit tests, although I
generally take the short cut approach (ant clean compile copy_files war).
Regards
Graeme
Error on launching Mifos (revision 12246)
------------------------
Mifos Database Upgrade Error
The system was not able to automatically upgrade the database. Correct the
error and restart the application. More about database upgrades.
Database Version = 168
Application Version = 169
Here are details of what went wrong:
java.lang.RuntimeException: error in upgrading to 169
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(D
atabaseVersionPersistence.java:407)
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(D
atabaseVersionPersistence.java:380)
at
org.mifos.framework.ApplicationInitializer.syncDatabaseVersion(ApplicationIn
itializer.java:193)
at
org.mifos.framework.ApplicationInitializer.init(ApplicationInitializer.java:
62)
at
org.mifos.framework.ApplicationInitializer.contextInitialized(ApplicationIni
tializer.java:51)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
3763)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
59)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
at
org.apache.catalina.startup.HostConfig.check(HostConfig.java:1190)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:119)
at
org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
1305)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1569)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1578)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1558)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Duplicate entry '8' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement
.java:1125)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStateme
nt.java:677)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.mifos.framework.persistence.Upgrade.execute(Upgrade.java:156)
at
org.mifos.application.master.persistence.Upgrade169.upgrade(Upgrade169.java:
68)
at
org.mifos.framework.persistence.DatabaseVersionPersistence.upgradeDatabase(D
atabaseVersionPersistence.java:404)
... 20 more
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
