Attached is an update script which, if you run it against your mifos database, will allow you to run the ETL without data errors.
Moving dates forward and backward will cause problems as the ETL builds an historical database e.g. doesn't like loans created before clients or loans being cancelled before being disbursed (due to moving computer dates around) Obviously, as this is your test database you can do what you like with it but if you want to see the datawarehouse related reports it's probably best to apply the fix and run the ETL once so you can see them... then don't run it again if you move dates around a lot. As for the date error... I didnt get it for the full ETL or the incremental version... but if you want to run bits of the ETL on their own an example of the date format expected is 2011/07/04 00:00:00.000 John On Thu, Nov 17, 2011 at 3:30 AM, HT Team <i...@hugotechnologies.com> wrote: > Hi John > > Please find attached the log file. > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > >
ETLFix.sql
Description: Binary data
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
