[Mifos-developer] Mifos X Upgrade Failed

[Zayyad A. Said]

Devs,

 

Tried upgrading from 1.24 to 1.26 and it failed.

 

Kindly find attached the error log for your review.

 

Kindly advise where we went wrong or what could be the issue that contributed to the errors.

 

Regards;

 

 

*******

Zayyad A. Said | Managing Director

 

Cell No.: +254 716 615274 | Skype: zsaid2011

Email: zay...@intrasofttechnologies.com 

 

[Sangamesh Nadagoudar]

Hello Zayyad, 

The error is due to schema version is getting failed:- Migration of schema `mifosplatform-tenants` to version 2 failed!

Solution: 

You need to make it success by running the below mentioned script using mysql.  

Use `mifosplatfrom-tenants`;

update schema version set success=1 where version=2

Thanks,

Sangamesh

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Mifos-developer mailing list
mifos-d...@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

[Sangamesh Nadagoudar]

Zayyad, 

Please restart the tomcat server, after running the script. It should work. 

Thanks,

Sangamesh

[Vishwas Babu A J]

Zayyad,

The install instructions has a separate section for upgrade from 1.24.*, https://github.com/openMF/mifosx/blob/develop/INSTALL.md#3221-special-instructions-for-those-upgrading-from-version-124-or-lower

Regards,

Vishwas

On Apr 11, 2015, at 6:00 AM, Sangamesh Nadagoudar <sang...@confluxtechnologies.com> wrote:

Zayyad, 

Please restart the tomcat server, after running the script. It should work. 

Thanks,

Sangamesh

On Sat, Apr 11, 2015 at 6:26 PM, Sangamesh Nadagoudar <sang...@confluxtechnologies.com> wrote:

Hello Zayyad, 

The error is due to schema version is getting failed:- Migration of schema `mifosplatform-tenants` to version 2 failed!

Solution: 

You need to make it success by running the below mentioned script using mysql.  

Use `mifosplatfrom-tenants`;

update schema version set success=1 where version=2

Thanks,

Sangamesh

On Sat, Apr 11, 2015 at 5:56 PM, Zayyad A. Said <zay...@intrasofttechnologies.com> wrote:

Devs,

 

Tried upgrading from 1.24 to 1.26 and it failed.

 

Kindly find attached the error log for your review.

 

Kindly advise where we went wrong or what could be the issue that contributed to the errors.

 

Regards;

 

 

*******

Zayyad A. Said | Managing Director

 

Cell No.: +254 716 615274 | Skype: zsaid2011

Email: zay...@intrasofttechnologies.com 

<image001.jpg>

 

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Mifos-developer mailing list
mifos-d...@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_

source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SFMifos-developer mailing list

[Dickson Njoroge]

schema_version needs to be updated with the details of this patch by executing the scripts below

mysql -u[your username] -p[your password]

use `mifosplatform-tenants`;

INSERT INTO `schema_version` (`version_rank`, `installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`, `installed_on`, `execution_time`, `success`) VALUES

  (2, 2, '2', 'externalize-connection-properties', 'SQL', 'V2__externalize-connection-properties.sql', 210473669, 'root', '2014-10-12 22:13:51', 661, 1);

This body part will be downloaded on demand.

This body part will be downloaded on demand.

[Chriss Mwadime]

Hi,

Errors still arising as i am upgrading from mifosx 1.24 to 1.26,

i have attached an error file to see..

Let me know what to do next as i have followed the guideline as suggested.

Regards

Chriss

[Dickson Njoroge]

Hello Criss,

have you tried used this process?

Upgrading an existing installation of MifosX

1) Download the latest version fromhttp://sourceforge.net/projects/mifos/files/latest/download?source=files and unzip its contents

2) Delete "mifosng-provider.war" and "mifosng-provider" folder from tomcat/webapps and replace them with the latest copy of "mifosng-provider.war" from the release downloaded in the previous step.

3) Delete "community-app" and "api-docs" folders from \tomcat\webapps\ROOT and replace the same with the latest versions from the release downloaded earlier.

If you are updating from version 1.24.0 or lower, follow the special instructions athttps://github.com/openMF/mifosx/blob/develop/INSTALL.md#2221-special-instructions-for-those-upgrading-from-version-124-or-lower

Special Instructions for those upgrading from version 1.24.* or lower

Starting from version 1.25.* , updates to mifosplatform-tenants database are managed by Flyway (http://flywaydb.org/). To ensure that flyway works correctly, verify that table schema_version is present along with two entries in mifosplatform-tenants database.

You can do so as follows

mysql -uroot -pmysql

use `mifosplatform-tenants`;

select * from schema_version;

If the table does not exist, create the same using the script at https://gist.github.com/vishwasbabu/dc105b6a9450cff8ff1f

Next, check if the patch for "externalizing mysql connection properties" has been run (i.e if you are updating from 1.21 or a higher version of Mifos X)

mysql -uroot -pmysql

use `mifosplatform-tenants`;

select pool_initial_size from tenants;

If the above query does not throw an error (Unknown column 'pool_initial_size'), schema_version needs to be updated with the details of this patch by executing the scripts below

mysql -uroot -pmysql

use `mifosplatform-tenants`;

INSERT INTO `schema_version` (`version_rank`, `installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`, `installed_on`, `execution_time`, `success`) VALUES

  (2, 2, '2', 'externalize-connection-properties', 'SQL', 'V2__externalize-connection-properties.sql', 210473669, 'root', '2014-10-12 22:13:51', 661, 1);

4) Restart tomcat ( this automatically updates the database for the latest release)

Regards,

Dickson Njoroge

[Chriss Mwadime]

Hello Dickson,

Thanks for the feedback but unfortunately i had used this process as suggested.

Regards,

Chriss

[Vishwas Babu A J]

Chriss,

Your previous error  seems to have been  resolved.

This current error you are facing (extracted from your log) is :

Migration of schema `mifostenant-default` to version 181 failed! Please restore backups and roll back database and code!

You can fix the same as follows :

1) Locale the the script with  prefix V181 at https://github.com/openMF/mifosx/blob/develop/mifosng-provider/src/main/resources/sql/migrations/core_db

In this case: https://github.com/openMF/mifosx/blob/develop/mifosng-provider/src/main/resources/sql/migrations/core_db/V181__standing_instruction_logging.sql

2) Try replaying this script again and resolve any errors you face (maybe the table is already present etc)

3) Once you confirm that this script has run successfully (or that the changes it seeks to make are already present in your database) , you would proceed to tell Mifos X that this patch has been successfully applied as follows:

In `mifostenant-default` , find the entry from “schema_version table” where the successful application of this patch is being tracked

Ex: select * from schema_version where script like "V181_%”; (notice that the value of “success” would be set to false or 0)

Update “succes” to “1” (i.e true)

Ex: update schema_version set success=1 where script like "V181_%”

Regards,

Vishwas

On Apr 12, 2015, at 11:58 PM, Chriss Mwadime <chriss....@intrasofttechnologies.com> wrote:

<New Text Document.txt>

[Vishwas Babu A J]

*missed out some details

Once you are done with this process, you would have to restart the server and mifosX would then proceed with updating the remaining database patches

Regards,

Vishwas