0029033: The multidimensional tax report takes long to show results.

Description

When executing the multidimensional tax report not for aprm (release 2.50)
the report takes long to shown data.

Many time is expend on the following method:
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITREInvoiceTaxReportDao.getInvoices(OBITREInvoiceTaxReportDao.java:798)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITREInvoiceTaxReportDao.getTransactions(OBITREInvoiceTaxReportDao.java:880)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITREInvoiceTaxReportDao.mergeDataDetailSales(OBITREInvoiceTaxReportDao.java:867)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITRE_InvoiceTaxReportJR.calculateSalesOperations(OBITRE_InvoiceTaxReportJR.java:308)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITRE_InvoiceTaxReportJR.printPageData(OBITRE_InvoiceTaxReportJR.java:210)
    at org.openbravo.module.invoiceTaxReportEnhanced.ad_reports.OBITRE_InvoiceTaxReportJR.doPost(OBITRE_InvoiceTaxReportJR.java:111)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:483)

Steps To Reproduce

-On an environment with big amount of data execute the invoice dimensional tax report for all the year.
*It takes long and consume a lot of resources.
Takes more than 30 minutes to get the report

Tags

Performance

Attached Files

threaddump-1424712290653.tdump [^] (29,205 bytes) 2015-02-23 18:25

visualvm.png [^] (181,548 bytes) 2015-02-23 18:26

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0074954) egoitz (developer) 2015-02-26 10:28	In the environment with have after 2 hours the report is not shown.

(0077756) aferraz (developer) 2015-05-26 13:03	Issue rejected because Multidimensional Tax Report module (org.openbravo.module.invoiceTaxReportEnhanced) is obsolete and is no longer supported. Multidimensional Tax Report OB3 (org.openbravo.module.invoiceTaxReportEnhanced30) is also available.

Issue History
Date Modified	Username	Field	Change
2015-02-23 18:22	egoitz	New Issue
2015-02-23 18:22	egoitz	Assigned To	=> jonalegriaesarte
2015-02-23 18:22	egoitz	Resolution time	=> 1427065200
2015-02-23 18:25	egoitz	Tag Attached: Performance
2015-02-23 18:25	egoitz	File Added: threaddump-1424712290653.tdump
2015-02-23 18:26	egoitz	File Added: visualvm.png
2015-02-26 10:28	egoitz	Note Added: 0074954
2015-03-09 12:25	jonalegriaesarte	Assigned To	jonalegriaesarte => Sandrahuguet
2015-05-12 13:11	eduardo_Argal	Assigned To	Sandrahuguet => Triage Finance
2015-05-26 13:03	aferraz	Review Assigned To	=> aferraz
2015-05-26 13:03	aferraz	Note Added: 0077756
2015-05-26 13:03	aferraz	Status	new => closed
2015-05-26 13:03	aferraz	Resolution	open => no change required