Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0057983Openbravo ERPI. Performancepublic2025-02-13 17:102025-02-20 10:59
egoitz 
Sathishkumar 
normalmajoralways
closedfixed 
5
 
PR25Q2 
Core
No
0057983: Slowness processing import entries of type VariantChDescUpdate
After execute a massive update that creates lot of products with characteristics, many import entries are created (by the handler ProductCharacteristicValueEventHandler.java [1]).
Procesing that big amount of import entries takes to long.


Only one import entry thread is used (having others free) and around 450 entries per minute are executed:

Some metrics.
minute typeofdata count
13-02-2025 16:49 VariantChDescUpdate 382
13-02-2025 16:48 VariantChDescUpdate 450
13-02-2025 16:47 VariantChDescUpdate 425
13-02-2025 16:46 VariantChDescUpdate 444
13-02-2025 16:45 VariantChDescUpdate 435
13-02-2025 16:44 VariantChDescUpdate 393



[1] https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/blob/master/src/org/openbravo/event/ProductCharacteristicValueEventHandler.java?ref_type=heads#L110 [^]
Import lot of prodcuts that update or create a product ch value so it forces the creating of lot of import entries to update variantch description.

No tags attached.
Issue History
2025-02-13 17:10egoitzNew Issue
2025-02-13 17:10egoitzAssigned To => Triage Platform Base
2025-02-13 17:10egoitzModules => Core
2025-02-13 17:10egoitzTriggers an Emergency Pack => No
2025-02-14 07:30alostaleAssigned ToTriage Platform Base => Triage Omni OMS
2025-02-17 09:55jonaeNote Added: 0175744
2025-02-17 11:14jonaeAssigned ToTriage Omni OMS => Sathishkumar
2025-02-19 08:18hgbotNote Added: 0175851
2025-02-20 10:59hgbotResolutionopen => fixed
2025-02-20 10:59hgbotStatusnew => closed
2025-02-20 10:59hgbotFixed in Version => PR25Q2
2025-02-20 10:59hgbotNote Added: 0175963
2025-02-20 10:59hgbotNote Added: 0175964

Notes
(0175744)
jonae   
2025-02-17 09:55   
Jira - https://openbravo.atlassian.net/browse/RM-21263 [^]
(0175851)
hgbot   
2025-02-19 08:18   
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1545 [^]
(0175963)
hgbot   
2025-02-20 10:59   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo [^]
Changeset: 516d5b11079a73b26674a0661a80f4f27724b738
Author: Sathishkumar palanisamy <sa.palanisamy@external.orisha.com>
Date: 20-02-2025 09:59:38
URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/commit/516d5b11079a73b26674a0661a80f4f27724b738 [^]

Fixes ISSUE-57983: Slowness processing import entries of type VariantChDescUpdate

---
M src/org/openbravo/materialmgmt/VariantChDescUpdateProcessor.java
---
(0175964)
hgbot   
2025-02-20 10:59   
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1545 [^]