It's highly recommended to take database backup before upgrading mifos x.
At the time of upgrading mifos x to latest version if you get the error log as " Migration of schema failed. Like in the below shown example in screen shot:-
You should follow below mentioned steps to fix the issue:-
Step 1) Stop tomcat server.
Step 2) I am using above same example that is:- Migration of schema `mifostenant-default` to version 251 failed!
In this example, I am upgrading to Mifos X 15.03.1v. Go to downloaded mifos x folder i.e
Step 3)
Go to path: mifosplatform-15.03.1.RELEASE\database\migrations\core_db >> then to the failed version, in this example to V251
Step 4:
Open the sql script in text editor like notepad++
Step 5:
Please copy the script one by one till the semi-colon (;), like showed in the below screen shot:
Step 6: 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 `mifostenant-default` 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.
Note:- If the table already exists it will give the error message as table already exists otherwise it will create. Irrespective of the table already exists or not you need run all the scripts one by one for example mentioned in the step 5 need to copy next script i.e 2nd, then 3rd and so on till all are sql scripts are executed.
Step 7: Follow the numbers mentioned in the below image & the instructions:
1) Go to schema_version table
2) Click on Data
3) Scroll to version 251(In this example) and make sure the table name is same i.e here paymentType_table.
Scroll to right side of the page,
5) For success column it would have been 0(zero) make it 1(one) & and click on the other table to make it run.
8) Make sure "success" column value has become 1(one).
Step 7: 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.
In the same way 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