...
http://mifosforge.jira.com/browse/MIFOSBI-218 is the issue that this wiki page relates to.
Note: Further changes to the checking scripts won't be attached to this wiki page but are available from the bi git repository in directory ETL/scripts.
Before and After Checks on the Mifos OLTP
...
and
...
Data Warehouse
...
Databases
Mifos OLTP Database Pre-ETL Check
...
| Code Block |
|---|
mysql -uUSER -pPASSWORD OLTP_DATABASENAME < mifosPrecheck.sql > mifosPrecheckOutputmifosPrecheck.sqlout |
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, lack of account status history, duplicate fees and loan officers... mostly due to initial migration into mifos needs or moving the system date backwards and forwards.
Data Warehouse Data Quality Check
...
Trouble-Shooting if ETL Job Fails
If the job that brings mifos data into the data warehouse fails... run the attached script mifosUnsuccessfulETL.sql
| Code Block |
|---|
mysql -uUSER -pPASSWORD DATAWAREHOUSE_DATABASENAME < mifosUnsuccessfulETL.sql > |
...
mifosUnsuccessfulETL.out
|
Typical problems highlighted include creating clients before groups.
...