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,
bash bi/data_warehouse_health_check.sh <PDI_HOME> <PDI_JOB> <OUTPUT_FILE> e.g. bash bi/data_warehouse_health_check.sh /opt/pentaho/data-integration /home/ubuntu/bi passfail.log