Page Comparison

For upgrading follow:-To learn how to upgrade an existing installation of Mifos X, follow this guide: https://github.com/openMF/mifosx/wiki/Installation-FAQ's#upgrading-an-existing-installation-of-mifosx

It 's is highly recommended to take database backup your existing databases before upgrading mifos xMifos X. 

At the time of upgrading mifos x to latest version if you get the error log as " For some users, during upgradation of Mifos X, an error (Migration of schema failed. Like !) might occur, as shown in the screenshot below shown example in screen shot:- 

You should follow below mentioned the following steps to fix the issue:- 

Step 1

: 

Stop the Tomcat server. 

Step 2

: 

For this example, we shall be considering the following error:

In this example, I am This error occurs when upgrading to Mifos X 15.03.1v. Go to the downloaded mifos x folder i.e Mifos X folder: 

Step 3

:

Go to path: mifosplatform-15.03.1.RELEASE\database\migrations\core_db >> then to .

Locate the failed version, i.e., V251 in this example to V251.

Step 4: 

Open the sql SQL script in any text editor like notepad (Notepad++, Sublime Text, etc.):

Step 5:

Please copy the script one by Copy the following SQL scripts one-by-one till the semi-colon (;), like showed as shown in the screenshot below screen shot: 

Image Modified

Step 6:

To make things simpler, this example requires HeidiSQL. (http://www.heidisql.com/download.php) 

Follow the numbers mentioned in the below image & the instructionsinstructions below (the image displays numbers corresponding to the instruction number):

1) Go to the failed database (in this example, it is `mifostenant-default`) and click on it.

2) Click in on the query tab

3) Paste the copied script (1) (from the Step 5 above shown example)

4) Click on >(play) button which will to run the script. 

Step 7:

Follow the numbers mentioned in the image below image & and the corresponding instructions:

1) Go to the table schema_version table .

2) Click on Data.

3) Scroll to version 251251 (In for this example) and make sure the table name is same i.e here the same (like the paymentType_table shown below).

4) Scroll to the right side of the page,. 

5) For The value of the success column it would have been will vary between 0 (zerofor failure) make it and 1 (one) & for success). Change this value to 1 and click on the other table to make it run. 

8) Make sure "that the success" column value has become 1(one). 

Step

8:

Restart the tomcat server,>> Success - you could .

• If the fix is successful, you can now start using Mifos

• X.

• However, if following all the steps doesn't fix the issue, then repeat all the steps

• above.

Similarly, if the migration of schema 'mifosplatform-tenants' to version 2 failed: 

Step 1) Go to path: mifosplatform-15.03.1.RELEASE\database\migrations\list_db >> then to the failed version, in this example to V2 

Step 2) Please copy the script till the semi-colon (;), like showed in the below screen shot: 

Step 3) For easy use - mysql, I have used heide sql (http://www.heidisql.com/download.php) 

Follow the numbers mentioned in the below image & the instructions

1) Go to the failed database in this example it is `mifosplatform-tenants` and click on it.

2) Click in query tab

3) Paste the copied script (1) from the above shown example

4) Click on >(play) button which will run the script. 

Step 4) Scroll to right side of the page, 

For success column it would have been 0(zero) make it 1(one) & and click on the other table to make it run. 

Make sure "success" column value has become 1(one). 

Step 5) : Restart the tomcat server,

>> Success - you could start using Mifos x. 

>> Failed - If the schema version again gets failed for different version then please repeat all the steps again for the newly failed version.    

Related articles