Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038231Retail ModulesWeb POSpublic2018-03-26 19:292018-04-26 10:24
Reporterumartirena 
Assigned Toranjith_qualiantech_com 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q3 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038231: Product Master Data Loading is very slow having configured org.openbravo.financial.multitaxcategory module
DescriptionProduct Master Data Loading is very slow having configured org.openbravo.financial.multitaxcategory module.

Number of products: 264546
Steps To ReproduceInstall https://code.openbravo.com/erp/pmods/org.openbravo.financial.multitaxcategory [^] module on a high volumes environment.

Configure "Get Product Tax Category impementation" preference. Value: OBFMTC

Make a full refresh in Web POS. Product query takes long and sometimes even fails.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0037078 closed marvintm C_get_product_taxcategory affects to the performance of the load of product masterdata 
Attached Filesdiff I38231_shortFix.diff (2,437) 2018-04-05 15:35
https://issues.openbravo.com/file_download.php?file_id=11711&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-03-26 19:29umartirenaNew Issue
2018-03-26 19:29umartirenaAssigned To => Retail
2018-03-26 19:29umartirenaOBNetwork customer => Yes
2018-03-26 19:29umartirenaTriggers an Emergency Pack => No
2018-03-26 19:30umartirenaRelationship addedrelated to 0037078
2018-03-26 19:30umartirenaTag Attached: Performance
2018-04-04 09:10ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-04-04 09:10ranjith_qualiantech_comStatusnew => scheduled
2018-04-05 15:34jorge-garciaAssigned Toranjith_qualiantech_com => jorge-garcia
2018-04-05 15:35jorge-garciaFile Added: I38231_shortFix.diff
2018-04-09 11:12jorge-garciaAssigned Tojorge-garcia => ranjith_qualiantech_com
2018-04-09 12:58umartirenaResolution time => 1524088800
2018-04-09 14:55hgbotCheckin
2018-04-09 14:55hgbotNote Added: 0103755
2018-04-12 13:10hgbotCheckin
2018-04-12 13:10hgbotNote Added: 0103841
2018-04-17 13:07umartirenaIssue Monitored: umartirena
2018-04-23 11:04hgbotCheckin
2018-04-23 11:04hgbotNote Added: 0104025
2018-04-23 13:05ranjith_qualiantech_comStatusscheduled => resolved
2018-04-23 13:05ranjith_qualiantech_comResolutionopen => fixed
2018-04-26 10:24marvintmReview Assigned To => marvintm
2018-04-26 10:24marvintmStatusresolved => closed
2018-04-26 10:24marvintmFixed in Version => RR18Q3

Notes
(0103755)
hgbot   
2018-04-09 14:55   
Repository: erp/pmods/org.openbravo.retail.multitaxcategory
Changeset: 1b048d84efd8cb076aa12d6c7014692102c9134a
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Apr 09 18:25:28 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.multitaxcategory/rev/1b048d84efd8cb076aa12d6c7014692102c9134a [^]

Related to issue 38231 : Initial Commit, Created Module

* Added ProductProperties extension to get product multi taxcategory for performance issues

---

---
(0103841)
hgbot   
2018-04-12 13:10   
Repository: erp/pmods/org.openbravo.retail.multitaxcategory
Changeset: 15f680c6a416175aef32fff4b637bbfdad6e8f7f
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Apr 12 16:40:34 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.multitaxcategory/rev/15f680c6a416175aef32fff4b637bbfdad6e8f7f [^]

Related to issue 38231 : Added LoadedProductProperty extension to get taxCategory for LoadedProduct

---
A src/org/openbravo/retail/multitaxcategory/master/TaxCategoryLoadedProductProperties.java
---
(0104025)
hgbot   
2018-04-23 11:04   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 819ac4a1f0fcbbd7ba1b4068528d357c24b3a13f
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Apr 23 14:34:19 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/819ac4a1f0fcbbd7ba1b4068528d357c24b3a13f [^]

Related to issue 38231 : Refactored ProductProperties for Performance issues

* New Module "org.openbravo.retail.multitaxcategory" is created to config product multitax category.
  ProductProperties is extended in new module to fetch the tax category

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