...
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
...
| 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
...
| Code Block |
|---|
mysql -uUSER -pPASSWORD DATAWAREHOUSE_DATABASENAME < mifosUnsuccessfulETL.sql > mifosUnsuccessfulETLOutputmifosUnsuccessfulETL.sqlout |
Typical problems highlighted include creating clients before groups.
...