Dale,

can you run another backup as the one you sent had a backup per table?  Just do

mysqldump -uUSERNAME -pPASSWORD DATABASENAME > john.sql


The data size you are talking about isn't a problem and should run
through in about a minute or a few minutes max.

As you are on Mifos 2.4.1 you need a later version of the Mifos BI
(i.e. 1.3.1) as there was a field name change after Mifos BI 1.2.
I'll give  you instructions for upgrading once I've run through your
backup.


John

On Mon, Jul 23, 2012 at 2:19 AM, Dale Fuertes <[email protected]> wrote:
> 21 July 2012
>
>
> Hi John,
>
> The previous days I ran it manually by cd'ing into the
> pentahos_mifosbi_1_2_windows folder and entering:
> initialise_datawarehouse.bat
> (https://mifosforge.jira.com/wiki/display/MIFOS/Windows+Mifos+BI+1.2+%28Pentaho%29+Installation+Guide).
> But I also scheduled it in the Windows Task Scheduler for daily processing.
> Reports generated are those mentioned with problems. (OBSERVATION- in the
> ETL Task Schedule note in Last Run Result, it shows--> (0x1). While other
> Windows tasks scheduled have notes shown as -->The operation completed
> successfully (0x0).
>
> I tried to run the ETL manually to check like you've said--> has been ~24hrs
> already, still running. It takes so long with such small trial data I input
> (around 7 clients only, <10 loans made, <10 savings). How long does it
> typically take? Please give example for certain # of clients, daily
> transactions, and hardware if you can. For our cooperative, now just only
> 500 clients. I wonder how long daily processing will take.
>
> Will try to give update once ETL is done. Looking forward to the result of
> the Run you will made on the backup. Thanks so much.
>
>
> Regards,
>
> Dale A. Fuertes-Pham
> Email:    [email protected]
>
>
>
> ________________________________
> From: John Woodlock <[email protected]>
> To: Dale Fuertes <[email protected]>; [email protected]
> Sent: Saturday, July 21, 2012 5:17 PM
>
> Subject: Re: [Mifos-users] HELP: Pentaho reports on Mifos
>
> Dale,
>
> I'll run your backup thru the ETL (which produces the
> datawarehouse)... prob on my Monday.
>
> It doesn't cover all the probs you identify... because some are not to
> do with the datawarehouse but its a start
>
> John
>
> On Sat, Jul 21, 2012 at 7:50 PM, Dale Fuertes <[email protected]>
> wrote:
>> 21 July 2012
>>
>>
>> Hi Nayan,
>>
>> Yes, I just noticed. It shows at the right corner --> Data for this report
>> last updated on ERROR
>>
>> I just checked now if there were issues before on this type of Error.
>> Found
>> these:
>>
>> http://comments.gmane.org/gmane.comp.finance.mifos.devel/12948 (mentioned
>> here by John Woodlock: usually (but not always) as a result of data
>> migration onto mifos or moving system dates back and forth --> However, I
>> didn't do any migration and didn't move system dates.)
>> http://comments.gmane.org/gmane.comp.finance.mifos.user/3328  (Based on
>> this, I am attaching the Mifos Database backup file in case you may need.)
>>
>> Please advice what to do. And possibly how can this be prevented in the
>> future. Thanks so much.
>>
>>
>> Regards,
>>
>> Dale A. Fuertes-Pham
>> Email:    [email protected]
>>
>>
>>
>> ________________________________
>> From: Nayan Ambali <[email protected]>
>> To: Dale Fuertes <[email protected]>; A good place to start for users
>> or folks new to Mifos. <[email protected]>
>> Sent: Saturday, July 21, 2012 3:11 PM
>> Subject: Re: [Mifos-users] HELP: Pentaho reports on Mifos
>>
>> Hi Dale,
>>
>> When you open the report, along with input params you see one more info
>> like
>> "Data for this report last updated on 2012-07-21 at 04:01:08" . Is that
>> info
>> showing some Date or any error message ?
>>
>>
>> Thanks
>> Nayan Ambali
>>
>> On Sat, Jul 21, 2012 at 12:07 AM, Dale Fuertes <[email protected]>
>> wrote:
>>
>> 21 July 2012
>>
>>
>> Hi everyone,
>>
>> I am using Mifos 2.4.1 and Pentaho BI 1.2 Windows. I input in Mifos some
>> branch, centers, loan officers, groups, clients, loans, savings data, and
>> applied PPI survey to try first. Done these in the past couple of days.
>> Encountered some problems below on Pentaho reports.
>>
>> I processed the daily reports first and checked on Pentaho after. Reports
>> below have problems:
>> --Balance Outstanding --> No data shown
>> --Balance Outstanding by Source of Funds ---> No data shown
>> --Center Schedule by Loan Officer --> No data shown
>> --Client Summary -->For PDF: Failed to load; For Excel: Error 6
>> (net::ERR_FILE_NOT_FOUND): The file or directory could not be found.
>> --Loan Classification by Product --> Shows the products, but all "0" data
>> --Loan Officer Detailed --> No data shown
>> --Loan Officer Performance Summary (Cumulative & During Period) -->All "0"
>> data and Name of loan officers not shown
>> --MFI Progress --> Shows data on Number of branches existing, all others
>> are
>> "0"
>> --Mifos Transactions (Detail & Summary) --> Shows only transactions made
>> on
>> group and group members, none on individual clients
>> --PPI Client Export - Shows: Found error: [object XMLHttpRequest]
>> -parsererror, Error: TypeError: Cannot read property 'documentElement' of
>> null
>>
>> I hope there are ways to fix these. Any help or direction will be
>> appreciated. Thanks so much.
>>
>>
>> Regards,
>>
>> Dale A. Fuertes-Pham
>> Email:    [email protected]
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Mifos-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>>
>>
>>
>> --
>> Regards
>> Nayan G. A.
>> 9901154134
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> Mifos-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>
>

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to