Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0057983Openbravo ERPI. Performancepublic2025-02-13 17:102025-02-20 10:59
Reporteregoitz 
Assigned ToSathishkumar 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR25Q2 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0057983: Slowness processing import entries of type VariantChDescUpdate
DescriptionAfter 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 [^]
Steps To ReproduceImport 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.

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2025-02-13 17:10egoitzNew Issue
2025-02-13 17:10egoitzAssigned To => Triage Platform Base
2025-02-13 17:10egoitzOBNetwork customer => Gold
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:18hgbotMerge Request Status => open
2025-02-19 08:18hgbotNote Added: 0175851
2025-02-20 10:59hgbotMerge Request Statusopen => approved
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 [^]