default report engine is not good for big report
Description
Environment
Attachments
relates to
testing discovered
Activity

萩原秀明 November 29, 2016 at 2:34 AM
Hi,Carlos!
It is I that should say thanks.
See you.
Carlos Ruiz November 28, 2016 at 5:10 PM
Thanks , backed out 76bfe29

Hiep Lq October 16, 2016 at 12:47 PM
thanks

萩原秀明 October 16, 2016 at 2:02 AM
Hi. Hiep!
thank you for reply.
I am not sure but I think that #committed 76bfe29 is related.
If I comment out "m_layout = null" of cleanTempObj() method of ReportEngine.java, it is no problem.

萩原秀明 October 16, 2016 at 1:52 AM
Reproduce:
Step1: Please dispay Report
Step2: Change Print Format.
If print format I changed has other columns in comparison with initial print format.
We can not display some columns.
iDempiere display Error:
Column not found - AD_Column_ID=1000XXX

Hiep Lq October 16, 2016 at 1:49 AM
hi , can you try to revert commit of this issue and run report to find out reason?

萩原秀明 October 16, 2016 at 1:05 AM
My comment mentioned above may be my misunderstanding.
I think this problem may be problem of Print Format.
I change Print Format but can't change data to display.
I think some data to display is missing when change Print Format.
It is difficualt for me to explain in English.
I'll kepp research and report about that later.

萩原秀明 October 16, 2016 at 12:30 AM
Hi, Carlos and Hiep.
I am very interesting in this Ticket.
I respect this action.
So, I updated iDempiere to latest source code and attempt to display report.
I can't find Summary Line in the report.
please see attachment files : SummaryLineInReport.png
I think Related. -> IDEMPIERE-3104:default report engine is not good for big report #committed 76bfe29
It seems that ReportEngine ignore to IsSummarized column of AD_PrintFormatItem table.
But I do not know what is best modification.
So please kindly confirm it.
Thanks in advance.

Hiep Lq September 28, 2016 at 2:55 PM
Thanks . it's ok.
Carlos Ruiz September 28, 2016 at 10:53 AM
, I just committed 76bfe29 as a modified version of your 2 patches but excluding the usage of system configurator (not needed if it was not breaking anything).
Can you please check?
Regards,
Carlos Ruiz
sometime my server is hung for a while.
i assume it's out of memory issue.
by investigate i see default report engine get a lot memory when it render a big report
I test by run idempiere with 3G memory.
I run report "Accounting Fact Details Report" with data of two year.
and PDFWriter get 2.3G memory to save object.
you can see detail on report on attach file