...
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
...
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 data date backwards and forwards.
Data Warehouse Data Quality Check
...