...
http://mifosforge.jira.com/browse/MIFOSBI-218 is the issue that this wiki page relates to.
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 > mifosPrecheckOutput.sql
|
...
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 > mifosUnsuccessfulETLOutput.sql |
Typical problems highlighted include creating clients before groups.
...