10 August 2012

Hi John,

Applied your advice, Pentaho reports now running correctly. Thanks so much. 


I thought I did not move back and forth the dates. Trying to do entries 1-way 
only, I will be more careful this time. 

As for the government_ID, got an error on running the script in workbench. But 
as long as the duplicates were not the source of problem in Pentaho reports, it 
is not a priority.


Once again, thanks for the help! Have a nice day.


 
Regards,
 
Dale A. Fuertes-Pham
Email:    [email protected]




________________________________
 From: John Woodlock <[email protected]>
To: Dale Fuertes <[email protected]>; [email protected] 
Sent: Friday, August 10, 2012 12:44 PM
Subject: Re: [Mifos-users] HELP: Pentaho reports on Mifos
 
Hi Dale,

Yes, one loan was created on the 28th Jan but approved on the 4th Jan.
I assume this was a computer clock thing.
Anyhow, if you run the sql below in your mysql workbench and then
rerun your initialise_datawarehouse.bat all reports should be fine.

use mifos;
update account
set created_date = '2012-01-04'
where account_id = 123



As for your government_id problem.  There must be a slight bug with
that check on government_id with Mifos 2.4.1 or maybe in previous
versions.  Anyhow, you have ended up with 2 sets of duplicates.  If
you want to manually correct the values run the following in your
mysql workbench

EDIT `mifos_dale`.`customer` where government_id in ('0', '001-043');

Then find the government_id column (about 7 columns from the end) and
edit the values to the ones you want.  Then client the green tick,
apply and finish.


John

On Fri, Aug 10, 2012 at 5:46 AM, Dale Fuertes <[email protected]> wrote:
> 10 August 2012
>
>
> Hi John,
>
> Thanks again for the help on Pentaho reports. The problem on "Data last
> updated on ERROR" was solved in my trial database in laptop.
>
> Just 2 days ago that I have installed in our coop PC both Mifos 2.4.1 and
> Pentaho BI 1.3. I am currently in the process of manual entry of clients and
> accounts starting January 2012 (PC was backdated before installation and
> still is since I am still on January 2012 transactions). So far no problem
> in reports generation the other night. However, last night the same problem
> on "Data last...ERROR" came up on similar problematic reports like before in
> my laptop. Please see attached the mifos_dw log file and database dump file.
>
> Note: Yesterday, after creating a client profile, upon submission I
> encountered a warning that similar item ..{1}.. already exist. I checked and
> found that Government IDs were similar for 2 clients created, typo error.
> However, this cannot be edited anymore. I just continued creating other
> client accounts. This was the only error encountered in mifos since
> installation.
>
> Please advice on what to do, I'll try to follow. Thanks so much
>
>
> Regards,
>
> Dale A. Fuertes-Pham
> Email:    [email protected]
>
> ________________________________
>>> From: John Woodlock <[email protected]>
>>> To: Dale Fuertes <[email protected]>
>>> Cc: [email protected]
>>> Sent: Monday, July 23, 2012 6:34 PM
>>>
>>> Subject: Re: [Mifos-users] HELP: Pentaho reports on Mifos
>>>
>>> Dale,
>>>
>>> There's probably a couple of issues here but first
>>>
>>> 1. run the ETL again now that you have upgraded to 1.3.1 - it produces
>>> a log file output in the same directory.  Can you send that log and a
>>> zip of the database again... directly to me (not the list).
>>>
>>> I assume you run it like:
>>> initialise_datawarehouse.bat mifos_dw
>>>
>>> It takes 2 mins on my laptop.  How much memory have you got on your
>>> machine... 1Gb?
>>>
>>> The XSLT warning message doesn't matter and neither does the chunk
>>> msgs (I get them too)
>>>
>>>
>>>
>>> John
>>>
>>> On Mon, Jul 23, 2012 at 8:20 PM, Dale Fuertes <[email protected]>
>>> wrote:
>>>> 23 July 2012
>>>>
>>>>
>>>> Hi John,
>>>>
>>>> Thanks for taking time help. Below are the updates:
>>>>
>>>> I applied the following:
>>>>
>>>>    Single quotes removed in branch office names
>>>>    Applied sql script
>>>>    Ran ETL in Task Scheduler (completed between 30-60mins)
>>>>    Upgrade from BI 1.2 --> BI 1.3.1
>>>>    Refreshed repository cache in Pentaho before generating reports
>>>>
>>>> Results: (Problems reported before ---> Results now after applying
>>>> above)
>>>>
>>>> --Balance Outstanding (Shows :Data on this report last updated ERROR)
>>>> -->
>>>> No
>>>> data shown --> Same
>>>> --Balance Outstanding by Source of Funds (Shows: Data on this report
>>>> last
>>>> updated ERROR) ---> No data shown --> Same
>>>> --Center Schedule by Loan Officer --> No data shown --> Shows only for
>>>> Loan
>>>> Officer with group/client (Is that expected? Other loan officers with
>>>> schedule but no clients, these not 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. -->
>>>> OK
>>>> NOW
>>>> --Due Vs Collected by Branch/Center/Loan Officer (Shows :Data on this
>>>> report
>>>> last updated ERROR)--> No data shown
>>>> --Source of Funds  (Shows :Data on this report last updated ERROR) --->
>>>> No
>>>> data shown
>>>> --Loan Classification by Product --> Shows the products, but all "0"
>>>> data
>>>> --> Same
>>>> --Loan Officer Detailed (Shows: Data on this report last updated ERROR)
>>>> -->
>>>> No data shown --> Same
>>>> --Loan Officer Performance Summary (Cumulative & During Period) -->All
>>>> "0"
>>>> data and Name of loan officers not shown --> Same
>>>> --MFI Progress --> Shows data on Number of branches existing, all others
>>>> are
>>>> "0"--> Same
>>>> --Mifos Transactions (Detail & Summary) --> Shows only transactions made
>>>> on
>>>> group and group members, none on individual clients ---> OK NOW
>>>> --PPI Client Export - Shows: Found error: [object XMLHttpRequest]
>>>> -parsererror, Error: TypeError: Cannot read property 'documentElement'
>>>> of
>>>> null---> Same
>>>>
>>>> OBSERVATIONS:
>>>> 1. When tomcat loads when pentaho is started, it shows lines with
>>>> 'Warning:
>>>> Running an XSLT 1.0 stylesheet with an XSLT 2.0 processor'
>>>> 2. Whenever I ran a report with note 'Data on this report last updated
>>>> ERROR', tomcat shows "Invalid chunk ignored'.
>>>>
>>>> I do not know if above observations will be helpful, I attached the
>>>> tomcat
>>>> log for today.
>>>>
>>>> At least some reports are ok now. Please advice what can be done for
>>>> others.
>>>> I'll try to follow. 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
>
------------------------------------------------------------------------------
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