Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045467Retail ModulesWeb POSpublic2020-11-20 04:172021-02-22 09:34
Reporterlbressan 
Assigned Toprakashmurugesan88 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR21Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045467: Performance issues on the model CharacteristicValue
DescriptionPerformance issues on the model CharacteristicValue that causes a delay in loading the model.
Steps To ReproduceAdd some characteristic values to be load to the POS.
Log in to the POS and review the load time of the model CharacteristicValue.
Proposed SolutionA change in the model is proposed (attached patch)
Additional Information
TagsNOR
Relationships
related to defect 0045144 closed prakashmurugesan88 Retail Modules Fix incremental and full refresh with Multi Tax Category module 
related to defect 0045055 closed ranjith_qualiantech_com Retail Modules Incremental refresh of ProductCharacteristic cannot use index on updated 
related to defect 0044911 closed ranjith_qualiantech_com Retail Modules Incremental refresh of Product cannot use index on updated 
related to defect 0045919 closed rqueralta Retail Modules Extra join of product table in master.product 
related to design defect 0045922 acknowledged Triage Platform Base Openbravo ERP Extra self-join with main table when using computed columns 
Attached Filespatch CharacteristicValue.java.patch (3,060) 2020-11-20 04:17
https://issues.openbravo.com/file_download.php?file_id=15098&type=bug
Issue History
Date ModifiedUsernameFieldChange
2020-11-20 04:17lbressanNew Issue
2020-11-20 04:17lbressanAssigned To => Retail
2020-11-20 04:17lbressanFile Added: CharacteristicValue.java.patch
2020-11-20 04:17lbressanResolution time => 1607554800
2020-11-20 04:17lbressanTriggers an Emergency Pack => No
2020-11-23 10:54marvintmProjectPOS2 => Retail Modules
2020-11-23 10:55marvintmCategoryCore => Web POS
2020-12-09 06:49prakashmurugesan88Assigned ToRetail => prakashmurugesan88
2020-12-09 06:49prakashmurugesan88Statusnew => scheduled
2020-12-10 05:54hgbotNote Added: 0124735
2020-12-10 08:18hgbotResolutionopen => fixed
2020-12-10 08:18hgbotStatusscheduled => closed
2020-12-10 08:18hgbotNote Added: 0124743
2020-12-10 08:18hgbotFixed in Version => RR21Q1
2020-12-10 08:18hgbotNote Added: 0124744
2021-02-18 17:18rafarodaTag Attached: NOR
2021-02-22 09:33rafarodaRelationship addedrelated to 0045144
2021-02-22 09:34rafarodaRelationship addedrelated to 0045055
2021-02-22 09:34rafarodaRelationship addedrelated to 0044911
2021-02-22 10:48rafarodaRelationship addedrelated to 0045919
2021-02-22 10:48rafarodaRelationship addedrelated to 0045922

Notes
(0124735)
hgbot   
2020-12-10 05:54   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/205 [^]
(0124743)
hgbot   
2020-12-10 08:18   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/205 [^]
(0124744)
hgbot   
2020-12-10 08:18   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 17734b893154c41e8ac00c7be8992c53689032cf
Author: Prakash M <prakash@qualiantech.com>
Date: 2020-12-10T07:18:19+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/17734b893154c41e8ac00c7be8992c53689032cf [^]

Fixed BUG-45467: Fixes performance issues on the model CharacteristicValue

---
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
---