Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049498
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorhave not tried2022-06-07 17:082022-06-07 17:08
ReportershuehnerView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0049498: General Ledger Journal Report does not properly implement xsql-scrollable interface (and uses too much memory)

DescriptionIssue 35157 from 2017 converted this report to use the xsql scrollable interface which avoids loading all rows of the result into an Vector or java-array at once.

However the converted code is buggy and loads the scrollable output directly into Vector/java-array defeating the improvement:

Example here:
https://gitlab.com/openbravo/product/openbravo/-/blob/master/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java#L955 [^]

When being worked all scrollable-xsql calls should be reviewed.
Steps To Reproducehttps://gitlab.com/openbravo/product/openbravo/-/blob/master/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java#L955 [^]
Proposed SolutionPass scrollable interface directly into renderJR as intended.
The size=0 check can be probably replaced by scrollable.hasData() call
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0035157 closedAtulOpenbravo The report general ledger journal colapse the system when the query gets thousands of rows 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2022-06-07 17:08 shuehner New Issue
2022-06-07 17:08 shuehner Assigned To => Triage Omni OMS
2022-06-07 17:08 shuehner Modules => Core
2022-06-07 17:08 shuehner Triggers an Emergency Pack => No
2022-06-07 17:09 shuehner Relationship added related to 0035157


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker