Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038032Retail ModulesWeb POSpublic2018-03-02 12:552018-03-08 08:43
Reporterumartirena 
Assigned Toranjith_qualiantech_com 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q2 
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
Summary0038032: Product and Product Category Master Data load fails with big amount of discounts
DescriptionProduct and Product Category Master Data load fails with big amount of discounts. These are the exact numbers:
 * m_offer: 157364
 * m_product_category: 2482
 * m_product: 262409

Steps To Reproduce-
Proposed SolutionAdd the following indexes:

create index em_obpos_m_offer_active on m_offer using btree(isactive);

create index em_obpos_m_offer_offertype on m_offer using btree(m_offer_type_id);
Additional Information
TagsPerformance
Relationships
related to feature request 0038744 new Retail Discount Filter Product Master Data fails with big amount of data in Discounts 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-03-02 12:55umartirenaNew Issue
2018-03-02 12:55umartirenaAssigned To => Retail
2018-03-02 12:55umartirenaOBNetwork customer => No
2018-03-02 12:55umartirenaTriggers an Emergency Pack => No
2018-03-02 12:55umartirenaOBNetwork customerNo => Yes
2018-03-02 12:55umartirenaResolution time => 1521759600
2018-03-02 12:55umartirenaTag Attached: Performance
2018-03-02 15:09umartirenaIssue Monitored: umartirena
2018-03-03 07:43ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-03-03 07:44ranjith_qualiantech_comStatusnew => scheduled
2018-03-05 07:48hgbotCheckin
2018-03-05 07:48hgbotNote Added: 0102968
2018-03-05 07:48hgbotStatusscheduled => resolved
2018-03-05 07:48hgbotResolutionopen => fixed
2018-03-05 07:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90605eac7c1000cc69fb9a2964499132194bf8f1 [^]
2018-03-07 14:49hgbotCheckin
2018-03-07 14:49hgbotNote Added: 0103064
2018-03-08 08:43marvintmReview Assigned To => marvintm
2018-03-08 08:43marvintmStatusresolved => closed
2018-03-08 08:43marvintmFixed in Version => RR18Q2
2018-06-13 09:08umartirenaRelationship addedrelated to 0038744

Notes
(0102968)
hgbot   
2018-03-05 07:48   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 90605eac7c1000cc69fb9a2964499132194bf8f1
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Mar 05 12:18:42 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90605eac7c1000cc69fb9a2964499132194bf8f1 [^]

Fixed issue 38032 : Added index for active and offertype column in m_offer table

---
A src-db/database/model/modifiedTables/M_OFFER.xml
---
(0103064)
hgbot   
2018-03-07 14:49   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 51a73b872aa1b4e6a17517df086de2eba18a01ca
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Mar 07 14:49:05 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/51a73b872aa1b4e6a17517df086de2eba18a01ca [^]

Related to issue 38032: Add new index in m_offer by ad_org_id

---
M src-db/database/model/modifiedTables/M_OFFER.xml
---