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