Table of Contents |
---|
Overview
http://mifosforge.jira.com/browse/MIFOSBI-218 is the issue that this wiki page relates to.
There are 3 types of health check.
...
Before and After Checks on the Mifos OLTP Database and the Data Warehouse Database
Mifos OLTP Database Pre-ETL 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.
...
Typical problems highlighted include creating accounts before the corresponding clients, lack of account status history, duplicate fees and loan officers.
...
Data Warehouse
...
If the job that brings mifos data into the data warehouse fails... run the attached script mifosUnsuccessfulETL.sql (yet to be attached)
Code Block |
---|
mysql -uUSER -pPASSWORD DATABASENAME < mifosUnsuccessfulETL.sql > mifosUnsuccessfulETLOutput.sql
|
Community members should contact the mifos developer list with the output.
Typical problems highlighted include creating clients before groups.
...
Data Quality Check
The mifos data warehouse suite comes with a job that will check your data warehouse data quality.
...
Code Block |
---|
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 |
Trouble-Shooting if ETL Job Fails
If the job that brings mifos data into the data warehouse fails... run the attached script mifosUnsuccessfulETL.sql
mysql -uUSER -pPASSWORD DATABASENAME < mifosUnsuccessfulETL.sql > mifosUnsuccessfulETLOutput.sql
Typical problems highlighted include creating clients before groups.
Community members should contact the mifos developer list with the output and may need to supply a copy of the mifos database and incomplete data warehouse database for further trouble shooting.