Hi Dale,
I don't have a good knowledge of this particular upgrade and its probably
better to get a view from Sol Develo (who support mifos releases) or Hugo
Technologies (who probably did that part of the upgrade).
However, it appears to be related to the new Mifos Acc (accounting) module.
It also appears to be a simple duplicate record problem... meaning it
thinks it has already done the upgrade. So, it might be a simple fix you
can do yourself. The problem seems to be:
Insert into config_key_value(configuration_type,configuration_key,
configuration_value)
values (1,'MisProcessing','01/01/2012')
If you are upgrading in a test environment. You could restore to your
2.4.1 database. Then look in the database for the entry it is complaining
about
select * from config_key_value where configuration_key = 'MisProcessing'
if you don't find it I'd imagine the upgrade is wrong or was run more than
once i.e. you could upgrade again by starting the 2.5 Mifos. If it doesn't
work, the upgrade might have a problem and would need fixing by mifos
support.
John
On Sat, Nov 17, 2012 at 12:22 PM, Dale Fuertes <[email protected]>wrote:
> 17 November 2012
>
>
> Hi,
>
>
> Good day! Just resending our query in the problem/errors encountered in
> upgrading to 2.5. Please see below. Any help is appreciated. Thanks.
>
>
> Regards,
>
> *Dale A. Fuertes-Pham*
>
>
>
> ----- Forwarded Message -----
> *From:* Dale Fuertes <[email protected]>
> *To:* A good place to start for users or folks new to Mifos. <
> [email protected]>
> *Cc:* "[email protected]" <[email protected]>
> *Sent:* Friday, November 9, 2012 11:54 PM
> *Subject:* Upgrade problems for 2.4.1 to 2.5
>
> 9 November 2012
>
>
> Hi,
>
> Good day! I asked Jervis to help our coop in the upgrade of Mifos from
> 2.4.1 to 2.5. Encountered some errors. Please read his comments below. Any
> help appreciated. Thanks.
>
>
> ----
> We were attempting to upgrade our mifos setup from v2.4.1 into v.2.5.0
>
> We were following the instructions found
> here<https://mifosforge.jira.com/wiki/display/MIFOS/Mifos+2.5+Upgrade+Instructions#Mifos2.5UpgradeInstructions-UpgradingnewerversionsofMifos(2.2.x,2.3.x,2.4.x)toMifos2.5.x>
>
> We got into several errors after running the batch file "expand_db.bat".
> Please find below the error logs.
>
> C:\mifos\mifos-v2.5.0\db\bin>expand_db.bat
> INFO 11/9/12 11:40 PM:liquibase: Successfully acquired change log lock
> INFO 11/9/12 11:40 PM:liquibase: Reading from `mifos`.`DATABASECHANGELOG`
> INFO 11/9/12 11:40 PM:liquibase: Reading from `mifos`.`DATABASECHANGELOG`
> SEVERE 11/9/12 11:40 PM:liquibase: Change Set
> changesets/changelog-Release_J.xml
> ::MIFOSACC::Hugo Technologies failed. Error: Error executing SQL Insert
> into co
> nfig_key_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key'
> liquibase.exception.DatabaseException: Error executing SQL Insert into
> config_ke
> y_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key'
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
> at
> liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:107
> 5)
> at
> liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
> e.java:1059)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
> at
> liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
> )
> at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
> at liquibase.Liquibase.update(Liquibase.java:113)
> at
> liquibase.integration.commandline.Main.doMigration(Main.java:779)
> at liquibase.integration.commandline.Main.main(Main.java:133)
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
> ption: Duplicate entry 'MisProcessing' for key 'configuration_key'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> rce)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
> at
> liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
> tement(JdbcExecutor.java:92)
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
> ... 9 more
> INFO 11/9/12 11:40 PM:liquibase: Successfully released change log lock
> Liquibase Update Failed: Error executing SQL Insert into config_key_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key'
> SEVERE 11/9/12 11:40 PM:liquibase: Error executing SQL Insert into
> config_key_va
> lue
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key'
> liquibase.exception.MigrationFailedException: Migration failed for change
> set ch
> angesets/changelog-Release_J.xml::MIFOSACC::Hugo Technologies:
> Reason: liquibase.exception.DatabaseException: Error executing SQL
> Insert i
> nto config_key_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key':
> Caused By: Error executing SQL Insert into config_key_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key':
> Caused By: Duplicate entry 'MisProcessing' for key
> 'configuration_key'
>
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
> at
> liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
> )
> at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
> at liquibase.Liquibase.update(Liquibase.java:113)
> at
> liquibase.integration.commandline.Main.doMigration(Main.java:779)
> at liquibase.integration.commandline.Main.main(Main.java:133)
> Caused by: liquibase.exception.DatabaseException: Error executing SQL
> Insert int
> o config_key_value
> (configuration_type,configuration_key,
> configuration_value) values
> (1,'MisProcessing','01/01/2012'): Duplicate entry
> 'MisPr
> ocessing' for key 'configuration_key'
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
> at
> liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:107
> 5)
> at
> liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
> e.java:1059)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
> ... 5 more
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
> ption: Duplicate entry 'MisProcessing' for key 'configuration_key'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source)
>
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
> rce)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
> at
> liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
> tement(JdbcExecutor.java:92)
> at
> liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
> ... 9 more
>
>
> For more information, use the --logLevel flag)
>
> C:\mifos\mifos-v2.5.0\db\bin>
>
>
> Regards,
>
> *Dale A. Fuertes-Pham*
>
>
>
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
