Hi John
It worked for me. Thank you very much for helping.
Now all the jobs are running perfectly.
Best Regards
Kaum
On Tuesday, December 17, 2013 4:26:05 PM UTC+5:30, John Woodlock wrote:
>
> 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]<javascript:>
> > 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] <javascript:>
>>
>>
>>
>>
>> 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] <javascript:>
>> 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
