Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051884POS2POSpublic2023-03-16 14:032023-03-23 10:31
Reporteralostale 
Assigned Tojlopez 
PrioritynormalSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version23Q2 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051884: OOM executing Product Perimeter report
DescriptionIf Product Perimeter report is executed for a discount that's applicable to a big amount of products, server gets Out Of Memory.
Steps To ReproduceIn an environment with a few number of products (tested with 80K, but most likely much less is enough):

1. Create a discount leaving all fields as default: Included Products: all excluded defined. So this will apply to all products
2. Click on Product Perimeter Report
  -> OOM
Proposed SolutionMaybe is not such a good idea to try to load in memory the whole table of products: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/blob/master/src/org/openbravo/pos2/process/ProductPerimeterReport.java#L137 [^]
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0049990 closed jlopez [Product Perimeter] - Retrieve CSV file with the list of products to which this discount is applicable to 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-03-16 14:03alostaleNew Issue
2023-03-16 14:03alostaleAssigned To => Retail
2023-03-16 14:03alostaleOBNetwork customer => No
2023-03-16 14:03alostaleTriggers an Emergency Pack => No
2023-03-16 14:03alostaleRelationship addedrelated to 0049990
2023-03-17 09:33aferrazAssigned ToRetail => jlopez
2023-03-20 20:22hgbotMerge Request Status => open
2023-03-20 20:22hgbotNote Added: 0147725
2023-03-23 10:30hgbotMerge Request Statusopen => approved
2023-03-23 10:31hgbotResolutionopen => fixed
2023-03-23 10:31hgbotStatusnew => closed
2023-03-23 10:31hgbotNote Added: 0147887
2023-03-23 10:31hgbotFixed in Version => 23Q2
2023-03-23 10:31hgbotNote Added: 0147888

Notes
(0147725)
hgbot   
2023-03-20 20:22   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1610 [^]
(0147887)
hgbot   
2023-03-23 10:31   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1610 [^]
(0147888)
hgbot   
2023-03-23 10:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: a13eabfcf49101c300b1fb1d23337a3acc2bb4ab
Author: Javier López <javier.lopez@precognis.com>
Date: 23-03-2023 09:31:05
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/a13eabfcf49101c300b1fb1d23337a3acc2bb4ab [^]

Fixes ISSUE-51884: Out Of Memory executing Product Perimeter report

---
M src/org/openbravo/pos2/process/ProductPerimeterReport.java
---