Overview
http://mifosforge.jira.com/browse/MIFOSBI-218 is the issue that this wiki page relates to.
There are 3 types of health check.
1/ Mifos database pre-check
Run the attached script mifosPrecheck.sql (yet to be attached) to see if any blocking and/or warning data quality issues are likely to come up when creating the Data Warehouse from the Mifos database.
mysql -uUSER -pPASSWORD DATABASENAME < mifosPrecheck.sql
For blocking issues (and further information on any warning issues) community members should contact the mifos developer list.
Typical problems highlighted include creating accounts before the corresponding clients.
2/ After Unsuccessful Data Warehouse Run
If the job that brings mifos data into the data warehouse fails... run the attached script mifosUnsuccessfulETL.sql (yet to be attached)
mysql -uUSER -pPASSWORD DATABASENAME < mifosUnsuccessfulETL.sql
Community members should contact the mifos developer list with the output.
Typical problems highlighted include creating clients before groups.
3/ After Successful Data Warehouse Run
The mifos data warehouse suite comes with a job that will check your data warehouse data quality.
In ubuntu, go to the bi directory and do..
bash data_warehouse_health_check.sh
(need further help to clean up sh job and clarify the wording that gets someone the the bi directory).