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