Kalum,
I reset the created dates of clients and accounts to 1st September 2013 as
there were a lot of accounts created before clients and clients before
groups etc. This shouldn't have any affect on how mifos works. And the
ETL ran fine then.
Apply the 2 sql commands to your mifos database.
update customer set created_date = "2013-09-01";
update account set created_date = "2013-09-01";
John
On Tue, Dec 17, 2013 at 6:39 AM, Kalum Palihawadana <[email protected]>wrote:
> Hi John
>
> Thank you very much for the response. I followed the error trace using the
> provided link.
>
> Both out files and the dalabase dump can be found in below dropbox public
> link.
>
>
> https://www.dropbox.com/sh/u7geqkf5f55nvan/qmgmyDnMP7
>
> If you need 'root' user id and passwords for the database please let me
> know.
> otherwise the username- mifos, password -mifos
>
>
> Looking forward to a favourable reply.
>
> Thanks and Regards
>
> Kalum
> [email protected]
>
>
>
>
> On Sunday, July 28, 2013 10:01:55 PM UTC+5:30, Thomas (Uganda) wrote:
>>
>> Hello
>>
>> I am trying to run the 11 Datawarehouse Reports. However they show no
>> Data. When I look at the ETLReportDWTaskJob Batch Job it fails every time.
>>
>> >From a quick look at the Log file for the ETL Job, something about ""*Table
>> 'mifosdw.pretend_fallover_table' doesn't exist*"".
>>
>> Has someone been able to have these reports run with Data? Would like to
>> have these with Data as well.
>>
>> Tx
>>
>>
>>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
