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

Reply via email to