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]





________________________________
 From: John Woodlock <[email protected]>
To: Dale Fuertes <[email protected]>; [email protected] 
Sent: Monday, July 23, 2012 1:32 PM
Subject: Re: [Mifos-users] HELP: Pentaho reports on Mifos
 
Dale,

I applied the sql script (attached) to your data and the ETL ran and I
could see data for all the reports (however, sometimes I had to use a
future date to pick up data e.g. center schedule by loan officer).

At a command prompt you type

mysql -uUSERNAME -pPASSWORD  mifos < dalefix.sql

or you can copy the lines from the attached file and run it in any sql
GUI you have.

The problem was the use of single quotes in some of the office names
(i.e. its a bug).  However, if you can live without single quotes in
the office name the attached sql fix is all you need to do (it
translates single quotes for `)



As I said previously, I use Mifos BI 1.3.1 and I think you should (and
probably have to) too.

You can get the latest Mifos BI release here (1.3.1):
Mifos BI 
https://ci.mifos.org/hudson/job/bi-1.3.x-archive/lastSuccessfulBuild/artifact/mifos_bi-1.3.1.zip

There's not a single install for mifos BI 1.3.1 but since you have
already installed Mifos BI 1.2 you can upgrade just by unzipping the
downloaded zip and following these instructions.

1/ In your biserver-ce\pentaho-solutions    delete directories
commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports

2/ from unzipped directory mifos_bi-1.3.1\reports    copy directories
commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports
into you biserver-ce\pentaho-solutions

3/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate
   copy *.html into your
biserver-ce\pentaho-solutions\system\pentaho-cdf

4/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate
   copy *.jpg into your
biserver-ce\pentaho-solutions\system\pentaho-cdf\resources\style\images

5/ in your biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes
delete directory org

6/ from unzipped directory mifos_bi-1.3.1\reports\i18n    copy
directory org into your
biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes

7/ in pentaho server, do a Tools/Refresh/Repository Cache before
testing any reports


It's a hassle copying and deleting files but hopefully you'll be fine.
If not, or if there are still issues with your reporting, let me know
and I'll send you back my skype details or some other way that I can
share the screen with you.


John

On Mon, Jul 23, 2012 at 3:21 PM, Dale Fuertes <[email protected]> wrote:
> 23 July 2012
>
>
> Hi John,
>
> Here is the backup file (zip) and log file. Earlier was not zipped, just
> knew of the 750kb limit.
>
> Thanks so much.
>
>
>
> Regards,
>
> Dale A. Fuertes-Pham
> Email:    [email protected]
>
>
>

Attachment: catalina.2012-07-23.log
Description: Binary data

------------------------------------------------------------------------------
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